excel
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel

Excel

resolvedResolved · Urgent Priority · Version 2007

replyReply Wed 12 Oct 2011, 14:19Delegate Jodie said...

Jodie has attended:
Excel Intermediate course

Excel

Hello,

I sent a message yesterday afternoon to trainer Mark and havent had any response!

I am having trouble with a document i am working on and am struggling to make column A display when printed... is it possible for me to email you the document so you can help?

I would appreciate it if someone could get back to me as soon as possible.

Kindest regards,

Jodie

For upcoming training course dates see: Pricing & availability

replyReply Wed 12 Oct 2011, 14:29Trainer Rodney said...

RE: Excel

Hello Jodie,

Sorry about the delay in replying to your question about including column A in the printout.

Yes, you can email the file to me at:

rl

Awaiting your reply...

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer

replyReply Thu 13 Oct 2011, 14:18Trainer Rodney said...

RE: Excel

Hello Jodie,

I was expecting your call this morning, however, since I am working from home today, give me a call whenever you have some time.

I have opened the file which you sent back to me and fixed the page breaks on the left side to include column A. I will attach this file and hopefully it will work for you.

Page breaks are always worked on in the Page Break Preview and is a series of blue horizontal and vertical lines as well as an outside border. You can adjust the areas you wish to print simply by dragging these lines. Drag vertical lines left or right. Drag horizontal lines up or down.

Try and experiment with doing the above.


I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer

Attached files...

Jodie_Document 1_1.xls

replyReply Tue 18 Oct 2011, 12:03Delegate Barry said...

RE: Excel

Hi Jodie, the only thing I would say in addition to what Rodney has said above is do you really need as many pages (28) for your initial worksheet, you can always add more pages later. I don't know what information you are going to put on the "All" worksheet but I have selected "Wrap Text" which will also save you space as well. Wrap Text might not be your cup of tea for your information but just give it a try you can always change it back to how it was. If you need help with that then please ask.

Baz

 

Please browse our web site to find out more about
training in excel and other Microsoft training courses.

Excel tip:

Counting Blanks

Some times you want to check if there are cells missing data in your range. You can use the COUNTBLANK FUNCTION to acheive this. It is =COUNTBLANK(Range). Note Cells with formulas that return "" (empty text) are also counted. Cells with zero values are not counted.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard