Hello Guys
Got the solution to my problem described here. Simply right-click on any
sheet and select "Select All Sheets" :-D
A very very preliminary error on my part. Sorry for the trouble.
:-[
Thanks
Ashish Pradhan
On 25/01/2011 16:37 PM, Ashish Pradhan wrote:
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 [email protected]
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel