Add a Page Break at Each Change in Customer

October 20, 2021 - by Bill Jelen

Add a Page Break at Each Change in Customer

Problem: My data is sorted by customer in column A. I want to put each customer on a different page.

Strategy: The easiest way to do this is to add a subtotal by using the Data, Subtotals command. In the Subtotal dialog, you can choose to have a page break between groups.

continue reading »

More Reading

Print Multiple Ranges

Print Multiple Ranges »

October 19, 2021 - by Bill Jelen

I want to print five sections of my worksheet, but the print areas are not next to each other.

Add a Printable Watermark

Add a Printable Watermark »

October 18, 2021 - by Bill Jelen

I would like to add a “Draft” watermark on each page of my printed worksheet.

How to Make a Wide Report Fit to One Page Wide by Many Pages Tall

How to Make a Wide Report Fit to One Page Wide by Many Pages Tall »

October 15, 2021 - by Bill Jelen

After I create a wide report, it prints four pages wide. How do I make it print one page wide?

read more articles »

Featured Products

Power Excel With MrExcel - 2019 Edition

December 2019

This is the print book edition of "Power Excel with MrExcel - 2019 Edition" - by Bill Jelen. Master Pivot Tables, Subtotals, Visualizations, VLOOKUP, Power BI and Data Analysis.

MrExcel 2021 – Unmasking Excel

February 2021

This is a 5th edition of MrExcel XL. Updates for 2021 include: LAMBDA, LET, Power Query Fuzzy Match, Sort & Filter in Sheet View, Cut-out people, Save object as image, STOCKHISTORY, Wolfram Alpha Data Types, Custom Data Types from Power Query, Weather data types, bilingual spreadsheets, Performance improvements, Unhide multiple worksheets, Action pen, Collapsible task panes, LET function to re-use calculations, store formulas using LAMBDA, Recursive LAMBDA, Branching LAMBDA, Lambda to return a picture, Excel function quick reference.

Cool Excel Sh*t

March 2021

Cool Excel Sh*t is designed with the Excel guru in mind, introducing advanced, creative solutions and hacks for the software's most challenging problems.

MrExcel 2020 - Seeing Excel Clearly

January 2020

This is a 4th edition of MrExcel LX. Updates for 2020 include: Ask a question about your data, XLOOKUP, Power Query's Data Profiling tools, How Geography Data Types decide which Madison, A SEQUENCE example for descending 52 weeks, Exchange Rates support in Stock Data Types, How to collapse the Search box, How to leave effective feedback for Microsoft, How to post your worksheet to the MrExcel Board using XL2BB.

see more products »