Multiple screen splits for same worksheet in Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to view the top of the worksheet, and the bottom of the worksheet
as fixed (they don't scroll or move) and scroll the middle of the worksheet.
 
You can highlight the part of ths sheet you wish to view at the bottom of the
sheet, then do CtrlShiiftEdit > SopyPicture > AsShownOnScreen > OK, and then
paste it above the Window-Freeze line and below the top-part of the sheet,
then you can see both the top and the bottom of the sheet in the top half of
the screen, and can scroll the middle below the freeze line.........

hth
Vaya con Dios,
Chuck, CABGx3
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Unable to use mouse for scrolling 5
When sharing, can I force an Excel document to open in a certain view? 0
Hyperlink to move the cursor to the top of the frozen panes 3
Split Windows 2
Select Cell A1 5
linking to a hidden worksheet 2
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel Columns moving up and down on their own in a worksheet. What Goes? 2

Back
Top