Excel Basics for the Business Office: Freeze Panes, Filters, Print

At month end, a billing clerk scrolls down a long accounts receivable sheet. By row 80 she can no longer see which column is which, so she scrolls back up, loses her place and does it again. Later she sorts one column, and the names no longer line up with the balances. Then the printout comes out across four pages.

All three problems have simple fixes already built into Excel. None takes more than a minute to learn. They are worth the minute, because they are behind a large share of everyday spreadsheet frustration.

Freeze panes: keep the headers where you can see them

When a sheet is longer or wider than your screen, the column headings scroll away. Freezing keeps them in place.

To keep just the top row visible:

Open the View tab.

Choose Freeze Panes, then Freeze Top Row.

To keep the first column visible too, such as a resident name or account number, choose Freeze First Column. If you want both the top row and some columns, click the cell just below and to the right of what you want to keep, then choose Freeze Panes. Everything above and to the left of that cell stays put.

If your headings are not on row one, because there is a title above them, use the cell method. Click the cell under your headings, then choose Freeze Panes. To undo it, go back to the same menu and choose Unfreeze Panes.

Filters: look at part of the data without changing it

A filter hides rows you do not want to see. It does not delete them.

Click anywhere in your data.

On the Data tab, choose Filter. Small arrows appear on each heading.

Click an arrow and tick the items you want, such as one payer or one unit.

Filtered rows disappear from view, and the row numbers turn blue to show that some are hidden. To bring everything back, choose Clear on the Data tab. Remember that totals typed as ordinary sums still count the hidden rows. If you need a total of only the visible rows, ask someone to show you the subtotal function, or use the status bar at the bottom, which sums selected visible cells.

Sorting without scrambling

The classic mistake is sorting one column by itself, so that balances move but names do not. Avoid it with these habits:

Click inside the data and use Sort on the Data tab. Excel will usually select the whole block of connected data for you.

Confirm that the box saying your data has headers is ticked.

Look for blank rows or blank columns in your data. A blank row can split your table in two, and Excel may sort only one part.

Make a copy of the file before you sort anything important.

If you sort and something looks wrong, press Ctrl+Z right away. Undo works for several steps, but only until you close the file or save over the problem.

Print a wide sheet on one page

A sheet that prints across several pages is usually fixable in the Page Layout settings.

Open the Page Layout tab.

Set Orientation to Landscape for wide sheets.

In Width, choose 1 page. Leave Height on Automatic, so the sheet can run onto more pages down but stays one page wide.

Use Print Titles to repeat the heading row at the top of every printed page.

Before you print, use File, then Print, to look at the preview. If the text becomes too small to read, try narrowing a column or two, hiding columns nobody needs on paper, or printing on legal-size paper if your printer supports it.

To print only part of a sheet, select the cells, then choose Print Area and Set Print Area.

A quick checklist before you share or print

Are the headings frozen so you can read down the sheet?

Did you clear your filters before sending the file to someone else, or do you want them to see the filtered view?

Does every row still match across columns after a sort?

Does the print preview show one page wide, with headings repeated?

Did you save a copy before making big changes?

Small habits that prevent big problems

Keep one table per sheet, with one header row and no blank rows inside it. Avoid merged cells in data tables, because they make sorting and filtering unreliable. Give files clear names with a date, and save them in a shared folder, not on the desktop. If a sheet holds resident or employee information, keep it in the folder your facility has approved for that, not in email attachments.

How we can help

UnityCare IT supports Microsoft 365 for business offices, including Excel, OneDrive and SharePoint. We can show your staff these basics in a short session at your office or remotely, and our help desk can answer questions when a sheet misbehaves. We also help set up shared folders so important spreadsheets are backed up and not stored only on one desktop.

Related service

A helpdesk your staff can call or text when something stops working.

Related articles

Keep reading

Contact UnityCare Technologies

Call or text: 405-285-3845

New customers: start@unitycareit.com

Existing customers: support@unitycareit.com

Service area: based in Edmond, Oklahoma, serving Oklahoma, Texas and Kansas

Hours: Mon–Fri 8 AM–5 PM CT; 24/7 after-hours support