LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 106
Default Select a formula / range from Excel drop down suggestions

As we enter a formula in a cell, Excel finds matches of what is being written
comparing it to (all) formulas and ranges of the current workbook and
displays them in a drop down box just beneath the cell.
Can someone please tell me if there is a key combination that inserts the
currently selected list item in the formula being written and save me the
trouble of writing the whole thing by hand??
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
drop down list with auto suggestions constantinos Excel Worksheet Functions 1 June 14th 08 10:28 PM
select range from drop down list LDP Analyst[_2_] Charts and Charting in Excel 0 January 29th 08 08:38 PM
suggestions on creating a text value based on a date range Allen Clark Setting up and Configuration of Excel 0 June 28th 06 02:44 AM
formula to select numbers from a range mark (plymouth) Excel Worksheet Functions 1 February 14th 06 05:09 PM
dynamically select a range of cells for use in a formula isofuncurves Excel Worksheet Functions 1 February 2nd 06 01:34 AM


All times are GMT +1. The time now is 09:59 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"