basic excel training - documenting and auditing
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 » basic excel training - Documenting and Auditing

basic excel training - Documenting and Auditing

resolvedResolved · Low Priority · Version Standard

replyReply Tue 18 Dec 2007, 16:27Delegate Nicola said...

Documenting and Auditing

How do I hide a comment box??

For upcoming training course dates see: Pricing & availability

replyReply Tue 18 Dec 2007, 17:17Trainer Rajeev said...

RE: Documenting and Auditing

Dear Nicola

Hiding a Comment box is quiet simple. All you have to do is move your mouse away from the cell which contains the Comment!!

You can simply go to View > Comments to view all your comments. If it gets too much and the comment boxes obscure your view then you can either drag them away from the worksheet may be near the formula bar or toolbars. Note that there will be an arrow attached to it.

You will see a new Reviewing toolbar appear on your screen. You can click on the fifth button from the left hand side called

 

Excel tip:

Concatenating Results of Formulas

To concatenate the results of formulas simply add the "&" after the formula or function closing bracket.

function1(....)&function2(.....)

see example Creating a range of monthly payments as text.

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