You can tell if rows or columns are hidden either by the missing header labels or by the double lines as shown in this picture. If you want to include the hidden rows and columns, you’ll need to unhide them before you print the worksheet. In Excel for the web, when you print a worksheet with hidden rows or columns those hidden rows and columns won’t be printed. Print a worksheet that has hidden rows and columns Select Open in Excel and select multiple print areas on a worksheet. If you have the Excel desktop application, you can set more print options. To print the entire worksheet, select File > Print > Print. To change the print selection, close print preview by clicking on the X, and repeat the previous steps. If the print preview shows what you want printed, select Print. To print only the selected area, in Print Options, select Current Selection. On the worksheet, click and drag to select the cells you want to print. If you select a print area, but decide to change the specified area, here’s how you can preview your changes: In Excel for the web, you can either specify an area you want to print or print an entire worksheet. If you selected a range of cells, but decide to print the entire worksheet, switch to Entire Workbook before you hit Print. To print the entire worksheet, don’t select anything. If you want to print a range of cells, select them. You can print the entire worksheet or just the cells you want. For best results with printing your worksheet, use the Print command in Excel for the web, not your browser’s Print command.
0 kommentar(er)
