[Google Sheets] How to fix rows and columns of Google sheets
When you use a spreadsheet, it is sometimes convenient to fix a header or title if you have more content. This time, I'm going to post how to fix the header or title.
- Number 1 looks like a fixed row.
- Number 2 is Mo that holds the heat.
Fixing a Row
Fixing rows is the first row of the sheet, and the second row can be fixed by default. You can also fix it based on where the current cursor is located.
- First, select the row you want to pin.
- Select View from the top menu.
- Select Fix.
- Select the menu for fixation.
- No row fixation : Initializes row fixation.
- row 1: Fix the first row, so row 1.
- 2 rows ** : Fix the second row, so row 2.
- Up to row : You can fix it based on the currently selected row. If you select the fifth row with your mouse, you will see **until the fifth.
This creates a horizontally thick gray line like above and does not scroll up.
Fixing Heat
Column fixation can be specified in the same way as row fixation.
The method is the same as holding a row.
Comments