0
You can't do that. What you do is use borders. Put borders around the cells you want. Then print the document with no gridlines, and the borders you have will be printed.
Wiki User
∙ 10y ago
Add your answer:
Earn +20 pts
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.
Are gridlines printed by default?
No, they only show on the screen unless you specifically turn them on in the print options.
What is printed if a chart that appears as an object in a worksheet is selected and then the print command is selected?
You would print only the selected chart or object.
How can you print two columns on one page in Excel?
If you only want to print data from two columns out of your spreadsheet, you can use the Print Area option to choose which ones you want to print. Just select the data and then go to the File menu and click Print Area and Set Print Area. When you then go to print, it will only print what you have selected and not any other data that may be on the spreadsheet. Use Clear Print Area, to restore the printing option to normal.
How do you print a selection or range of a worksheet?
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.
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.
What condition requires that only one of the selected criteria be true for a record to be displayed in Excel?
It is when you are using an OR condition, which in Excel can be implemented through an OR function, or in an Advanced Filter by listing the criteria on different rows.
When you print a presentation with the Outline view selected in PowerPoint what is printed?
slide numbers, slide icons, and slide text only
If you want to print off a recipe or knitting pattern off a blog how do you get just what you want to print and not the whole blog?
Try and find a "Print" version of the post you'd like to print. If the blog doesn't offer one then the best is to clickthrough the specific post and only try and print that page. You can also try and select the area you'd like to print and in the print window choose to print only the selected area.
Why is a single cell selected in Excel?
At any moment in time, at least one cell has to be selected in Excel. It is known as the active cell. There has to be a focal point so that data or formulas can be typed in. Even when more than one cell is selected, there is only one active cell. Which cell is the active cell can be changed at any time, but there always has to be an active cell. If there isn't then, before you do anything, you would have to make a cell active. Cells are fundamental to Excel so there has to be an active cell at all times.
In Excel is cell A1 designated the active cell?
If you select one cell, it will be active. However, if you select multiple cells at once, only one can be the active cell. That is usually the cell you select first.
How do you print all sheets in excel workbook one at a time?
Your question is not clear. If you want to print all sheets in the workbook, use the print command. In the print box there is a section called "Print what." The default setting is Active sheet(s). Select Entire workbook.If you want to print only a single sheet "one at a time," then leave the setting at Active sheet(s).
