Close Window   
Free Ebook
Get Your Free Excel
Our Top 15 Excel Tutorials
Instant Access!
Subscribe for Free Excel tips & more!

How Do I Only Show Print Area In Excel?

Forum Register
Search Excel Forum Posts, Tutorials, Macros, Tips, and More

I cant figure out how to only show the printable area in excel, and have all
other cells greyed out? Can anybody help.

View Answers     

Similar Excel Tutorials

Print Only Specific Parts of a Worksheet in Excel
In Excel you can select parts of a worksheet to print while ignoring all of the other data on the worksheet. This a ...
Print Gridlines in Excel
I'll teach you how to show gridlines for Excel when you print your files. This is a neat little feature that will ...
Display the Print Window in Excel
This free Excel macro displays the print window or dialog box in Excel. This is the same window that would appear ...
Prevent Charts from Printing in Excel
This is how you prevent a chart from appearing when you print from Excel. This is a great feature when you want to ...

Helpful Excel Macros

Filter Data to Show the Bottom X Number of Items in Excel - AutoFilter
- This free Excel macro filters a data set to show the bottom X number of items from that data set. This macro is really
Show a Single Comment in Excel - Means the Comment is Always Visible, No Hovering Necessary
- This macro in Excel allows you to display or show a particular comment in Excel. This will make the desired comment vis
Display the Print Window in Excel
- This free Excel macro displays the print window or dialog box in Excel. This is the same window that would appear when
Print Preview Screen Display for The Current or Selected Worksheets in Excel
- This free Excel macro allows you to display the print preview screen or window for the current or selected worksheets in
Print Preview Display for Specific Worksheets in Excel
- This free Excel macro allows you to display the print preview mode or window in Excel for a specified Excel worksheet.

Similar Topics

I need to change the print area for an excel spreadsheet on multiple tabs. It is the same print area for each tab. I tried to highlight every tab and set the print area, but excel won't let me do that. How can I accomplish this task without individually setting the print area for each tab?

Thanks. J


Excel 2007. Is there a way to show the print area without going to page layout? Going to print preview causes dotted lines to show on the spreadsheet, however these disappear and I have to go to print preview again. It would be nice to know as I'm working which columns and rows will print on the page.

Hope you folks can help me out with a strange one.

I have several worksheets formatted in exactly the same way as follows:

Col A - width 4
Col B - hidden
Col C - width 4
Col D - Width 108
Col E - Width 3
Col F - Width 11
Col G - Hidden
Col H - Width 11 & Empty

My print range should be Cols A:G (I have used page setup to set the
scaling to fit 1 page wide by [blank] pages tall, thus each sheet will
print as many pages as required depending on number of rows]

When I have the print range set to A:G only columns A:E show on the
print preview (and also on the actual print out) and when I make print
area A:F only A:C show on the print preview.

To get A:G printed I have to set the print area to A:H.

In all 3 of the examples above when I look at the print preview there
is a blank area on the right hand side of the page where the missing
columns SHOULD be but aren't... ie the size of the page seems to be
formatted correctly to include all the columns i want but they just
don't print unless 1 extra column is selected in the print area.

Has anyone out there experienced this problem before?
Thanks in advance.


I need to set a print area within a macro. The range I want to print is only a section of the entire spreadsheet. I can get the macro to select the area I wish to print (this area varies as data is added and deleted) but then do not know the command to set this selected area as the print area.

Any help gratefully received

Excel 2003 Win XP

I downloaded an Excel file. When I opened the file all the info
was there but the area with info had no gridlines. There were
gridlines outside of info area. When I expanded the cells the
gridline show but disappear when I release the mouse button.
The show gridline box is checked in cell format, page set up,
etc. I really need the lines to show and print if possible.
Thanks for any ideas.

I'm using Excel 2000. I had a 1 page document which was perfectly set up so that the footer image's bottom edge matched the bottom of the printable area of the page with no gap.
I had this image set to "don't move or size with cells"

Today I made some changes to the contents of the document and of course only after saving did I discover in print preview that the footer image now partly displays on page 2.

I thus nudged the image up very slightly just until the point where it no longer spills onto page 2, but at this point it suddenly creates a gap between the image and the bottom of the printable area on page 1, which wasn't there before.
No matter how I place the image, I can't seem to eliminate this gap.

Can anyone help?
Thank you for your time.

