

Out of 11 headers, we could see only 4 headers. “First_name,” “Last_name,” “Company_name,” “Address,” “City,” “County,” “State,” “Zip,” “Phone1,” “Phone2,” and “Email.” When we print this data, we usually expect the data to come in a single sheet only. Now, look at the data headers and compare them with “Print Preview.” The above says 1 of 36, i.e., out of 36 sheets, a print preview is visible for the 1st sheet. We can see one more slab at the bottom, showing how many sheets it will print. The left side is “Print Setting Options,” and the right 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.Assume you have a large amount of data like the below.In such cases, you need to know how to print a large amount of data. However, there is a situation where we need to share offline with the users by printing them. Uncheck the box next to the Show page breaks option.When the report or data is ready, we usually send the data online to the user.Click Advanced and scroll down to Display options for this worksheet.Then, navigate to Options, located in the menu on the left.Remove them by selecting the File tab at the top of the screen.This is how you remove solid horizontal lines in Normal View, however, the dotted lines that are generated automatically will still be there. Tap on Page Layout tab at the top, select Breaks in the Page Setup section, and click on Remove Page Break.To remove these dotted lines, select a cell in a row that immediately follows the primary page break.In newer versions of Excel, the manually-added page breaks are presented as solid lines, whereas automatic page breaks are displayed as dotted lines. When you’ve formatted your spreadsheet for print, page breaks are shown as lines. Strange dotted lines might also be due to a page break. To do so, select the View tab at the top and then uncheck the box next to Gridlines.
