How to freeze rows and columns in Excel

How: View ▸ Freeze, then choose “1 row” for the header, “1 column” for the first column, or “Up to current row / column” to freeze at the selected cell; choose “No rows / columns” to undo. Drop your sheet below (or use the sample) and the online spreadsheet opens with the top row and first column already frozen — scroll around. Download it as .xlsx and the freeze still works in Excel and WPS.

Excel 또는 CSV 파일을 끌어다 놓기

Online spreadsheet · no sign-up · saved in the .xlsx

사용 방법

  1. 1 Drop a sheet, or try the sample
  2. 2 It opens with the top row and first column frozen — scroll
  3. 3 To adjust: View ▸ Freeze

할 수 있는 것

  • Freeze the top row / first column / first N rows or columns
  • Freeze up to the selected cell
  • The freeze survives in the downloaded .xlsx
  • Scrolls on phones too

할 수 없는 것

  • You cannot freeze rows in the middle — freezing always starts at the top / left
  • PDF export does not repeat headers on each page — that is Print titles, a different setting
  • .csv files cannot store a freeze — CSV holds data only

자주 묻는 질문

Is freezing the same as repeating headers when printing?

No. Freezing only affects on-screen scrolling; repeating headers on printed pages is the Print titles setting.

How do I unfreeze?

View ▸ Freeze ▸ No rows, and No columns.

Is the freeze saved?

Yes — it is stored in the file and still frozen when opened in Excel or WPS.

Can I freeze rows and columns together?

Yes, set them separately — e.g. the first 2 rows and the first column.

How do I freeze on a phone?

Tap the ☰ menu ▸ View ▸ Freeze.

Do I need to sign in?

No. Sign in only if you want to save to the cloud.