ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Freeze column and row (https://www.excelbanter.com/new-users-excel/69372-freeze-column-row.html)

vapor77

Freeze column and row
 

Can someone please tell me how to freeze a column and a row at the same
time?

Thanks


--
vapor77
------------------------------------------------------------------------
vapor77's Profile: http://www.excelforum.com/member.php...o&userid=31132
View this thread: http://www.excelforum.com/showthread...hreadid=508190


Pete

Freeze column and row
 
If you want Row 1 and column A to be visible on screen all the time as
you scroll around, position the cursor in cell B2 and click Window |
Freeze Panes.

Hope this helps.

Pete


vapor77

Freeze column and row
 

Now that was a lot easier than I thought it would be. Thank you for the
help Pete!


--
vapor77
------------------------------------------------------------------------
vapor77's Profile: http://www.excelforum.com/member.php...o&userid=31132
View this thread: http://www.excelforum.com/showthread...hreadid=508190


Pete

Freeze column and row
 
That's ok, thanks for getting back.

Pete



All times are GMT +1. The time now is 08:03 AM.

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