OmniDocFreeze Headers and Columns in a Pivot Table
Keep pivot table column labels visible while scrolling: freeze the header row, freeze row labels, and set column widths so the text stays readable.
A long pivot table loses its usefulness when you scroll. A summary with a few hundred rows can push the column labels off the screen after a dozen or so rows, and then you are guessing which number belongs to which region or quarter. A pivot table freeze header setting fixes this by holding the column labels in place while the rows scroll underneath.
This guide is for anyone who builds, shares or reads pivot tables in a spreadsheet program. You will learn how to freeze the header row, keep the row labels visible when you scroll sideways, and set column widths so the text stays readable. The method is the general spreadsheet approach, because freezing is a view setting that works the same way across common programs.
If your pivot table came from a PDF, the setup is slightly different. You will need an editable copy first, and the steps below show how to get one.
How do you set a pivot table freeze header? The short answer
Select the cell just below the column labels and just to the right of the row labels, then use the freeze panes option in your spreadsheet program's view settings.
| Your situation | What to do | Why |
|---|---|---|
| Column labels sit in the top rows of the sheet | Freeze everything above the first row of data | The labels stay visible while you scroll down |
| You scroll sideways through a wide pivot | Freeze the column with the row labels as well | Row names remain on screen with the numbers |
| Report filters sit above the table | Move the filters to the side, or accept a taller frozen area | Filters above the header take up frozen space |
| The pivot table is inside a PDF | Export it to XLSX, then freeze in the sheet | Freezing only applies to spreadsheet cells |
Before you start
- Confirm the pivot is in a spreadsheet sheet. Freeze panes does not apply to a PDF page. To check a PDF, try selecting a single number. If you can select only the whole page or a picture of it, the table is not editable and you need an XLSX copy first.
- Count the rows above the column labels. Freezing keeps everything above and to the left of your selected cell in place. If the title and filters take up 15 rows, that is 15 rows locked on screen.
- Decide which columns must stay visible. Freezing the leftmost column keeps only the columns to its left. If your row labels span two columns, freeze past both of them.
- Save a copy of the file. Freezing does not change your data, but moving filters or rearranging fields does change the pivot's structure. A copy lets you test the layout without risk.
- Expect widths to shift after a refresh. A refresh can rebuild the table and reset column widths. Plan to check widths again whenever you update the source data.
Freezing the pivot table header, step by step
- Open the file and go to the sheet with the pivot table. Freeze settings are saved per sheet, so you need to work on the sheet that holds the table.
- Scroll until the column labels are near the top of the window. The freeze is set from the current view, so this keeps the labels where you expect them.
- Click the cell just below the column labels and just right of the row labels. This cell marks the split. Everything above and to the left of it will stay fixed.
- Open the view settings in your spreadsheet program and choose the freeze panes option. The exact wording differs between programs, so look for the option that freezes at the selected cell.
- If you only need the header, freeze the top rows and skip the column split. Choose this when your row labels are short or you rarely scroll sideways.
- Scroll down and then sideways to confirm the freeze. The column labels should stay put when you move down, and the row labels should stay put when you move right.
- Set column widths so labels are not cut off. Double-click the border between two column letters to fit the widest entry, or drag the border to set a width by hand.
- Save the file. The freeze and the column widths are stored with the file, so they appear again the next time you open it.
If the pivot table is in a PDF, first use the PDF editor's export option to create a spreadsheet copy, then start at step 1 on that copy. The original PDF cannot take a freeze setting.
Check the result
Run through these checks once the freeze is in place.
| Check | How to see it | If it's wrong |
|---|---|---|
| Column labels stay put | Scroll down about 50 rows | Freeze again from the cell directly below the labels; you may have selected a cell too high or too low |
| Row labels stay put | Scroll sideways across the table | Freeze at a cell one column further right so the label column is included |
| Labels are fully readable | Look for truncated text or cells showing ### | Widen the column by dragging its border or double-clicking it |
| The layout survives a refresh | Refresh the pivot, then scroll again | Reapply the freeze and widths; the refresh may have moved the rows |
| Totals match the source | Compare one total with the raw data | Freezing does not change data, so check your filters and the refresh instead |
❓ FAQ
1. Why does my frozen header move after I refresh the pivot?
A refresh can add or remove rows, which shifts where the column labels sit. The freeze stays at the same row number, so it can end up below or above the labels. Select the cell under the new labels and freeze again.
2. Can I freeze a pivot table that is inside a PDF?
No. A PDF page is not a spreadsheet, so the freeze option does not apply. Export the pivot table to XLSX with the PDF editor, then freeze the header in the spreadsheet copy.
3. Why does the frozen area take up most of my screen?
Titles, filter fields and blank rows above the header are frozen along with it. Move the filters to the side of the table or remove empty rows above the labels so the frozen area is smaller.
4. How do I stop long labels from being cut off?
Widen the column by dragging its border, or turn on text wrapping for the label cells so the text breaks onto a second line. Wrapping keeps the column narrow but makes rows taller.
📝 Summary
Setting a pivot table freeze header takes only a few steps: pick the cell below the labels, freeze at that point, and widen the columns so the text reads clearly. Check the view after scrolling and again after each refresh. If the table lives in a PDF, export it to XLSX first, then apply the freeze to the spreadsheet copy.
