How Do I Only Show Print Area In Excel?

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.

Stuart

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.

Hi
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.
Graham

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.

http://imageshack.us/photo/my-images/269/66605410.jpg/



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

...Excel 2003 & 2007...

I'm setting the print area via VBA and as you all know it's way too slow. Here is how I am currently setting the print area (where WCount is a variable I've already set):

Range(Cells(1, 1), Cells(WCount, 14)).Select
ActiveSheet.PageSetup.PrintArea = ActiveWindow.RangeSelection.Address

I've seen other threads where people mention Excel 4 macros and it speeding up this process, but for the life of me I can't find an example to set the print area using Excel4Macros.

Another option would be to have a "Before_Print" method that sets the print area before the user prints. Is there a "Before_Print" method, or is there a way to create one. I didn't see it in the default worksheet methods.

Thanks for your help!

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.

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:

=Notes!$A$1:INDEX(Notes!$A:$Z,final_Note,5)

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.

Does anyone know how to eliminate the print area of a tab so that the tab is visible (i.e., not hidden), but so that none of the contents of the tab print? We have tried removing the cells from the print area and clearing print area, but it just springs back automatically. Any thoughts would be appreciated.

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.

Steve

Is there any way that i can change the print area using a macro so
that the current print area is moved a further 8 columns down the
worksheet, but the size of the print area stays the same?

Thanks,
Aaron

I would like to ask you if is possible to have a excel file with saved properties for printing anytime I open any worksheet (I don't want to set up printable area and print without background each time I open excel sheet and want to print the document).
Is that somehow possible without macros?

I hope my question is understanable Thank you for answer ...

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.

Thanks!

Travis

Hi, I'm using excel 2007 on windows vista. I'm trying to adjust print settings so that the 1st 10 rows of my sheet are not printed.

I could do this using the print area, but then I have to set a fixed area (like Cel A11 to F20).

This sheet however, is dependent on the input of users, so I would rather have it print as far as cells are filled in (as default, but then without the first 10 rows).

thanks in advance!

Hi,

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.

PrintingMargins:
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))
etc

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

'
ActiveSheet.PageSetup.PrintArea = ""
Range("A3:G45,A47:G144").Select
Range("A47").Activate
ActiveSheet.PageSetup.PrintArea = "$A$3:$G$45,$A$50:$G$49"
End Sub

I need to replace this:
$A$3:$G$45,$A$50:$G$49

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.

Luis

I have determined how to set the print area of a sheet.

psActivePage.PrintArea = UserRange.Address

But I can't figure out how to get what the current print area range is once it has been set. I would think this would work, but it gives an error.

Set rPrintArea = ActiveWorkbook.Names("Print_Area").RefersToRange