Copy of LOTO Form2.xlsxCopy of LOTO Form2.xlsxI would like to find a way to change the print area of my excel page to only print cells that have contents in them and ignore empty cells. This is if an employee deletes several rows the print area will be adjusted.
Last edited by jswd72; 08-11-2014 at 10:06 AM.
It sounds like what you essentially want to do is reset the used-range of your worksheet. See if this helps at all:
support.microsoft.com/kb/244435
It would depend on what your worksheet looks like though, if you want to skip blank rows between the first and last set of data in your worksheet then you probably want to filter the data or something.
Maybe if you could upload an example worksheet with some examples of the sort of data you are working with and what you want the printout to look like then I could be of more help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks