Printing a Specific Selection of Cells in Microsoft 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.
Contents
How do I print highlighted cells?
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 highlighted cells in Excel 2010?
Print a Selection in Excel
- Use your mouse to select the cells to print.
- Click the File tab at the top-left.
- Select the Print option.
- Click the Print Active Sheets button, then choose Print Selection.
- Click the Print button.
How do I print selected area on one page in Excel?
Below are the steps to set the print area in Excel:
- Select the data that you want to set as the print area.
- Click the Page Layout tab.
- In the Page Setup group, click on the Print Area option.
- Click on Set Print Area.
How do you not print highlighted cells in Excel?
Print Table without Color Filled in Cells
- Step 1: Click Page Layout in the ribbon.
- Step 2: Click on Page Setup icon to load Page Setup window.
- Step 3: In Page Setup window, click on Sheet tab.
- Step 5: Click on Print Preview to preview print page. Then you can find the filled color is removed from print page.
How do I print a row title in Excel?
Print row or column titles on every page
Click the sheet. On the Page Layout tab, in the Page Setup group, click Page Setup. Under Print Titles, click in Rows to repeat at top or Columns to repeat at left and select the column or row that contains the titles you want to repeat. Click OK.
How do I print certain cells in sheets?
Hit Ctrl + P on a PC, or Command + P on a Mac, or go to File, then select Print at the very bottom of the list. 4. In Print options, choose “selected cells.” 5.
How do I lock a row in excel so I can always see it?
To freeze several rows:
- Select the row that is immediately beneath the last row you want frozen.
- From the View tab, Windows Group, click the Freeze Panes drop down and select Freeze Panes.
- Excel inserts a thin line to show you where the frozen pane begins.
Can you print specific columns in Excel?
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. Each print area prints on its own page. On the Page Layout tab, in the Page Setup group, click Print Area, and then click Set Print Area.
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 print a selection?
Just select the desired text on the current page and press CTRL+P. This will bring up the Print dialog, where you can simply select the “Selection” option there. This will print out only the selected text.
How do I highlight cells but not print?
Re: Shade a cell but not print that color?
- click on New Rule.
- Rule Type Format only cells that contain.
- Format only cells with set to Specific Text and use N/A.
- Click on Format, Then Font Tab and set color to White.
How do I print the background color in Excel?
Select your print area — or press “Ctrl-A” to select your entire worksheet. Right-click on your selection and then click “Format Cells…” Click the “Fill” tab. To select a standard color, click a color box under Background Color.
How do I print without shading?
Method 1: Alter the “Word Options”
- First of all, click “File” tab in Word.
- Next click “Options” to open the “Word Options” box.
- Click “Display” on the left.
- Then on the right side under “Printing options” section, clear “Print background colors or images” box.
- Lastly, click “OK”.
How do I print a range a5 b24 in Excel?
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 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 use Goal Seek in Excel?
Use Goal Seek to determine the interest rate
- On the Data tab, in the Data Tools group, click What-If Analysis, and then click Goal Seek.
- In the Set cell box, enter the reference for the cell that contains the formula that you want to resolve.
- In the To value box, type the formula result that you want.
Can you do a sum of highlighted cells in Excel?
You simply click the One Color button on the ribbon and have the Count & Sum by Color pane open at the left of the worksheet. On the pane, you select: The range where you want to count and sum the cells. Any color-coded cell.
How do I print multiple row titles in Excel?
Click the [Page Layout] tab > In the “Page Setup” group, click [Print Titles]. Under the [Sheet] tab, in the “Rows to repeat at top” field, click the spreadsheet icon. Click and select the row you wish to appear at the top of every page. Press the [Enter] key, then click [OK].
Can you freeze a row and a column in Excel?
You can choose to freeze just the top row of your worksheet, just the left column of your worksheet, or multiple rows and columns simultaneously.To lock more than one row or column, or to lock both rows and columns at the same time, choose the View tab, and then click Freeze Panes.