Ampler sets and modifies print areas and toggles page-break views from one dropdown, so a sheet prints exactly the range you want, laid out the way you want.
Quick answer: Select the cells to print and click Set Print Area from the Ampler Print dropdown; toggle between Normal view and Page Break Preview from the same menu.
How to use it
Set the print area and toggle Page Break Preview from the dropdown.
- Select the cell area to print.
- From the Print dropdown, click Set Print Area.
- Toggle between Normal view and Page Break Preview, and toggle the page-break display.
Setting the print area and checking the page breaks means the printed output matches what you intend.
Keyboard shortcut
The print functions have no default shortcut. To assign one, open the Settings dropdown on the Ampler ribbon, choose Shortcuts, click Set shortcut on the function, and press your key combination.
Why use it
Getting an Excel sheet to print the right range on the right number of pages is fiddly with the native controls. Ampler puts setting the print area and switching to Page Break Preview in one dropdown, so a sheet is print-ready quickly.
How consultants use it
Model outputs and data tables often go into printed board packs and appendices, and they have to print cleanly. Three habits apply:
- Print the right range: the print area is set to exactly the output, not the whole sheet.
- Control the page breaks: Page Break Preview shows how the output splits across pages.
- Print-ready appendices: data tables are laid out cleanly for the pack.
Setting print areas and page breaks makes a sheet print the way you intend.
Tips & best practices
- Set the print area to the output range before printing or exporting to PDF.
- Use Page Break Preview to check how the output splits.
- Pair with Resize cells to print margins for a clean fit.
Availability
Included in Ampler for Excel and the Ampler Suite, on Windows desktop Excel.
Frequently asked questions
How do you set a print area in Excel?
Select the range and click Set Print Area from the Ampler Print dropdown.
How do you see page breaks in Excel?
Toggle to Page Break Preview from the Ampler Print dropdown to see how the sheet splits across pages.
How do you make an Excel sheet print cleanly?
Set the print area to the output range and check it in Page Break Preview so it prints exactly the range you intend.