Search results
Apr 27, 2018 · Hi TNorton, does the following not work in Excel for you: Select a range of cells, then on the Page layout ribbon, click Print Area - Set Print Area
Mar 1, 2019 · I found what I needed this way: 1. Select the area of the sheet you wish to print. 2. Under "File" tab, select "Print". A print options side panel appears. 3. In the side panel under "What to print" choose "Selection". Question Info.
I'm using Excel for Mac 2017. Is there a way to define the size of a worksheet. I'm not referring to Set Print Area. I mean that when we open an excel worksheet. we will see only the active part of the worksheet, and not all the unused rows and columns. Thanks for your advice.
Oct 24, 2023 · It is not possible to do so when you click Page Setup after selecting File > Print. I had not selected print yet. And the page layout tab was as below. I have since had to print and shrink the whole document to fit to one page so I would have the row titles.
Apr 12, 2020 · The Print Area, Rows to Repeat at Top and Columns to Repeat at Left are diabled (grayed out) if you select File > Print > Page Setup. They should be enabled when you activate the Page Setup dialog by clicking the little arrow in the lower right corner of the Page Setup group of the Page Layout tab of the ribbon. ---. Best wishes, HansV.
Aug 23, 2016 · Answer. The first consideration always is the update status of your OS X version as well as your Office 2016 software. When printing issues are involved, the printer driver is a main consideration as well. Make certain that all are current, including a trip to the mfr's site to see if there is a driver update for your model - print issues have ...
Mar 26, 2013 · Created on March 25, 2013. Unable to set print area in some documents. I can no longer set the print area in some Excel documents in Office 2010. The “Set print area” button is not greyed out and appears to work because the resulting print preview is correct. However there is no dotted line around the selected print area.
Feb 6, 2022 · Column A has dates and I want to print Columns A:J where first row should be date specified in Sheet2!C4 and last row should be date specified in Sheet2!C5. This thread is locked. You can vote as helpful, but you cannot reply or subscribe to this thread.
Aug 18, 2011 · In reply to Bill_in_AZ's post on August 18, 2011. Select the sheet with the pivot table on it. Select Insert | Name | Define. The dialog will have a named range called Print_Area. this is the named range that defines what will be printed. If you modify this named range to use a dynamic range then it will print your entire pivot table.
Jun 11, 2018 · Setting a print range- Excel Online. How does one do this? I recently registered for excel online and have a spreadsheet that I cannot seem to get the print range selected as I want it to be- I have added to the spreadsheet and want to select all, including what I have added. Does anyone know how I can do this? I am running Windows 7. Replies (1) .
