OmniDocFreeze Columns and Rows While Working With Formulas
Learn how to freeze header rows and label columns so they stay visible while you read long formula sheets, and how this differs from locking cell references.
If you work with long Excel files (.xlsx), you have probably scrolled past the header row and lost track of which column a formula is reading. Someone searching for "excel formula freeze column" usually wants one thing: the column titles and row labels to stay on screen while the formulas and numbers move underneath them. That is a view setting called freeze panes, and it takes about a minute to apply.
This article shows you how to freeze the rows and columns you need, how to check that the frozen area works, and how to avoid a common mix-up. Freezing panes does not lock formulas. If you also want a cell reference to stay fixed when you copy a formula, that is a different setting, which we cover below.
The steps below apply to any desktop spreadsheet program that has a freeze option. OmniDoc can translate Excel files and keeps formulas in the translated copy, but freeze settings are a view setting that you should check yourself after any conversion.
Freezing rows and columns: the short answer
Freeze panes from the cell just below and to the right of the area you want to keep visible. Everything above and to the left of that cell stays in place as you scroll.
| Your situation | What to do | Why |
|---|---|---|
| Long sheet with headers in row 1 only | Freeze the top row | Column titles stay visible while you scroll down |
| Headers in several rows, such as a title and a date row | Select the cell below the last header row, then freeze | Every row above the selected cell stays fixed |
| Wide sheet with labels in column A | Freeze the first column | Row labels stay visible while you scroll right |
| Headers and labels both needed | Select the cell below and right of both, then freeze | Rows and columns stay fixed together |
| Copying one formula across many cells | Add dollar signs to the reference | This locks the reference, not the screen view |
Before you start
Check these points so the freeze lands where you expect.
- Confirm the file type. This method applies to spreadsheet files. If you are working in a Word document or a PDF, there is no freeze setting to use.
- Decide what must stay visible. Note which rows hold headers and which column holds labels. Freezing too few rows or columns defeats the purpose, and freezing too many leaves little room to scroll.
- Save a copy first. Freeze settings are harmless, but a backup protects you if you later change formulas by mistake.
- Know your program's freeze option. Each spreadsheet program places it in a different spot, so look for the freeze option in the view controls. If you cannot find it, the program's help pages will list the exact location.
- Plan for merged cells. Merged header cells can make the freeze line sit in an awkward place. Unmerge them first if the frozen area looks wrong.
Freezing panes step by step
- Open the workbook and go to the sheet. Make sure you are on the sheet that holds the formulas, because freeze settings apply per sheet.
- Find your last header row. Count the rows that hold titles or dates. The cell you select will sit directly below this row.
- Find your label column. If row labels run down column A, you will select the cell to the right of column A. If you need no frozen columns, skip this part.
- Select the anchor cell. Click the cell just below the last header row and just right of the label column. The frozen area is everything above and to the left of this cell, so a wrong click changes what stays fixed.
- Apply the freeze. Open the freeze option in the view controls and choose the freeze panes command. If you only need the top row, you can use the option that freezes the top row, which works without selecting a cell.
- Test the result. Scroll down and across. The headers and labels should stay put while the data moves.
- Save as .xlsx. Keep the file in the same format so the view settings are saved with it.
To remove the freeze later, open the same freeze option again and choose the command that unfreezes panes.
Locking references is a separate step
Many people search for a "freeze" when they mean "lock a reference." These are not the same. Freezing panes controls what you see on the screen. A locked reference controls what a formula points to when you copy it.
In a formula, a plain reference such as B2 shifts when you copy the formula down or across. Adding a dollar sign before the column letter, before the row number, or before both keeps that part of the reference fixed. You can lock only the column, only the row, or both. Use locked references when every copied formula must read the same tax rate cell, for example, and use freeze panes when you just need the labels visible while you read.
Check the result
Once the freeze is in place, run through these checks.
| Check | How to see it | If it's wrong |
|---|---|---|
| Header rows stay fixed | Scroll far down and watch the top rows | Unfreeze and reselect the cell one row lower or higher |
| Label column stays fixed | Scroll far right and watch the left columns | Unfreeze and reselect the cell one column over |
| Formulas still give the right results | Compare two or three results with a manual calculation | Check for references that shifted when copied, and add dollar signs where needed |
| Translated copy keeps formulas | Open the translated file and click a formula cell | If the formula or result changed, compare it with the original and fix the cell |
| Freeze settings in the translated copy | Scroll the translated file the same way | If the freeze is missing, apply it again in your spreadsheet program |
Translation is a machine process, so check any important numbers and labels in the translated file before you rely on them. OmniDoc describes keeping formulas, tables and layout in translated Excel files, but it does not describe carrying over view settings such as frozen panes, so treat that part as something to verify.
Common questions about the freeze shortcut
Freeze panes is usually a few clicks away, and many spreadsheet programs also offer a keyboard route. The exact keys differ by program and version, so check your program's help pages for the current shortcut rather than relying on a memorized key sequence.
If you use the OmniDoc desktop client, its listed spreadsheet tool is UniCell. OmniDoc's public description does not cover a freeze option in UniCell or in the UniDoc web editor, so for freezing panes, use the spreadsheet program where you normally edit the file. The UniDoc web editor at app.unidoc.top is described as Word-compatible and is aimed at documents rather than spreadsheet views.
❓ FAQ
1. Does freezing panes change my formula results?
No. Freezing only changes what stays on screen as you scroll. Your formulas and their results stay the same.
2. Why does my formula break when I copy it after freezing?
Freezing has no effect on copying. The formula is likely using relative references that shift when copied. Add dollar signs in front of the column letter and the row number for the cells that must stay fixed.
3. How do I unfreeze rows and columns?
Open the same freeze option in the view controls and choose the command that unfreezes panes. The option toggles, so it removes the freeze from the current sheet.
4. Will my frozen rows still be frozen in a translated file?
OmniDoc describes keeping formulas, tables and layout in translated Excel files, but it does not describe carrying over frozen panes. Open the translated file and check the scrolling. If the freeze is gone, reapply it in your spreadsheet program.
📝 Summary
Freeze panes keeps headers and label columns visible while you read long formula sheets, and it is a view setting that leaves your formulas alone. Use dollar signs when you need a reference to stay fixed while copying. Test the freeze by scrolling, and recheck the view after any translation.
