ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Keeping certain columns/rows visible (https://www.excelbanter.com/excel-discussion-misc-queries/215781-keeping-certain-columns-rows-visible.html)

MichaelPhilips

Keeping certain columns/rows visible
 
I know there's a way to keep certain columns or rows visible when you scroll
around the excel sheet, but I don't know what that's called or how to do it.
Can anyone help? Many thanks.

FSt1

Keeping certain columns/rows visible
 
hi
you might be thinking of freeze panes. this is were you can keep a number of
rows at the top and/or column at the left "frozen" while you scroll.
just place the cellpointer at the place below the rows you want to freeze or
to the right of the columns and...
in 2003, on the menu barwindowfreeze panes.

Regards
FSt1

"MichaelPhilips" wrote:

I know there's a way to keep certain columns or rows visible when you scroll
around the excel sheet, but I don't know what that's called or how to do it.
Can anyone help? Many thanks.


Jack Gopher

Keeping certain columns/rows visible
 
It is called "Freeze Panes", you can see a video demonstration over he

http://www.free-training-tutorial.com/rows-columns.html




"MichaelPhilips" wrote:

I know there's a way to keep certain columns or rows visible when you scroll
around the excel sheet, but I don't know what that's called or how to do it.
Can anyone help? Many thanks.



All times are GMT +1. The time now is 02:24 AM.

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