excel 2013 print preview shows extra line

Orientation: A user can switch between Portrait Orientation (best when more rows but fewer columns on a page) and Landscape Orientation (best when more columns but fewer rows on a page). Or if the user is selecting Uncollated prints 10 copies of page 1, 10 copies of page 2, etc. Print Entire Workbook: This option will print all the workbook pages.Ĭollated: If a user’s workbook contains multiple pages, then there is an option to switch between Collated and Uncollated for a print command.įor example, if the user wants to print 10 copies from a workbook, Collated prints the entire first copy and then the entire second copy. Print Active sheets: This option will print only the active sheet in the workbook. Print selection: This option will print only the current selection in the print command. Select Printer: There are multiple options to save the workbook as per the users need he can select options in the added printer, save as PDF, OneNote, XPS document writer, send FAX or add any new printer. Multiple Copies: If a user wants to print more than one copy, he just needs to count how many copies he wants to print in the Copies section. Summary: As per the given instruction in the print command, it will print with the selected area only in landscape orientation.

TEXT and String Functions in Excel (26+).Lookup and Reference Functions in Excel (36+).Excel Conditional Formatting Based on Another Cell Value.SUMPRODUCT Function with Multiple Criteria.Compare Two Columns in Excel for Matches.

Excel 2013 print preview shows extra line