The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

Naming Ranges

Resolved · Medium Priority · Version 2003

ReplyWed 17 Jun 2009, 16:07Delegate David said...

Naming Ranges

If you have named a range say A2:A5 and you want to extend it A7 do you have to delete the range and re-do it A2:A7 or can you edit it

For upcoming training course dates see: Pricing & availability

ReplyThu 18 Jun 2009, 09:09Trainer Carlos said...

RE: Naming Ranges

Hi David

You can edit any range previously created. To do this:

1. Select the Insert menu and then select Name
2. Click Define in the sub menu
3. The Define name dialog box appears
4. Select the Name to be edited
5. Change its address in the Refers to: area
6. Click OK

The Name will now refer to the new range

Hope this helps

Carlos

Excel articles

· Jazzing Up Excel With Graphics
· Where Are The Form Controls In Different Versions Of Excel
· Prepare for your MOS Certification with MS Excel Courses
· Microsoft Excel Training Courses or Consultants: Which Is Better For Your Company?
· Microsoft Excel Training: Not Just for Newbies Anymore

Please browse our web site to find out more about
advanced excel course 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

Is there a way to put either layers or cells into a table without them jumping around?

» Forum post: Dreamweaver

Rate this page:

Currently 2.15/5
1
2
3
4
5

2.2/5 (213 votes cast)

Add to:

Follow @beststl on Twitter

© 2012 Best STL. All Rights Reserved. A Microsoft software training company. info
All prices offered for business users and exclude VAT. E&OE · Terms and Conditions