Hello everyone, this is my first post. I came to a little problem, while using MS Excel 2010. I make a table and set "Print Grid Lines". But when I print the page Excel makes border around all print area even if I fill the cells around that area with white color and also make borders under that line to be white.

So how can I stop Excel to print Print Area line as a border? In the image you see Print area line.

Hi All.... Can anybody help me. I have a sheet that stops after column AF but i know there is information passed that but it has been greyed out. Can somebody tell me how to remove the greyed out area ?
Thank You

I need to find the final column and final row numbers for a dynamic print area from worksheets in different workbooks so that I may properly define the limits for my For Next loops. The usual method of using Cells(Rows.count,1).End(xlUp).Row or Cells(1,columns.count).End(xlToLeft).Column will not work every time as some cells around the perimeter of some print areas contain text or worksheet calculations. The data I need is always contained within this print area. As a word of caution, sometimes there are empty rows within the print area but no empty columns. Additionally, the last row and last column in the print area always contain data.

As an example, using Activesheet.PageSetup.PrintArea for one spreadsheet I get a print area of $B$1:$M$103. Another print area may be $A$3:$K$80.

Using the first example print area, how can I dynamically set the final column to column M and final row to row 103?

Any help is greatly appreciated!

Hi everyone,

Is it possible to sum only those values that fall within the print area? I have a spreadsheet of overtime hours by unit and by each payroll period. It looks something like this:

Unit 1 10 hours
Unit 2 15 hours
Unit 3 20 hours

And it's repeated below like that for all 26 payroll periods. On top I have a running total for the year, and use set print area to show only those payroll periods that I want. Instead of updating the sum formula everytime I adjust the print area, I was wondering if I can have something that will add the values after I reset the print area.

Thanks so much.

Is there a way to have a macro that will copy/paste a print area from separate worksheets to one single worksheet called "Print Que".

I'm trying to figure out a way to have the print area that is copied sent to a worksheet "Print Que", But it needs to be in the next empty cell or below what was previously copied in a vertical column for printing. I'm trying to put together a button "send to Print Que" that will copy the print Area from one worksheet to another, but below the previous print area that was copy/pasted in the same column "b". the print area's in all of the sheets are in the same location. Is this even Possible? Any help would be appreciated.

I can define a name to calculate the desired Print Area for a page.

For example, print_area_notes:


I can then use that name when defining the Print Area via Page Setup.

The problem is it calculates the cell range immediately and substitutes that in the Print Area field. When print_area_notes changes the actual Print Area does not.

Is there some formula I can enter in Print Area that will allow this value to be set dynamically? I have tried setting Print Area to =indirect("print_area_notes") but it doesn't like that.

I could, but prefer not to, write a VBA function to set the Print Area but even then how do I set it to be called automatically?

I'd prefer to be able to enter a formula and do it without VBA code because you then have the security issues every time the spreadsheet is opened.

I have come across a need to extract the individual cells involved in the print area, specifically the last row of the print area. Each sheet in the workbook is 100 columns wide and 100-300 rows in length. I have not written any code yet to support this concept.

If PrintArea = ActiveSheet.PageSetup.PrintArea results in A1:J10

How do I break it out to identify the last row of the print area is 10?

Thanks in advance for any ideas.


Hello I am new to the forum here and have been trying to research this issue and have not been able to find it.

My issue relates to the way the print area decreases as I add another column. For instance I am embedding a word document in an excel file and if I just have column "A" as the full sheet the print area is larger then when I inster a column and re adjust my print area. Has anyone else had this issue? I try to clear my print area and re adjust but all it does is decrease the scale.


Travis I have a client freakingo out, becuase everything a PIVOT table is updated the page breaks and print area does not reset. So if one product is chosen rather than all it prints extra blank pages.

I have followed all of the excel help and have gone to the last cell and deleted all cells up to my data, then copied and pasted it into a new worksheet.

(note: I have about 15 tabs this is happeneing to)

I have also reset print areas, reset page breaks, set the print area to the whole list.

Is there a way to have it automatically detect what cells have data and set the page breaks and print area to that. When I reset the print area it keeps selecting way more cells than needed!

Please help.


I have got "Estimate" sheet, for which I want to set a multiple print area.

I have the range values in a different sheet ("PrintingMargins")

Now, columns D and E in this last sheet contain the cell locations of first and last cells of each range.

