Microsoft Office Forums - View Single Post - [Solved] Possible to freeze both a column and a row?

Thread: [Solved] Possible to freeze both a column and a row?

View Single Post

Old

03-11-2012, 09:47 AM

Colin Legg Colin Legg is offline

Colin Legg is offline

Colin Legg uses Windows 7 32bit

Windows 7 32bit Colin Legg uses Office 2010 32bit

Colin Legg uses Office 2010 32bit

Office 2010 32bit

Expert

Join Date: Jan 2011

Location: UK

Posts: 369

Colin Legg will become famous soon enough

Default

Hi Bryan,

Yes this is possible. Select the cell B6 and then go to View > Freeze Panes > Freeze Panes. Column A and Rows 1:5 will then be frozen.

Reply With Quote