ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Multiple screen splits for same worksheet in Excel (https://www.excelbanter.com/excel-discussion-misc-queries/87886-multiple-screen-splits-same-worksheet-excel.html)

MTanner

Multiple screen splits for same worksheet in Excel
 
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.

CLR

Multiple screen splits for same worksheet in Excel
 
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




"MTanner" wrote:

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.



All times are GMT +1. The time now is 07:22 AM.

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