Results 1 to 8 of 8

Print area and empty rows

Threaded View

  1. #1
    Registered User
    Join Date
    09-15-2014
    Location
    michigan
    MS-Off Ver
    2003
    Posts
    94

    Print area and empty rows

    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.
    Attached Files Attached Files
    Last edited by MATT.B; 09-22-2014 at 08:02 AM. Reason: NOT ENOUGH INFO INCLUDED

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 09-05-2013, 03:32 AM
  2. Replies: 1
    Last Post: 02-12-2013, 12:16 PM
  3. Replies: 0
    Last Post: 05-18-2012, 06:59 AM
  4. Programming to set print area and resize rows
    By prawer in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-31-2009, 06:01 PM
  5. Replies: 8
    Last Post: 05-23-2007, 06:39 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1