How do I set up rows or columns that don't move when I move the rest of the workbook?
S Starlette Aug 11, 2004 #1 How do I set up rows or columns that don't move when I move the rest of the workbook?
C Chip Pearson Aug 11, 2004 #2 Select the top left cell of the range you want to scroll, and choose Freeze Panes from the Window menu. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com message news:[email protected]...
Select the top left cell of the range you want to scroll, and choose Freeze Panes from the Window menu. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com message news:[email protected]...
H Harald Staff Aug 11, 2004 #3 Select the first cell that's allowed to move (Like A2 or B1 or C4, try all ways for testing) and go menu Window > Freeze panes. HTH. Best wishes Harald
Select the first cell that's allowed to move (Like A2 or B1 or C4, try all ways for testing) and go menu Window > Freeze panes. HTH. Best wishes Harald
