[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.

Sample to fix rows and columns

  1. Number 1 looks like a fixed row.
  2. 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.

  1. First, select the row you want to pin.
  2. Select View from the top menu.
  3. Select Fix.
  4. Select the menu for fixation.
    1. No row fixation : Initializes row fixation.
    2. row 1: Fix the first row, so row 1.
    3. 2 rows ** : Fix the second row, so row 2.
    4. 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

Popular posts from this blog

CSS에서 ellipsis('...')를 처리하는 방법

nano에디터 소개 및 사용법

Google 스프레드시트로 구글캘린더에 일정 연동하는 방법