ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Splitting Panes (https://www.excelbanter.com/excel-discussion-misc-queries/124380-splitting-panes.html)

mercedes

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!!

Lauren Giles

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!!



All times are GMT +1. The time now is 09:44 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com