![]() |
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 |
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