answersLogoWhite

0


Best Answer

As with most such questions there is likely more than one answer, but I have always:

1. Selected the area (i.e. range) that I wanted to print.

2. Chosen the 'Set print area' option.

3. Set page breaks and any other such required options.

4. Printed.

See the related help article within Excel for further information.

User Avatar

Wiki User

12y ago
This answer is:
User Avatar
More answers
User Avatar

Wiki User

8y ago

You can set the selected area as the Print Area. You can then use the normal printing options and it will print that area. You can also just choose the option to print the selected area in the Print Options.

This answer is:
User Avatar

User Avatar

Wiki User

10y ago

To print only certain cells, select them, then when you click print, chose print selection (you will have to click on the box which says "Print whole workbook" and the chose from the drop down list).

This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do you print a selection or range of a worksheet?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What is it called to print a range of cells in the active worksheet click what in the settings area in the print gallery?

"Print Selection" will let you printed a selected range of cells.


When printing a portion of a worksheet the area printed is called the?

The print area or selection.


I have created a worksheet in Excel and only want to print Columns A and G. How do I do this?

To set the area of an Excel worksheet that will be printed select the range that you want to print and go to the File... Print Area... Set Print Area menu. You can also hide columns that you don't want to see on a print-out by right clicking on the column header and selecting Hide.


How do you print worksheets off of Study Island?

To print worksheets from Study Island, you can go to the "Print Worksheet" option within the assignment or resource you want to print. Once you click on it, a printable version of the worksheet will open in a new window, and you can use your browser's print function to print the worksheet.


What appear between cells in a worksheet but they do not print if the worksheet is printed?

Gridlines


Displays the print dialog box that is used to print the worksheet?

the print button


How do you print only the active worksheet in excel?

The default option is to only print the current worksheet when you print. In the Print dialog box there is an option to tell it what you want to print, even down to selected cells only.


A hard copy of your worksheet?

print out


What shows you how the worksheet will appear when printed in excel?

Print preview.


Which is the correct process for selecting the area to print?

If this is an excel spreadsheet then specify a cell range. If it is a word document and you wish to print a small area in a page, then just highlight the text and select print. On the print dialog make sure you selection "Selction" in the Page range setting.


A method used to move or copy the contents of range of cells by dragging the border of a selection from one locstion in a worksheet and dropping it iton another?

drag and drop


If a chart is clicked on when you go to print a spreadsheet what will happen?

If you click a chart before you print the worksheet, you will print only the chart. If you want to print the entire worksheet (including the chart), click in a cell that does not contain a chart (an empty cell is the best).