lehainam,
Set the footer to "&[Page]+1 of &[Pages]+1".

NickHK

"lehainam" wrote in
message ...

Dear all,

I am printing all pages in 01 sheet. Because I have a cover page (1st
page in the report) in Microsoft Word I want footer in Excel to show
from 2 even though it starts from page 1.

For exmaple, I have total of 10 pages but when I print out the footer
in Excel only shows 2 of 11, 3 of 11,... 11 of 11.

Could any one can help me.

Thanks,

Nam


--
lehainam
------------------------------------------------------------------------
lehainam's Profile:
http://www.excelforum.com/member.php...o&userid=18615
View this thread: http://www.excelforum.com/showthread...hreadid=398863