comments box
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 » Comments box

Comments box

resolvedResolved · High Priority · Version 2003

replyReply Thu 16 Apr 2009, 16:58Delegate Sharon said...

Sharon has attended:
Excel Intermediate course

Comments box

What is the total amount of text one can write in a comments box?

For upcoming training course dates see: Pricing & availability

replyReply Fri 17 Apr 2009, 10:13Trainer Carlos said...

RE: Comments box

Hi Sharon

If you want to add a comment to a cell, the maximum amount of text that you can enter is 32,767 characters (which is the same as the maximum length of cell contents)

Hope this helps

Carlos

Thu 23 Apr 2009: Automatically marked as resolved.

 

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

Excel tip:

How to Remove Duplication's from a selection of data in an Excel 2010 Worksheet

It would take far too much time to scan through rows and rows of data to find and remove duplicate data. So, here's how to do this using a much more efficient method:-

1) Select the data that might contain duplication's
2) Click the ''Data'' tab
3) Go to ''Data Tools'' and click ''Remove Duplicates''
4) A box will appear. Tick the boxes of the columns that you want to use to check for duplicates. Finally, click ''OK.''

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