How to Print Only Selected Columns and Rows in Excel

By Yasir · Updated 6 November 2026

Short answerSelect the cells you want, then go to Page Layout → Print Area → Set Print Area. Or press Ctrl+P and choose Print Selection under Settings. In Excel Print Fixer, choose Customized and type the columns (for example B to H) and rows (for example 5 to 20).

Open Excel Print Fixer — free

Set a print area in Excel

Select the cells you want to print, for example B5:H20.
Open Page Layout → Print Area → Set Print Area.
Press Ctrl+P to check the preview.
To print everything again, choose Print Area → Clear Print Area.

Print a selection without saving a print area

Select the cells.
Press Ctrl+P.
Under Settings, change Print Active Sheets to Print Selection.

Repeat the heading row on every page

Open Page Layout → Print Titles.
Click Rows to repeat at top, then click your heading row.
Click OK.

Choose a range in Excel Print Fixer

Open Excel Print Fixer and choose your file.
Under How do you want to print? choose Customized.
Type the columns (for example B to H) and the rows (for example 5 to 20). Leave a box empty to start or end where your data does.
Tick Enlarge to fill page if a small range should fill the page.
The app warns you which rows or columns are not printed, so nothing is left out by accident. Your data is never changed.

Skip the manual steps. Fit any Excel sheet to the page and get a clean PDF or corrected Excel file in one tap.

Try Excel Print Fixer

Common questions

How do I remove a print area?

Go to Page Layout → Print Area → Clear Print Area.

Can I print columns that are not next to each other?

If you select separate areas with Ctrl and set them as the print area, Excel prints each area on its own page. To keep them together, hide the columns between them first, then print.