Note that the left-most column gets fixed. To freeze the first column: ALT + W + F + C.To freeze the top row: ALT + W + F + R.Here are the shortcuts for freezing rows/columns: What is the shortcut key to freeze multiple rows in Excel? The rows will be frozen in place, as indicated by the gray line. Select the Freeze Panes command, then choose Freeze Panes from the drop-down menu.In our example, we want to freeze rows 1 and 2, so we’ll select row 3. Select the row below the row(s) you want to freeze.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.Excel inserts a thin line to show you where the frozen pane begins. FREEZE TOP 3 ROWS IN EXCEL 2016 WINDOWS
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |