October 20, 2021 - by Bill Jelen
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.
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.
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 »
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?
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.
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.