Excel automatically adds a dark grey vertical line to indicate that the first column is frozen. On the View tab, in the Window group, click Freeze Panes. The first four columns will now freeze, and a gray line will show, indicating that the columns are frozen. To freeze the first column, execute the following steps. Finally, select "Freeze Panes under that." Check the spreadsheet window and click the "View tab."ĥ. In this example, we will freeze the first four columns.Ģ. Firstly, you should be sure of the number of columns to freeze. Now, let's see what we can do that from the ribbon tabs:ġ. You can quickly freeze multiple columns by using this shortcut: You can use it to apply the "first column freezing option" within a blink.Įxcel allows you to freeze several columns, and the procedure is similar to freezing the first column. There is a shortcut for freezing the first column. Viola! Your first column will not move, and you now see it while navigating across the excel spreadsheet. Firstly, identify and select the worksheet.Ģ. Follow the steps below to freeze the first column.ġ. This first column, in this case, refers to the first column on the spreadsheet, not minding where the data starts. When you freeze the first column, you will notice it all the time, and it will not move even when you navigate the excel spreadsheet from left to right. As such, there is a need to freeze such columns so that they will not move even when the rest of the columns are moving.Įxcel gives room for users to freeze the first column, multiple columns as well as rows. Columns may contain important data that you wish to be looking at while performing other tasks. While working, you will scroll and navigate through the various columns. We mentioned in our previous tutorials that excel contains a multiplicity of columns and rows.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |