| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Splitting Panes
I need to ve able to view two parts of the worksheet at the same time however
I need to be able to scroll down each part separately. I tried splitting the panes but I don't get the results I need when I scrollp or down. Thanks for your help!! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Splitting Panes
Go to WindowNew Window. In the new window, the same worksheet should be up
(if not, open it). Then, go to WindowArrange, and choose one of the view options. For what you want, I think Horizontal would be the best choice. You can now scroll and see both areas of your worksheet! This also works to view/compare different worksheets, or even workbooks. Hope that helps. --Lauren "mercedes" wrote: I need to ve able to view two parts of the worksheet at the same time however I need to be able to scroll down each part separately. I tried splitting the panes but I don't get the results I need when I scrollp or down. Thanks for your help!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to freez more five columns without splitting the panes? | Excel Worksheet Functions | |||
| Frozen panes in Excel should stay put when using autofilter. | Excel Discussion (Misc queries) | |||
| splitting panes in excel | Excel Discussion (Misc queries) | |||
| How do i use multiple splits or frozen panes? | Excel Discussion (Misc queries) | |||
| Shared File & Freeze panes issue | Excel Discussion (Misc queries) | |||
Linear Mode
