1
Click the first cell of the column
Click the cell in row 1 at the top of the column.
How to name a column in Google Sheets
Give each column a name by typing headers in row 1, then freeze the row so the names stay visible.
Operations
2
Type the column name
Type a name for the column - here, Item.
3
Press Tab
Press Tab to move to the next column.
4
Name the next column
Type the next name - here, Stock.
5
Press Enter
Press Enter to confirm.
6
Click View
Open the View menu.
7
Click Freeze
Hover over Freeze.
8
Click 1 row
Choose 1 row so the column names stay on screen when you scroll.
9
Columns named
Row 1 now holds the column names and stays put as you scroll.
Make this walkthrough your own
Duplicate this template, swap in your own screens, and share it with your team. Free to start — no credit card.