General

How do you set print area in Excel 2013?

Standard

How do you set print area in Excel 2013?

Here is how to set the print area in Excel 2013 – Click on the top-left cell that you want to include in your print area, then drag your mouse until everything that you want is selected. Click the Page Layout tab. Click the Print Area button in the Page Setup section of the ribbon, then click Set Print Area.

Why won’t Excel Let Me Set print Area?

If your Excel spreadsheet isn’t printing properly, clearing or setting a print area can often help. Sometimes the wrong print area has already been set, in which case you want to clear it. To do this from the Page Layout Ribbon, click the Print Area icon and select Clear Print Area.

How do I print a certain area of a cell?

Select the range of cells you want to set as the print area. Next, click Page Layout > Print Area > Set Print Area. The print area is now set. The next time you print (File > Print or press Ctrl+P), this area will be printed by default.

How do you set a range as the print area in Excel?

Print Area

  1. Select a range of cells.
  2. On the Page Layout tab, in the Page Setup group, click Print Area.
  3. Click Set Print Area.
  4. Save, close and reopen the Excel file.
  5. On the File tab, click Print.

How Do I Set print Area in sheets?

The following steps explain how to set the print area in Sheets.

  1. Highlight the area you want to print.
  2. Next, open the “Print Settings” menu.
  3. Click on the “Print Settings” menu option that says “Current Sheet”
  4. Choose the “Selected Cells” option.
  5. Check the preview to make sure you’ve highlighted the correct range.

How do I change the print size in Excel?

Scale the sheet size for printing

  1. On the Page Layout tab, select Page Setup.
  2. On the Page tab, select the Fit To check box.
  3. In the Page wide by box, enter 1 (for one-page wide).
  4. In the Tall box, enter 0 so that the number of pages tall is unspecified.
  5. On the File menu, click Print.

How do I print only part of an Excel spreadsheet?

On the worksheet, click and drag to select the cells you want to print. Click File > Print > Print. To print only the selected area, in Print Options, click Current Selection. If the print preview shows what you want printed, click Print.

How do I select an area in Excel?

Select one or more cells Or use the keyboard to navigate to it and select it. To select a range, select a cell, then with the left mouse button pressed, drag over the other cells. Or use the Shift + arrow keys to select the range. To select non-adjacent cells and cell ranges, hold Ctrl and select the cells.

How do I print certain cells in Excel?

Change a selected print area

  1. On the worksheet, click and drag to select the cells you want to print.
  2. Click File > Print > Print.
  3. To print only the selected area, in Print Options, click Current Selection.
  4. If the print preview shows what you want printed, click Print.

How do you show print lines in Excel?

How to Show Grid Lines When Printing in Microsoft Excel

  1. Select the worksheet or worksheets you want to print, and then click the “Page Layout” tab.
  2. Check “Print” under Gridlines in the Sheet Options group, and then press “Ctrl-P” to go to the Print window.