How To Print Range In Excel?

Select and highlight the range of cells you want to print. Next, click File > Print or press Ctrl+P to view the print settings. Click the list arrow for the print area settings and then select the “Print Selection” option. The preview will now show only the selected area.

Contents

How do I print a range?

Hold down the Ctrl key to select the non-contiguous ranges. 3. Then the selected ranges will be surrounded by a dotted line, and then click File > Print to start printing the ranges one by one.

How do I print selected rows and columns in Excel?

In the Sheet Options group, under Headings, select the Print check box. , and then under Print, select the Row and column headings check box . To print the worksheet, press CTRL+P to open the Print dialog box, and then click OK.

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

Select the first range, hold down the Ctrl key and select other ranges. On the Page Layout tab, in the Page Setup group, click Print Area > Set Print Area.

What is print range?

Adding to the print range
This allows you to print multiple, non-contiguous areas of the same sheet, while not printing the whole sheet. Once you have defined a print range: Highlight the range of cells that should be added to the print range. Choose Format > Print Ranges > Add Print Range.

How do I print multiple ranges in Excel?

Hold down the Ctrl key and use the Name Box drop-down list to select each of the other named ranges you want to print. In the Page Setup group click the Print Area tool and then click Set Print Area. Excel marks each of your ranges as part of the print area. Print as you normally would.

How do I set print range in open office?

Editing the print range

  1. Select Format → Print Ranges → Edit from the main menu.
  2. In the print dialog that appears, look at the Print range setting.
  3. Adjust the cell definition in the range of cells, or select None to clear the print range.
  4. Click OK .

How do I change excel to 90% scale?

In the worksheet, click File > Print. Under Settings, click Custom Scaling > Custom Scaling Options. Click Page and in the Adjust to box, choose a percentage by which you want to increase or decrease the font size. Review your changes in Print Preview and—if you want a different font size—repeat the steps.

How do I print only selected data in Excel?

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 you print only certain columns in Excel?

Print Area

  1. Select the column or columns you want to print.
  2. Switch to the “Page Layout” tab in the Microsoft Excel Ribbon and locate its Page Setup group.
  3. Click on “Print Area” to open a drop-down menu, then select “Set Print Area” to designate the column area you selected.

How do you convert a table to a range?

Convert an Excel table to a range of data

  1. Click anywhere in the table and then go to Table Tools > Design on the Ribbon.
  2. In the Tools group, click Convert to Range. -OR- Right-click the table, then in the shortcut menu, click Table > Convert to Range.

How should you print a selected area of a worksheet if you want to print a different area next time?

How should you print a selected area of a worksheet, if you′ll want to print a different area next time? On the file menu, point to print area, and then click set print area.

How do you set 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 print a selected area in Excel 2007?

Open the Spreadsheet with the data you need and hold down the Ctrl key while highlighting the area of the document you want to print out. Click the Page Layout tab on the Ribbon, then the Print Area button and Set Print Area…

How do I print only certain pages?

Open the print dialog by pressing Ctrl + P . In the General tab, choose Pages from the Range section. Type the numbers of the pages you want to print in the text box, separated by commas. Use a dash to denote a range of pages.

How do I print non contiguous ranges in Excel?

Print Area option in Excel
Select the rows, columns or any part of data hold control key and select parts using mouse. Go to Page Layout > Print Area > Set Print Area.

How do I print non consecutive pages in Excel?

Print Non-Consecutive Pages Of A Worksheet

  1. Click View |Page Break Preview | OK.
  2. Select the cells on the first page, press the Ctrl key, while selecting the cells on the other pages you want to print.
  3. Click File, Print, the Selection radio button (under Print What) and OK.

How do you print on Open Office Calc?

With the spreadsheet open, select Format > Page… In the dialog that appears, select the Sheet tab. At bottom of the dialog there is a scale control labeled, Fit printout on number of pages. Click the checkbox next to it; then enter the desired number of pages for the printout.

How do I print landscape in open office?

Single Printing

  1. Click “File” and then “Print” to open the Print window.
  2. Select the “General” tab.
  3. Click “Properties” to the right of Details.
  4. Select the “Layout” tab.
  5. Click the drop-down arrow beneath Orientation.
  6. Select “Landscape” and then click “OK.” Your document will now print in landscape orientation.

How Do I Set Print Area in Libre Calc?

For those unable to find the prompt, I’ve retyped this in an easier to follow format:

  1. Select the area you’d like to print.
  2. Go to Format → print ranges → define.
  3. Go to Format → Page → Sheet → Fit print ranges on number of pages, then type “1” or however many pages you’d like.

Why does my Excel spreadsheet print so small?

Method 1 – Manual Page Scaling
Step 1: Open your spreadsheet in Excel 2013. Step 2: Click the Page Layout tab at the top of the window. Step 3: Adjust the values in the Scale to Fit section so that they look like the image below. Width should be Automatic, Height should be Automatic, and Scale should be 100%.