Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 06-04-2024, 03:20 PM
p45cal's Avatar
p45cal p45cal is offline Why does Excel create a separate name for a table rather than renaming default? Windows 10 Why does Excel create a separate name for a table rather than renaming default? Office 2021
Expert
 
Join Date: Apr 2014
Posts: 962
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default

By using the 'cell name field' you're giving the selected range a name. You can name the same range multiple names, and all will be valid, say, in a formula. But you're not changing the table name. Do this on the Table Design tab of the ribbon, Properties section, press Enter once you've changed it, it won't keep the old name:


2024-06-04_231315.jpg
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Why does Excel create a separate name for a table rather than renaming default? Permanently renaming a word table Deadly48 Word VBA 6 09-12-2017 02:32 AM
Create separate files organized by a column value swilfong Excel 1 08-20-2017 03:09 AM
Problem create different headers using separate sections Rand Word 1 08-11-2015 12:24 PM
Why does Excel create a separate name for a table rather than renaming default? Mail merge from excel - need to create sheets and create a table bluenosebex Mail Merge 5 08-02-2015 05:34 PM
Can anyone here tweek this macro for renaming Excel files based on a cell's contents? chrisd2000 Excel Programming 6 07-01-2014 01:53 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:26 AM.


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