So, the bigger your worksheet, the more pages it will take. By default, Excel prints sheets at their actual size.

After we got all the print copies, we need to arrange them in order. How to print Excel spreadsheet on one page. Out of 11 headers, we could see only 4 headers after printing these columns first, then it will print the remaining columns. When we print this data, we usually expect the data to come in a single sheet only, but look at the Print Preview now.

We have a total of 11 headers in our data, and below are the headers in order.įirst_name, Last_name, Company_name, Address, City, County, State, Zip, Phone1, Phone2, and Email.

Now take a look at the data headers and compare them with Print Preview. In the above, it says 1 of 36, i.e., out of thirty-six sheets, print preview is visible for the 1 st sheet. Click on Print (or use the keyboard shortcut Control + P) In the Print window, click on the Scaling option (it’s the last option on the left) Click on any one of the options: Fit Sheet on One Page. We can see one more slab as well at the bottom, i.e., it will show how many sheets it is going to print. Below are the steps to scale down the sheet while printing: Click the File tab. The left side is Print Setting Options, and the right side is the Print Preview window.

We can see two slabs in the above image.

Then press the excel shortcut key Ctrl + P.

To print this, first select the entire data. I'm trying to figure out how to import an excel file into QB for Mac.

For example, assume you have a large amount of data like the below.

In such situations, you need to know how to print a large amount of data.

There is a situation where we need to share offline with the users by printing them. When the report or data is ready, we usually send the data online to the user.

View single page in excel for mac