How do I print a worksheet in Excel 2010?

A worksheet is considered active if it is selected.

1. Select the worksheets you want to print.
2. Click the File tab.
3. Select Print to access the Print pane.
4. Select Print Active Sheets from the print range drop-down menu.
5. Click the Print button.

How do you show Print Preview margins in Excel 2010?

Tip: To preview the new margins, click File > Print. To adjust the margins in Print Preview, select the Show Margins box in the lower right corner of the preview window, and then drag the black margin handles on either side or at the top or bottom of the page.

Where do I find templates in Excel 2010?

Click the File tab and then click New. The Available Templates panel appears in the Excel Backstage view. Click Sample Templates at the top of the Available Templates panel. The middle pane displays thumbnails for each of the installed templates.

How do I print a worksheet?

Print all or part of a worksheet

1. Click the worksheet, and then select the range of data that you want to print.
2. Click File, and then click Print.
3. Under Settings, click the arrow next to Print Active Sheets and select the appropriate option.
4. Click Print.

How do you print in Excel without cutting off?

How to Fix Excel Cutting Off Text When Printing

1. Open your spreadsheet.
2. Click Page Layout.
3. Select Print Area.
4. Choose Clear Print Area.

How do you print full page in Excel 2010?

print fill full page in excel 2010

1. Select the range of cell that you want to print.
2. Click File > Print > Page Setup.
3. On the Page tab, under scaling, Click Adjust the percentage.
4. Select the range of cell that you want to print.
5. Click File > Print > Page Setup.
6. On the Page tab, under scaling, Click fit to.

How do I adjust print preview in Excel?

Click File, and then click Print to display the Preview window and printing options. Keyboard shortcut You can also press Ctrl+F2….Preview worksheet pages before you print.

To select	Do this
Two or more adjacent sheets	Click the tab for the first sheet. Then hold down the SHIFT key and click the tab for the last sheet that you want to select.

How do I drag the print area in Excel?

How to Set Print Area and Page Breaks in Excel

1. Select the cells you want to print.
2. Click the Page Layout tab.
3. Click the Print Area button.
4. Select Set Print Area. Once a print area is set, add additional print areas by selecting the additional cells, clicking the Print Area button, and selecting Add to Print Area.

How do I expand the print area in Excel?

How to expand print area in Excel

1. Select the cells that you’d like to add.
2. On the Page Layout tab, in the Page Setup group, click Print Area > Add to Print Area.

How do I create a template in Excel 2010?

Creating Your Own Excel 2010 Templates

1. Introduction.
2. Create an Excel workbook that contains all of the elements needed for the template file.
3. Click the File tab and choose Save As.
4. Type the name for the template in the File name box.
5. In the Save as Type drop-down list, select Excel Template (*.
6. Click the Save button.

Where are templates excel?

Open Microsoft Excel. On the right side of the Home tab, click More templates. Scroll through the displayed list of templates to find the one that suits your needs. If you don’t find one you like, you can use the Search for online templates text field to see if there is a template online for what you need.