Freeze rows or columns
Excel offers options to freeze the top row whatsapp number in canada of the table, the first column, or the panes. To freeze the row, follow these steps: Select the View section -> Click on Freeze -> Then choose Freeze Top Row and that's it. Follow the same steps to freeze the first column and finally choose Freeze First Column. And the same with the panes.
This function is very important when working with a large volume of information to have a reference for the indicated content.
Example 1: You can use column freezing for classroom monitoring by putting names in the first column and absence and attendance information throughout the year in subsequent columns. This way, even if you scroll the worksheet forward, the names will always appear in the first column.
Example 2: Freezing the top row can help in a contact list. In the top row we put the “category name” (Name, phone, email, address) and below that the data for each person.
Move to the last line with 1 command
How do you do this? You use the shortcut Ctrl + down arrow . This takes you to the last row of your spreadsheet. The same thing happens when you use Ctrl + arrow in the other directions (up – goes to the first row; right – goes to the last column; left – goes to the first column).