In Excel, we have the possibility to lock rows or columns.
What do I mean by “locking”.
For example, if you have a very long list, and you scroll down, you will no longer see the titles in the columns.
No problem when all the data in the columns are clear.
For example Name – Address – Postal code and City.
But what if the data in the different columns is not so obvious.
A solution to this is to lock the row with the titles.
Then you can lock the row or column with the titles, and you can scroll as much as you like, the titles will always remain visible
We choose the tab “Image” in the ribbon, and click “lock”.
In the drop-down menu that appears we have three options:
To lock titles:
will lock the parent row, and the column on the left, from the selected cell.
lock upper row :
will lock the top row from our worksheet
lock first column:
will lock the first column, column A, in your worksheet.
Click on your choice. You see in your spreadsheet, indicated by the black lines, where Excel has applied the lock:
To unlock, click “lock panel” again, and choose “Cancel title lock”.
Another way to view different areas from our worksheet is to “split” the window.
The “Split” option can be found in the “Image” tab in the ribbon, under the “Window” group.
The window will split, left off, and above the selected cell.
The difference with the “lock” option is that when you split a window, three of the four windows have their own scrollbars.
This allows you to view different areas of the worksheet at the same time.
You can move the split by moving the mouse pointer over a bar, and when it changes into a four-part arrow, you can drag and drop with the bar.
A second way to split a window is to click and drag with the split bar buttons.
These are the vertical and horizontal bars, top right and bottom right of the scroll bars.
The split locks have disappeared since Excel 2013
Sometimes you come to the conclusion that the data in columns must be in rows, and the data in rows must be in columns.
Transposing is what we call this.
In Excel, we can do this in a fairly simple way.
Select the data you wish to transpose, and click the keyboard shortcut Ctrl + C on your keyboard.
Select another worksheet or an empty place in the worksheet that you are copying from.
You click it to the teaching arrow under the “Paste” button, and you click the “Transpose” button.
The example is not so logical in this case, but you see, the columns have become rows and the rows of columns.