How do I print certain pages or selected worksheets?

Start by opening the Excel spreadsheet you need, hold down the Ctrl key and highlight the area of the document you want to print out. After selecting the area you want to print out, go to Page layout > Print Area > Set Print Area.

How do I not print certain sheets in Excel?

1. right click on the sheet name.
2. choose hide.

Which command is used to print worksheets?

Ctrl+P is the shortcut key for printing a worksheet in MS Excel.

How do you set the print area so only the selected cells will print in Excel?

Set one or more print areas

1. On the worksheet, select the cells that you want to define as the print area. Tip: To set multiple print areas, hold down the Ctrl key and click the areas you want to print.
2. On the Page Layout tab, in the Page Setup group, click Print Area, and then click Set Print Area.

How do I print each line in Excel on a separate page?

Print each row/cell on a separate page with adjusting row height

1. Click the Page Layout > Margins > Custom Margins.
2. In the opening Page Setup dialog box, type 2.5 into both Top box and Bottom box, and click the OK button.

How do I print multiple worksheets in Excel?

The easiest approach is to right-click a worksheet tab, choose Select All Sheets, and then print normally to have the worksheets printed as a single print job. As an alternative you could also select File, Print, Settings, Print Entire Workbook to achieve the same result.

How do I print on both sides?

Printing on both sides of paper is called duplex printing….In Word, do the following:

1. Click the File tab.
2. Click Print.
3. Under Settings, click Print One Sided, and then click Manually Print on Both Sides. When you print, Word will prompt you to turn over the stack to feed the pages into the printer again.