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. We can see one more slab as well at the bottom, i.e., it will show how many sheets it is going to print. 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.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.