Technology Tip Tuesday
Printing in Excel can be fraught, and not every department has a Trevor, so here are some tips.
Print selection/range:
To print only a specific range of cells, highlight it on the sheet, and then choose Print Selection. To select non-adjacent cells or ranges, hold the Ctrl key while selecting.
Print entire sheet(s):
To print the entire sheet that you currently have open, choose Print Active Sheets
To print multiple sheets, click on the sheet tabs while holding the Ctrl key, and then choose Print Active Sheets.
Print entire workbook:
To print all sheets in the current workbook, select Print Entire Workbook.
Print Excel Table:
To print out an Excel table, click any cell within your table, and choose Print Selected Table. This option only appears when the table or part of it is selected.