Vickie has attended:
Word Intermediate course
Excel Advanced course
Word Advanced course
Time Management course
Excel Spreadsheet
Hi there,
Working on a excel Spreadsheet with batches I only need to print out the first page, but unfortunately even if I put just print first page it prints out all 3 pages each time.
Is there any way I can do this to save paper as I don't need three pages, but each time I just need one page with the batch on to print out.
Thanks
Vickie
RE: Excel Spreadsheet
Hi Vickie
Thank you for your question.
One way Excel can help is by setting a Print area. If you have already tried this let me know and I'll suggest some alternatives. If you haven't had chance to try this then see if the following helps:
First highlight only the data on your sheet that you would like to print.
Then, keeping the data highlighted, click on the Page Layout tab and choose the Print Area button. From the little menu that appears click on Set Print Area. You can click somewhere else to clear your highlight now.
If you go to Print preview you will see Excel will only print data within the area you set. To reset your print area go back to Page Layout tab, click the Print Area button and choose Clear Print Area. All will now print as normal.
I do hope this helps. If you have further questions please do let me know.
Kind regards,
Andrew
RE: Excel Spreadsheet
Thats great. I did try it , but It came out blank so I must have done something wrong. Followed your steps and it worked.
Thanks for coming back to me so soon.
Really appreciate.
Vickie
RE: Excel Spreadsheet
Hi Andrew,
Just another question I've been wondering about and not sure how to do it.
I have a huge file that I want to create with lots of lines etc, etc. Well it's partially created, but I would like a extra column to put in some files.
our Regional Fund raisers takes a photo of the paying in slips when they go to the bank and email this to us. I would like to in my spreadsheet add this photo at the end of the line after putting in all information in the line and then just in the last column have something to click on to view the photo that they take with their blackberry phones.
is that possible?
Thank you
Vickie
