Print only cells with contents in them

[jswd72]

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.

[ragulduy]

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.