1.

2. How do you print an Active Sheet in Excel?​

Answer»

tion:Print one or several worksheetsSelect the worksheets that you want to print. Click File > Print, or press CTRL+P.Click the Print button or adjust Settings before you click the Print button.Print one or several workbooksAll workbook files that you want to print must be in the same folder.Click File > Open.Hold down CTRL click the name of each workbook to print, and then click Print.Print all or part of a worksheetClick the WORKSHEET, and then select the range of data that you want to print.Click File, and then click Print.Under Settings, click the arrow NEXT to Print Active Sheets and select the appropriate option.Under Settings, click Print Entire WorksheetClick Print.Note: If a worksheet has defined print areas, Excel will print only those print areas. If you don't want to print only the defined print area, select the Ignore print area CHECK box. Learn more on setting or clearing a print area.Print an Excel tableClick a cell within the table to enable the table.Click File, and then click Print.Under Settings, click the arrow next to Print Active Sheets and select Print Selected Table.Print Selected TableClick Print.Print a workbook to a fileClick File, and then click Print, or press Ctrl+P.Under PRINTER, select Print to File.Print to File optionClick Print.In the Save Print Output As dialog box, enter a file name and then click OK. The file will be saved in your Documents folderImportant: If you print the saved file on a different printer, the page breaks and font spacing may change.



Discussion

No Comment Found