ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   keep a group of row/columns scrolling up or down? (https://www.excelbanter.com/excel-discussion-misc-queries/133201-keep-group-row-columns-scrolling-up-down.html)

LyndaV

keep a group of row/columns scrolling up or down?
 
I would like to create a spreadsheet that would prevent the top rows from
scrolling. Keeping them locked in place and the rows below that to scroll
up.

Like wise will this apply to columns as well? Say if you have a list of
names that contains alot of info with in the row but you need to continue to
see who the infor appiles to...

John

keep a group of row/columns scrolling up or down?
 
You need to click in the cell below and to the right of the ones you want to
freeze and click windowsfreeze panes
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"LyndaV" wrote:

I would like to create a spreadsheet that would prevent the top rows from
scrolling. Keeping them locked in place and the rows below that to scroll
up.

Like wise will this apply to columns as well? Say if you have a list of
names that contains alot of info with in the row but you need to continue to
see who the infor appiles to...



All times are GMT +1. The time now is 07:13 PM.

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