Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Split screens
I have a large wookbook with multiple column groups. I want to split these
column groups & be able to scroll up & down within the group and all the other column groups not move. When I split the column, it only shows the scroll bar at the bottom to scroll left or right. Is there a way to be able to scroll up & down within the column group? I will also need muliple splits & I can't seem to get that either. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Split screens
Fro what you're wanting to accomplish, and for the amount of splits required,
it would probably be easier to create new windows as opposed to splits. With your workbook open within a session of XL, go to Window, New Window. Repeat this step for as many "splits" as you wanted. Now go to Window, Arrange, (pick your preference). You now have multiple views of the same workbook, that you can individually adjust. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Tammyg" wrote: I have a large wookbook with multiple column groups. I want to split these column groups & be able to scroll up & down within the group and all the other column groups not move. When I split the column, it only shows the scroll bar at the bottom to scroll left or right. Is there a way to be able to scroll up & down within the column group? I will also need muliple splits & I can't seem to get that either. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Non synchronisation in split screens in Microsoft Excel | Excel Discussion (Misc queries) | |||
How do I get rid of split screens in emailed spread sheets? | Setting up and Configuration of Excel | |||
Multiple split screens | Excel Discussion (Misc queries) | |||
Hourglass comes up when going between split screens. | Excel Worksheet Functions | |||
Two Screens??? | Excel Discussion (Misc queries) |