Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Moving Between Worksheets Using Same Cell Address
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Moving Between Worksheets Using Same Cell Address
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Moving Between Worksheets Using Same Cell Address
T Renner Wrote: 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 I know what you need.. I'm familiar with both Quattro and Excel but there is no way to do that in Excel as far as I know... Your only option is to Group, select the cell, go to the Worksheet and move one of the arrows on your keyboard.. this would place it near at least ;) -- ArenaNinja ------------------------------------------------------------------------ ArenaNinja's Profile: http://www.excelforum.com/member.php...o&userid=33624 View this thread: http://www.excelforum.com/showthread...hreadid=547851 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Moving Between Worksheets Using Same Cell Address
Thanks for the help. I just tried it and it gets me close enough.
-- T Renner "ArenaNinja" wrote: T Renner Wrote: 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 I know what you need.. I'm familiar with both Quattro and Excel but there is no way to do that in Excel as far as I know... Your only option is to Group, select the cell, go to the Worksheet and move one of the arrows on your keyboard.. this would place it near at least ;) -- ArenaNinja ------------------------------------------------------------------------ ArenaNinja's Profile: http://www.excelforum.com/member.php...o&userid=33624 View this thread: http://www.excelforum.com/showthread...hreadid=547851 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Master Worksheet populated by other Worksheets? | Excel Worksheet Functions | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
HOW TO KEEP TEXT FROM MOVING OUT OF A CELL? | Excel Discussion (Misc queries) | |||
moving from cell to cell | Excel Discussion (Misc queries) | |||
How do I find the contents of a cell using the "ADDRESS" function. | Excel Worksheet Functions |