![]() ![]() And now, follow the already familiar path, i.e View tab > Freeze panes > and again Freeze panes.For example, if you want to freeze the first 3 columns (A – C), select the entire column D or cell D1. ![]() Select the column to the right of the last column you want to freeze.Select View > Freeze Panes > Freeze Panes. Select the cell below the rows and to the right of the columns you want to keep visible when you scroll. How do you freeze selected cells in Excel? When the Format Cells window appears, select the Protection tab. Right-click and then select “Format Cells” from the popup menu. To lock multiple columns, select the column to the right of the last column you want frozen, choose the View tab, and then click Freeze Panes. To lock multiple rows (starting with row 1), select the row below the last row you want frozen, choose the View tab, and then click Freeze Panes. How do I freeze multiple rows in Excel 2007? 18 How do I protect all sheets in Excel?.16 How do you freeze columns in sheets?.15 How do you keep one cell constant in Excel?.13 How do I freeze the first two columns in Excel?.12 What is the shortcut key to freeze multiple columns in Excel?.10 What is the shortcut to lock cells in Excel?.9 How do I protect an Excel 2007 spreadsheet with a password?.8 How do I lock cells in Excel 2007 without protecting?.3 How do you freeze selected cells in Excel?.2 How do I lock a column in Excel 2007?.1 How do I freeze multiple rows in Excel 2007?.
0 Comments
Leave a Reply. |