excel 2013 print preview shows extra line

This helps if you have column headers that are much wider than the data displayed below them. line styles changed in Excel 2013, and Excel 2016 added additional styles.). Now use the Breaks tool to insert horizontal or vertical page breaks to split up your sheet as desired.įor Sheets 2 & 3 follow the same procedure until you are happy with the results.Īlso, If your text appears too small you can use the Wrap Text tool option on the Home toolbar or you can manually move text to the next line within the same cell by pressing Alt+Enter to preserve horizontal space. The line causing the issue is this Selection.AutoFill Destination:Range (Cells (2, 'BA'), Cells (lastrow, 'BC')), Type:xlFillDefault tjb1 at 13:10 2 Ok, it seems any formula put into column 'BC' prevents Print Preview from working and causes me to get the message 'Microsoft Excel has stopped working' when I close the workbook. Connectors are the lines (typically arrows) that connect from one shape to.

Under Scaling select Fit to: 1 pages wide by 3 pages tallĬlick OK to save the print settings and exit the Page Setup window. Once selected click the icon again or press Enter to confirm your selection.įor sheet 1 you want the data to be on 3 separate pages portrait so go to the Page tab. <- This will remove most of the white area You can use the Scaling option in Page Setup to set limits on how many pages wide and tall your document should be when you print it. Highlight the cells on the sheet that you want to print. Is there a page break below row 5 If so, right-click in a cell directly below it (i.e. Go to the Page Layout toolbar across the top of excel.Ĭlick Print Titles to open the Page Setup window. Switch to Page Break Preview (theres a button for it to the left of the zoom percentage in the status bar).

Excel 2013 print preview shows extra line