Printing in rest area on already printed sheet

[sanjuss2]

Hi all
I have an excel file in which for eq. first 10 rows are already printed on paper sheet, now I want to print next 10 rows on same paper sheet without overwriting the earlier rows.

Now I am using white colour to the above rows then print the next values but couldn't retrieve the formatting of upper rows again.

It is repetitive job which is doing on daily basis. I am using different files on every day.

Your help on the same will reduce my time as well as efforts .
thanks in advance

[Aardigspook]

Three suggestions:

1. Set the print area to only print the next 10 rows and increase the top margin so that printing starts below the previous print - but then you have to reset them afterwards.

2. Insert a white-filled rectangle shape over the top of your first ten rows, print, then delete the rectangle.

3. Set up another sheet with the first 10 rows blank but the second 10 rows are linked directly to your first sheet, then print from this.

[sanjuss2]

I think 2nd option is better & easy to use every time..... thanks again

[Aardigspook]

You're welcome and thanks for marking the thread as Solved.