Worksheet

C

cojo

Is there a way to move from one worksheet to another and stay in the same cell? For example, in Worksheet1, you need to input data in cell A5 and A6. Now you need to go to Worksheet2 and enter different information, but still in cell A5 and A6. So no matter where you start in the first Worksheet, can you go to the next worksheet and be in the same cell

Thanks for any help.
 
K

Ken Wright

Select all sheets, then select the cell in question, now ungroup the sheets
[MAKE SURE YOU DO THIS], and then use CTRL+PGUP or CTRL+PGDOWN to navigate the
sheets

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :)
----------------------------------------------------------------------------



cojo said:
Is there a way to move from one worksheet to another and stay in the same
Click to expand...
cell? For example, in Worksheet1, you need to input data in cell A5 and A6.
Now you need to go to Worksheet2 and enter different information, but still in
cell A5 and A6. So no matter where you start in the first Worksheet, can you go
to the next worksheet and be in the same cell?
 
K

Ken Wright

You're welcome - Just make sure you ungroup else you will affect every sheet in
the file when you enter data.
 
Top