Email:      Pass:    Pass?
Close Window   
TE
Subscribe for Email Updates!
Excel tips, help, and more!
E-mail:


Advertisements


Free Excel Forum

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.



Similar Excel Video Tutorials

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







Hi All,

So I am having some issues with using the Print Area in excel, below is the area set with the page setup to fit 1 by 1, 600 dpi, portrait:



So as you can see it looks all fine and dandy, but going to my print preview I see this:



As you can hopefully see (sorry my paint skills aint up to scratch!) the right handside of the print area gets chopped off, meaning a few of the most recent coloumns of data dont show.

I cant figure out where exactly I am going wrong with this, as it all looks fine to me!

Any help would be appreciated, thanks!


Alright, I will try to explain this as best I can:


http://img122.echo.cx/img122/2373/13lb1.jpg


Area 1 is the inputed data with a few forumla collumns

Area 2 is the unused rows that have no data

Area 3 is all formula's derived from area 1

Area 4 is all formula's derived from area 1




Now, if I select this whole area as the print area, it prints as shown above.

However, I want to only show Area's 1/3/4 on ONE page.

I have tried to select only Area 1/3/4 as the print area however it displays each area on it's own page.


In the end I want it to look like this:

http://img122.echo.cx/img122/7956/20iy.jpg



Any help would be greatly appreciated.

Sincerely,
Jonathan


I have an amortization table that I can put in different loan years which will vary my print area. Is there a way to have the print area adjust based on the last column that has actual data? All the cells down to the 30 year mark will have a formula in them, they just may not show up as blank cells if I dont use a 30 year schedule.

The sheet I need to have this work on is called "Amortized" and the print area will always start from column/row "B1" and the last column/row will be "I???"

I think this can be done with a a named range, but im not really sure how. Any help would be appreciated.


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

Jeff


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.

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!




Hello,

I would like to set the printer area of an Excel worksheet. I would like to print one page starting from row A3005-V3220. However, I cannot change the print area. Excel wants each row to be another page. When I drag the blue print area lines, nothing happens. So right now I have 216 pages and only want one!

Thank you in advance for your help!

~az!

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.




pan.jpg

Hello everybody! o/

I'm trying to figure out a way to create a column with the value of the item considering its "area" (the image can explain what this 'area' means for), from a pivot table, in this format:


The column; What it REALLY means (the order)
1.1.1 - 1st area; 1st state of 1st area; 1st unitsSold of 1st state of 1st area
1.1.2 - 1st area; 1st state of 1st area; 2nd unitsSold of 1st state of 1st area
1.2.1 - 1st area; 2nd state of 1st area; 1st unitsSold of 2nd state of 1st area
1.3.1 - 1st area; 3rd state of 1st area; 1st unitsSold of 3rd state of 1st area
1.3.2 - 1st area; 3rd state of 1st area; 2nd unitsSold of 3rd state of 1st area
1.3.3 - 1st area; 3rd state of 1st area; 3rd unitsSold of 3rd state of 1st area
1.3.4 - 1st area; 3rd state of 1st area; 4th unitsSold of 3rd state of 1st area
2.1.1 - 2nd area; 1st state of 2nd area; 1st unitsSold of 1st state of 2nd area
2.2.1 - 2nd area; 2nd state of 2nd area; 1st unitsSold of 2nd state of 2nd area
2.2.2 - 2nd area; 2nd state of 2nd area; 2nd unitsSold of 2nd state of 2nd area
3.1.1 - 3rd area; 1st state of 3rd area; 1st unitsSold of 1st state of 3rd area
3.1.2 - 3rd area; 1st state of 3rd area; 2nd unitsSold of 1st state of 3rd area
3.2.1 - 3rd area; 2nd state of 3rd area; 1st unitsSold of 2nd state of 3rd area


Some of you have already stuck with something like this?

I have already tried a lot o COUNTIF like, but none of them solved; some got really close!


Tks!

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!