Click on the "Restore Dialog" button - the context-sensitive version of the Collapse Dialog button - to return to the dialog box. Click on the "Collapse Dialog" button at the right edge of the entry field for "Rows to Repeat at Top" and click on the heading at the beginning of your header row in the spreadsheet itself to add the heading to every page you print. Click on the "Print Titles" item and switch to its Sheet tab. Switch to the Page Layout tab of the ribbon and locate the Page Setup group. In the adjacent Headings section of the Sheet Options group, activate the "Print" check to add the column letters and row numbers to your printout. In the Gridlines section, activate the check box in front of "Print." Unless you activate this setting, the gridlines that define your cell boundaries won't appear on paper, which can make it difficult to follow long rows or columns of data. Switch to the Page Layout tab of the Excel ribbon and locate the Sheet Options group. For a worksheet with many columns, you may prefer to change the default portrait orientation to landscape. Click on the "Orientation" item and select either portrait or landscape. Switch to the Page Layout tab of the Excel ribbon and locate the Page Setup group. Click on the "Format" item and choose "AutoFit Column Width." Set column widths to match their contents by switching to the Home tab of the Excel ribbon and locating its Cells group. You can drag the right edge of a column header to widen or narrow the column. Adjust the widths of your data columns to eliminate wasted space and assure that all your cell contents appear.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |