Hello

I was wondering if there is some way to get the print preview of different work sheets in the preview window.

For Example:

If my file has 10 different sheets renamed as A,B,C and so on till J

If I am Sheet A, when I click on Print Preview, within the preview window, is there an option wherein I can preview the next sheet without leaving the print preview? Something similar to Next Page in the preview window, except that instead of the "next page", I would like the "Next Sheet".

I know that this is possible by selecting multiple sheets at the same time. I think it is called Grouping of sheets. But the problem is that if I have many sheets (possibly 15-20 or even more), then selecting all the sheets by Ctrl+ Select is a very tedious job.

Am using Excel 2003 (SP3).

Any possibilities?

Thanks

Ashish Pradhan

--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Reply via email to