View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
T Renner
 
Posts: n/a
Default Moving Between Worksheets Using Same Cell Address

I just used the shift key to select 5 pages to experiment with. This time is
did work as far as being able to go to the next page and have the cell
selected but I still had to scroll around to find it. I just switched from
Quattro Pro to Excel this year and my old program would center the selected
cell on the screen when I changed pages. I don't suppose there is any way to
get the grouped pages to orient themselves on the screen so that the selected
cell will always be visible when you go to the page.
Thank you for your quick reply and help.
--
T Renner


"SiC" wrote:

Do you mean you can't group the sheets together or you can't select the same
cell after grouping the sheets? If done correctly, the Excel title bar
should show "[Group]" right after the file name. And if you select a cell in
one of the grouped sheets, the same cell should be selected as you move to
any other grouped shets.

-Simon

"T Renner" wrote:

I tried grouping my pages and selecting a cell as I used to do in Quattro Pro
but it
doesn't work in Excel. If I want to look at the same cell when I move to the
next page, how do I set it to do that. I know I could use the Go To function
but that is not very speedy. Thanks for any help that is out there.
--
T Renner