G Guest Oct 29, 2003 #1 Does anyone know how to freeze cells so they stay in one place while you scroll the rest of the sheet?
Does anyone know how to freeze cells so they stay in one place while you scroll the rest of the sheet?
C Chip Pearson Oct 29, 2003 #2 Select cell A2 and choose Freeze Panes from the Window menu. This will freeze row 1 at the top of the screen. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (e-mail address removed) RaeJenUser said: Does anyone know how to freeze cells so they stay in one place while you Click to expand... scroll the rest of the sheet?
Select cell A2 and choose Freeze Panes from the Window menu. This will freeze row 1 at the top of the screen. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (e-mail address removed) RaeJenUser said: Does anyone know how to freeze cells so they stay in one place while you Click to expand... scroll the rest of the sheet?
