+ Reply to Thread
Results 1 to 3 of 3

How to trigger multiple cell smart text suggestions from Excel?

  1. #1
    Registered User
    Join Date
    07-10-2012
    Location
    London, England
    MS-Off Ver
    Excel 2013
    Posts
    22

    How to trigger multiple cell smart text suggestions from Excel?

    I have topics in column A and what to create a friendly URL of the most important words of those topics in column B (so NOT the entire topic name).
    I started to manually fill this out, like so:

    Please Login or Register  to view this content.
    Now after completing a few values in column B already, I was typing in column B4 and started typing "warm" and all of a sudden cell B4 got a suggested text "warm-weather-wedding", which was exactly what I needed. Not only that, but also the rest of column B (from B5 downwards wherever I have a value in column A) was prepopulated with similar text suggestions...also an Excel hint appeared. It seemed as if Excel knew I was trying to get the most important words from column A, and suggested text for that to enter in column B. I did not accept those suggestions (I believe I pressed Escape), but afterwards thought it was exactly what I needed. I now cannot reproduce that behavior anymore...is anyone familiar with this feature in Excel and how can I trigger it again?

  2. #2
    Valued Forum Contributor Kamboj's Avatar
    Join Date
    09-25-2014
    Location
    India
    MS-Off Ver
    2003 - 2010
    Posts
    430

    Re: How to trigger multiple cell smart text suggestions from Excel?

    when you type text in b2 col just put this in c2 col
    Please Login or Register  to view this content.
    this will show the next words from types text in col b
    Attached Files Attached Files
    Kamboj
    _________________________________________________________________________________
    Mark the thread as SOLVED if my answer satisfy you.

  3. #3
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,655

    Re: How to trigger multiple cell smart text suggestions from Excel?

    That is a new feature of Excel-2013 known as Flash Fill.
    After manipulating one cell in the next column, if you want to follow the same pattern in the cells below, select the first cell you just manipulated and press Ctrl+E and the cells below will be filled according to that pattern.

    Hope this helps.
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Re: Cell (text contents) act to trigger multiple cells.
    By Mr.Magoo in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-09-2014, 03:47 AM
  2. Adjust a code from cell range trigger to button trigger
    By ld2x07 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-01-2014, 10:02 AM
  3. I need a code to serch text in smart art in excel and where found highlight
    By ROHAN999 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 11-12-2013, 01:05 PM
  4. Auto execute a macro to trigger when text is written in a cell
    By mhickey in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 03-02-2012, 04:56 PM
  5. Replies: 2
    Last Post: 01-07-2012, 05:29 AM
  6. Replies: 1
    Last Post: 12-02-2010, 03:46 PM
  7. Excel smart text reading or filtering
    By murali_crish in forum Excel General
    Replies: 0
    Last Post: 08-03-2010, 07:54 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1