|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
June 23rd, 2009, 07:21 AM
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
June 23rd, 2009, 07:36 AM
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
June 23rd, 2009, 09:46 AM
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?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
