How do i print a selected area in excel

How do I show only selected area in Excel?

Select Visible Cells Only with the Go To Special Menu

Select the range of cells in your worksheet.
Click the Find & Select button on the Home tab, then click Go to Special…
Select Visible cells only…
Click OK.

How do I print certain columns and rows in Excel?

On the Ribbon, click the Page Layout tab. 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 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 I put a border around a cell in Excel?

Select the cells you want to format. Click the down arrow beside the Borders button in the Font group on the Home tab. A drop-down menu appears, with all the border options you can apply to the cell selection. Use the Borders button on the Home tab to choose borders for the selected cells.

How do I get rid of the print lines in Excel?

Steps to Remove Print Preview Lines

Click the File button (Office button in Excel 2007):
Go down to the Options item on the menu on the left and click that (Excel Options in Excel 2007):
Go to the Advanced section in the left column:
Uncheck the item Show page breaks.
Click OK and that’s it!

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. … To do this from the Page Layout Ribbon, click the Print Area icon and select Clear Print Area. If you now want to redefine the print area, select the cells that you want to print.