| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
2007 Structured Reference auto-completion not working completely?
In Excel 2007, when I:
1) Select a cell 2) Type "=" in the formula bar 3) Click a cell in a Table I thought Excel would add a Structured Reference to the formula. Instead, it just inserts an old-style, "A1" reference. The "Formula AutoComplete" and "Use table names in formulas" options are both turned on. When I click the cell in step 3, the TableTools tab appears so Excel agrees that the cell is in a Table. Isn't Excel supposed to insert a Structured Reference when you click a cell in a Table? Is there another setup/configuration switch somewhere I need to turn on? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Structured reference does not return correct value | Excel Worksheet Functions | |||
| auto completion | Excel Discussion (Misc queries) | |||
| VLOOKUP with Structured Reference to Table Header | Excel Worksheet Functions | |||
| Autofilter Not working completely | Excel Discussion (Misc queries) | |||
| Making a structured reference absolute? | Excel Worksheet Functions | |||
Threaded Mode
