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


October 15, 2021 - by Bill Jelen

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

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

Initially, this very wide report will span four pages if you print in in portrait mode
Figure 121. Taping four pages together leads to copier jams.

Strategy: Ultimately, you will set the Scale to Fit settings to print to one page wide by any number of pages tall. Before you can do that, you should follow these steps:

continue reading »

More Reading


How to Print Page Numbers at the Bottom of Each Page

How to Print Page Numbers at the Bottom of Each Page »

October 14, 2021 - by Bill Jelen


I am printing a lengthy report, and I want the pages to be numbered.

Print a Letter at the Top of Page 1 and Repeat Headings at the Top of Each Subsequent Page

Print a Letter at the Top of Page 1 and Repeat Headings at the Top of Each Subsequent Page »

October 13, 2021 - by Bill Jelen


I am sending out a worksheet that contains a letter followed by a lengthy report. I would like the headings to appear at the top of each page after the first page. I don’t want the headings to appear at the top of the letter on the first page.

How to Print Titles at the Top of Each Page

How to Print Titles at the Top of Each Page »

October 12, 2021 - by Bill Jelen


I have a report that has 90 rows of data. I want to have the title rows print at the top of each printed page.

read more articles »

Featured Products


Excel Data Cleansing Straight To The Point

July 2019

This Straight to the Point guide provides an introduction to data cleansing, which also goes by names such as data munging and data wrangling. Whatever the name, it basically means doing what needs to be done to make data useful and trustworthy.


Master Your Data with Power Query in Excel and Power BI

August 2021

Despite the moniker "data monkey," we information workers are often more like data magicians. Our data seldom enters our world in a ready-to-consume format; it can take hours of cleaning, filtering, and reshaping to get things ready to go. Power Query will make this process faster the first time and reduce it to a single button click every subsequent time.


Supercharge Power BI - 3rd Edition

February 2021

Released in 2021, this book will teach you the DAX language from the ground up, using Power BI as your canvas.


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.


see more products »