Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Shortcut
When I select a cell containing a formula which includes cells from different
worsheets and press ctrl [ I am not taken to the specefic cell. How do I activate this shortcut? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Shortcut
Ctrl + [ will take you to the cell which is referenced first in the formula...
For example A1+Sheet2!A1+Sheet3!A1 --- will take you to the same sheet A1 Sheet2!A1+Sheet3!A1+A1 --- will take you to sheet2 A1 Sheet3!A1+Sheet2!A1+A1 --- will take you to sheet3 A1 If this post helps click Yes --------------- Jacob Skaria "Sozos" wrote: When I select a cell containing a formula which includes cells from different worsheets and press ctrl [ I am not taken to the specefic cell. How do I activate this shortcut? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Shortcut
Hi Sozos,
one of the reason could be, if the cell is having first reference to a different workbook, which is not available at that moment. -- Click on Yes, if it is useful. Thanks & Best Regards, Dilip Kumar Pandey MBA, BCA, B.Com(Hons.) New Delhi, India "Sozos" wrote: When I select a cell containing a formula which includes cells from different worsheets and press ctrl [ I am not taken to the specefic cell. How do I activate this shortcut? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Shortcut | New Users to Excel | |||
Excel shortcut | Excel Discussion (Misc queries) | |||
Excel Spanish Shortcut | Excel Discussion (Misc queries) | |||
Excel 2007 '/' Shortcut | Excel Discussion (Misc queries) | |||
MS Excel shortcut | Excel Discussion (Misc queries) |