Print Rows and Column Headings Along with the Data The reaming columns M & N will come in the next pages. In the above image, we can see the “Page Break Preview.” The blue line (next to column L) is the indication that from column A to Column L belongs to. To check which data coming in the first sheet and which data coming in the second sheet, go to the VIEW tab and click on “Page Break Preview.” So, if we print like this, we cannot read the report properly. read more.Īs we can see in the above image, data is not coming in order from column A to column L it is coming in one page and the remaining portion coming in other pages.
Print preview only displays the document on the screen, and it does not print. Once the print area is set up, we cannot simply print the data because the data is not in order-for example, press Ctrl + P to see the Print preview Print Preview Print preview in Excel is a tool used to represent the print output of the current page in the excel to see if any adjustments need to be made in the final production. The short cut key to set up the print area is ALT + P + R + S. After selecting the data range, go to PAGE LAYOUT > Print Area > Set Print Area. For example, look at the below data in a worksheet.įirst, select the print area, i.e., data range from A1:N32. The first thing we need to do while printing is to set the print area.
