Print area and empty rows

[MATT.B]

I have a basic understanding of excel and i'm using version 2003. I was wondering if there was a way to hide the empty rows when printing, i have a sheet set up that lists the customers on it and each day that list changes size one day it could be 54 customers another day its only 26 customers. I'm looking for a way to print only the customers that are on there and having the empty rows not appear with out having to change my print area every time i print. Another solution i could use is is there a way to auto set print area with out using macros/scripts but i would prefer the empty rows to just not print.
Sorry bout caps lock its broken

I WASN'T CLEAR ENOUGH ON WHAT I WAS WANTING DO DO. HERE IS AN EXAMPLE OF MY LOG I NEED TO BE ABLE TO ADD TO THE BLANK LINES BUT I WANT THE BLANK ROW TO NOT APPEAR WHEN PRINTING. RIGHT NOW I HAVE BEEN ADJUSTING THE PAGE BREAKS EACH DAY WHEN I PRINT BUT I WAS WONDERING IF THERE IS A WAY TO MAKE IT SO BLANK ROWS DON'T PRINT I CANT USE THE AUTO FILTER TO ACHIEVE THIS.

[:) Sixthsense :)]

What about using autofilter and selecting non blanks and giving print for the selected visible range alone?

[MATT.B]

what about using autofilter and selecting non blanks and giving print for the selected visible range alone?

i have a basic understanding of excel and i'm using version 2003. I was wondering if there was a way to hide the empty rows when printing, i have a sheet set up that lists the customers on it and each day that list changes size one day it could be 54 customers another day its only 26 customers. I'm looking for a way to print only the customers that are on there and having the empty rows not appear with out having to change my print area every time i print. Another solution i could use is is there a way to auto set print area with out using macros/scripts but i would prefer the empty rows to just not print.
Sorry bout caps lock its broken

i wasn't clear enough on what i was wanting do do. Here is an example of my log i need to be able to add to the blank lines but i want the blank row to not appear when printing. Right now i have been adjusting the page breaks each day when i print but i was wondering if there is a way to make it so blank rows don't print i cant use the auto filter to achieve this.

auto filter will not work for what i'm trying to do i'm not the only one using this log sheet and the other user don't know enough about adjusting print area to do it so each day i'm changing the page brake printing and then changing the page brake back

[Whizbang]

Go to your Named Range Manager.

Select "Print_Area" for the desired sheet.

Edit it to be something like this:

Please Login or Register  to view this content.

This may need to be adjusted depending on your sheet design. Obviously $H:$H will change to whatever your last column is. If column A:A is not filled then you'll need to use another method to determine the last row.

[:) Sixthsense :)]

each day i'm changing the page brake printing and then changing the page brake back

Copy paste the Non Blank (Visible Data) to a new worksheet and select the data range and use Set Print Area.

[MATT.B]

auto filter will not work for what i'm trying to do i'm not the only one using this log sheet and the other user don't know enough about adjusting print area to do it so each day i'm changing the page brake printing and then changing the page brake back

copy paste the non blank (visible data) to a new worksheet and select the data range and use set print area.

please read the problem before posting a solution you answer my question with a solution that i am already using im trying to make it so i dont have to set print area every day!!

[MATT.B]

Go to your Named Range Manager.

Select "Print_Area" for the desired sheet.

Edit it to be something like this:

Please Login or Register  to view this content.

This may need to be adjusted depending on your sheet design. Obviously $H:$H will change to whatever your last column is. If column A:A is not filled then you'll need to use another method to determine the last row.

this doesnt seem to be working i get a print area of 3 rows my first row in my sheet is blank with a date on the far right may be this is causing an issue
and im not sure where to go for named range manager im using page setup to use your formula. may be this is also causing a problem i

[MATT.B]

this doesnt seem to be working i get a print area of 3 rows my first row in my sheet is blank with a date on the far right may be this is causing an issue
and im not sure where to go for named range manager im using page setup to use your formula. may be this is also causing a problem i

i found it. its under insert in 2003 and with a few modifications i was able to get it to work thank you