![]() The columns contain the headers as Day, Date, Regular Hours, Overtime Hours, Sick, Vacation & Total. ![]() Step 1: The sheet below shows the timesheet of a company. ![]() It is not necessary that only the row or the column can be locked at a single instance. It is to be noted that we can freeze Rows as well as columns together also. The ‘Freeze Top Row’ command freezes the row number ‘1’ & the ‘Freeze First Column’ command freezes the column number A cell. These commands are used only for freezing the top row and the first column, respectively. There are two other commands as well in the Freeze panes options, which are ‘Freeze Top Row’ & ‘Freeze First Column.’ As we can see in the snapshot below, the columns beside the grey line are frozen and do not move after we scroll the worksheet.įor unfreezing the columns, we use the same process as we did in the case of Rows, i.e., by using the unfreeze panes command from the view tab. We can scroll the entire worksheet & continuing viewing the frozen Columns.
0 Comments
Leave a Reply. |