D4 = A3
E4 = G46
(that would be the first cell range to use as printable area in "Estimate" sheet (A3:G46))
D4 = A49
E5 = G84
(that would be the second cell range to use as printable area in "Estimate" sheet (A49:G84))

I have got the following function to be triggered from the "Estimate" sheet:
Sub OrganisePrint()
' OrganisePrint Macro

ActiveSheet.PageSetup.PrintArea = ""
ActiveSheet.PageSetup.PrintArea = "$A$3:$G$45,$A$50:$G$49"
End Sub

I need to replace this:

with the content in "PrintingMargins" Column D to Column E (D4:E14), which contains the real cells to be used.

I hope it make sense.

I am not very experienced in VBA. I need the text that appear inside those cells to be the cell value in the range.

It would be cool if it can be error proof, as from the 10 possible range (therefore 10 possible print selections), some of the ranges may be 0 value, due to they care dynamic information, and some times some of the ranges may not be required.

I hope it is clear enough.

Many thanks for giving me a hand with this.


the print area displayed A1:I216 and J1:S216 when print preview.the print area was defined by excel automatically and not manually.when i selected some cells in one page(not always in print area) ,i want to print the page containing active cells,how can i do it?
thanks in advance.

How am I able to format a print area such that it will grey out anything that is not in the area, and where I can drag the print area with the mouse? I have attached an example, I just would like to know how to achieve it.

Thanks in advance!

I'm trying to format an Excel spreadsheet to print; either by selecting the
section I want to print and/or using the view/ page break preview. For
whatever reason it is not alloweing me to reduce the percentage size to fit
on one page --or drag the page borders in the page break preview. The
spreadsheet is columns A through O and rows 1 through 58. Its strange--
here's the error message it gives

This error can appear if you have attempted to print content which cannot
fit on the printable area of the selected printer. Usually this occurs when
you have selected to:
Print to a page size which is not supported by the printer
Change the margins of the page and that range is not supported by either the
printer or the printer driver
Print using a landscape setting and the printer driver is set to portrait
(or the reverse)
Print a set sized object which does not fit into the printable region
The application is set to print to a margin default which exceeds the
printable area of the page (can sometimes happen after changing the default
printer to a different printer)
Print scaling (percentage size to print the final content) is set to a
number below 10%
Printing issues associated with a network printer are best handled by your
local network administrator or support personnel.

When I set the print area on my worksheet I get this dotted line around the print area. Is there any way to make this go away? This did not occur in Excel 2000.

Evening All.
Is it possible using VBA to automatically set a print area of a sheet.
The area that I want to print is worksheet (sheet2) but varies in no of rows.
The columns I want to print are always the same (A:T)
Sheet2 is created by a macro but because it varies in the number of rows, beacuse of this I am always having to set the print area manually. Ideally I want to print A1:T?
T? is the last line where any data is entered on that row.

Hope someone can assist.
Cheers Jase

I don't know why, but I set print area on one of my sheet and when I
open it and close a few times, the sheet looses the setup and I end up
printing it with one column missing
When I check print area it's reset back to the way it was initially
Anybody knows why this happens?
Wamt to mension that I saved the sheet after setting print area
It is landscape mode, left and right margins set to 0.25


My spreadsheets are humungous.

I NEVER want to print out an entire spreadsheet, and I am tired of selecting PRINT SELECTED AREA ONLY or going to SET PRINT AREA.

Can I get EXCEL to ALWAYS PRINT JUST THE SELECTED CELLS if the selected cell is comprised of more then one cell?

Hi folks,

I am trying to use the "Print area" and "Print Title" selectors on the Sheet
Tab of Page Setup but they are greyed out. How can I make them active.

I have the same problem on two different computers each running Office 2000
Pro and one with a Windows 2000 Pro OS and the other with a Windows XP Pro

Any tips on how to rectify this would be greatly appreciated.

Many thanks in advance

If you change the view mode of any sheet to print preview, it will provide blue lines to show the supposed print area. However, I have not found a way for it to actually create the Range("Print_Area") unless you actually set the print area. Does anyone know of a way to do this via vba. It does not necessarily use the used range. I'm trying to write code that sets the print area according to what is on the screen; however, I am having no success b/c i do not know how to identify the last blue lines on the worksheet (horizontally or vertically). They are not considered pagebreaks by excel. So my question is how does excel identify them? How can I reference them via VBA? If anyone can answer this question, you'll have solved a persistent problem that has been bothering me for over two years.

also see post:

Thank You,