Set one or more print areas
- On the worksheet, select the cells that you want to define as the print area. Tip: To set multiple print areas, hold down the Ctrl key and click the areas you want to print.
- On the Page Layout tab, in the Page Setup group, click Print Area, and then click Set Print Area.
Contents
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.
How do I set the print area and gray out the rest in Excel?
How to quickly grey out all unused area in Excel?
- Enable the sheet in which you want to display working area only, and click View > Page Break Preview.
- Select a range you want to display only, and click Kutools > Show & Hide > Set Scroll Area.
- If you want to display all, click Kutools > Show & Hide > Unhide All Ranges.
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 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 change the print area on my printer?
Open a document to print in the computer, and display the setting screen of the printer driver from the print menu application. Specify Paper Size, Paper Type, Orientation, and other setting. On the [2 Sided/Layout/Booklet] menu of the [Detailed Settings] tab, specify the printable area.
What is Ctrl Shift in Excel?
Press Ctrl + Shift + $ to apply Currency format, Ctrl + Shift + ~ to apply General number format, Ctrl + Shift % to apply Percentage format, Ctrl + Shift + # to apply Date format, Ctrl + Shift + @ to apply Time format, Ctrl + Shift + ! to apply Number format with two decimal places and thousands separator, and Ctrl +
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…
Why can’t I put borders around cells in Excel?
If you apply the borders to cells that will be hidden, then the borders will NOT be visible when the rows or columns are hidden. Even if the adjacent rows or columns are visible, the border will be hidden because it was applied to the cells that are hidden.
How do you put a box around text in Excel?
Answer: Select the cells that you wish to draw the border around. Right-click and then select “Format Cells” from the popup menu. When the Format Cells window appears, select the Border tab. Next select your line style and the borders that you wish to draw.
What is auto fit?
AutoFit is a feature in Microsoft Excel that automatically adjusts the width or height of a cell.You can double-click the line in-between a cell in all versions of Excel to AutoFit cells without having to go through a menu.
How should you print a selected area of a worksheet if you want to print?
Setting the Print Area in Microsoft Excel
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 I print selected worksheets in Excel?
Print Multiple Sheets in Excel
- Select the sheets you want to print.
- Hold the Control key and press the P key (or Command + P if you’re using a Mac)
- In the Print window that opens, under the Settings option, select Print Active Sheets.
- Select the Printer.
- Click the Print button.
How do I print PDS in Excel?
Print a sheet on one page
On the Page Layout tab, select Page Setup. Under Scaling, select Fit to, and type 1 in both the page(s) wide box and page(s) tall box. Select OK. On the File menu, select Print.
How do I change print size?
Click Start, point to Settings, and the click Printers. Right-click the appropriate printer, and then click Properties. Click the Paper tab, and then click the paper size you want to use in the Paper Size box. Click OK, and then close the Printers folder.
How do I change print margins?
Word’s Page Layout Settings
- Open the Word document.
- Click the “Page Layout” tab on the command ribbon.
- Click the “Margins” arrow in the “Page Setup” group.
- Click “Custom Margins” on the list.
- Type the new values in inches for the margins settings, such as for “Top”, “Left” or “Gutter.”
How do I change printer print margins?
Click “Margins” on the Page Layout tab, then select “Custom Margins” and use the up or down arrows to select the margins that you want. On some applications, click the “Page” tab and use the up or down arrows in the Margins field to set the margins for the document.
What is Ctrl D in Excel?
Ctrl+D in Excel and Google Sheets
In Microsoft Excel and Google Sheets, pressing Ctrl + D fills and overwrites a cell(s) with the contents of the cell above it in a column. To fill the entire column with the contents of the upper cell, press Ctrl + Shift + Down to select all cells below, and then press Ctrl + D .
How do you AutoFill in Excel?
Click and hold the left mouse button, and drag the plus sign over the cells you want to fill. And the series is filled in for you automatically using the AutoFill feature. Or, say you have information in Excel that isn’t formatted the way you need it to be, such as this list of names.
What is Alt in Excel?
The Autosum Excel shortcut is very simple – just type two keys: ALT = Step 1: place the cursor below the column of numbers you want to sum (or to the left of the row of numbers you want to sum). Step 2: hold down the Alt key and then press the equals = sign while still holding Alt.
How do I automatically add borders in Excel?
In the Format Cells dialog box, go to the Border tab, select the top, bottom, left and right border in the Border section, specify the line style as you need, and then click the OK button.