Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-25-2011, 07:36 AM
derohanes derohanes is offline Resizing the Name range Windows Vista Resizing the Name range Office 2007
Advanced Beginner
Resizing the Name range
 
Join Date: Oct 2008
Posts: 67
derohanes is on a distinguished road
Default Resizing the Name range


I'm using the list in conditional formatting for a dropdown list of tooling (Excel 2007). I identified a range and assigned it the name "Toolinglist" I now have tools that I need to add to that list and therefore need to establish a larger range.

How do I expand the range for "Toolinglist" without renaming it and changing all the references to it in my workbook?
Reply With Quote
  #2  
Old 05-25-2011, 08:10 AM
OTPM OTPM is offline Resizing the Name range Windows 7 32bit Resizing the Name range Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

Hi
When you setup a range that is likely to need expanding it is always best to specify a much larger range. That way you can just add extra entries without having to change the range.
You will need to re-specify the range and then add the extra values.
Hope this helps.
Tony
Reply With Quote
  #3  
Old 05-26-2011, 11:53 AM
derohanes derohanes is offline Resizing the Name range Windows Vista Resizing the Name range Office 2007
Advanced Beginner
Resizing the Name range
 
Join Date: Oct 2008
Posts: 67
derohanes is on a distinguished road
Default

Thanks. That was what I was afraid of. By "re-specify" I assume you mean to use a new name for a new range.
Reply With Quote
  #4  
Old 05-26-2011, 01:59 PM
Colin Legg's Avatar
Colin Legg Colin Legg is offline Resizing the Name range Windows 7 32bit Resizing the Name range Office 2010 32bit
Expert
 
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default

You are using Excel 2007 so you can use a Table. It will automatically expand as you add to it. In the attached example I have created a table containing a list of tools. In H4 I have used data validation to create a dropdown list. If you add a new tool to the list (C9, then C10 etc) you will see that it automatically gets added into the dropdown list.

For reference, in versions prior to Excel 2007 you could use a List (Excel 2003 only) or a dynamic named range.
Attached Files
File Type: xlsx Example.xlsx (12.9 KB, 13 views)
Reply With Quote
  #5  
Old 05-27-2011, 03:05 AM
OTPM OTPM is offline Resizing the Name range Windows 7 32bit Resizing the Name range Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

Quote:
Originally Posted by derohanes View Post
Thanks. That was what I was afraid of. By "re-specify" I assume you mean to use a new name for a new range.
Hi
You would have to delete the range and re-create it using a larger selection. You use the same name again.
I would suggest you use the whole column and keep it sorted for ease of finding the correct tool.
Hope this helps
Tony
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Resizing the Name range custom bullet points - stop image resizing dlee388 PowerPoint 1 12-29-2009 04:47 PM
Sort Range boutells Excel 1 07-15-2009 03:02 AM
PowerPoint Embedded Chart Objects Resizing aeddipa PowerPoint 0 07-06-2009 09:41 AM
Resizing the Name range Range Formula aleksandr Excel 10 05-18-2009 12:14 PM
resizing a checkbox?? aceensor Excel 0 05-10-2006 01:44 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:29 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft