microsoft excel courses - name box character length
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 » microsoft excel courses - Name box character length

microsoft excel courses - Name box character length

resolvedResolved · Low Priority · Version Standard

replyReply Fri 17 Aug 2007, 13:58Delegate Minnaar said...

Minnaar has attended:
Excel Advanced course
Excel VBA Intro Intermediate course

Name box character length

What is the maximum number of characters that can be used in the NAME BOX?

For upcoming training course dates see: Pricing & availability

replyReply Fri 17 Aug 2007, 15:31Trainer Tracy said...

RE: Name box character length

Hi Minnaar,
A named range can contain up to 255 characters although any named ranges longer than 253 cannot be selected using the Name Box.

Hope that helps

Tracy

replyReply Wed 22 Aug 2007, 08:57Delegate Minnaar said...

RE: Name box character length

Thank you for resolving this.
Regards

 

Excel tip:

Highlighting a data range

Attempting to use a mouse to highlight a large range of cells with data in Excel can make the mouse to have a life of it's own!

Use keyboard strokes instead.

Step 1. Place the cusor in the cell where the highlighting should begin.

Step 2. Select keystroke, CTRL+SHIFT+END

This will take the cursor to the furthermost bottom corner of the data range found in that worksheet. And highlight that range of cells at the same time




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