ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Lock column/row in place (https://www.excelbanter.com/excel-discussion-misc-queries/100849-lock-column-row-place.html)

pelachrum

Lock column/row in place
 

I'm on Excel 2004, Mac version.

I can't seam to figure out how to lock rows or columns so that when you
scroll the screen those columns/rows stay in place (like the top row for
column headings etc)


--
pelachrum
------------------------------------------------------------------------
pelachrum's Profile: http://www.excelforum.com/member.php...o&userid=35962
View this thread: http://www.excelforum.com/showthread...hreadid=564169


Nick Hodge \(MVP\)

Lock column/row in place
 
Try (To lock top row and far left column, click in B2)

Windowfreeze panes

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England

HIS
www.nickhodge.co.uk
"pelachrum" wrote
in message ...

I'm on Excel 2004, Mac version.

I can't seam to figure out how to lock rows or columns so that when you
scroll the screen those columns/rows stay in place (like the top row for
column headings etc)


--
pelachrum
------------------------------------------------------------------------
pelachrum's Profile:
http://www.excelforum.com/member.php...o&userid=35962
View this thread: http://www.excelforum.com/showthread...hreadid=564169





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

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