Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-29-2024, 01:20 AM
p45cal's Avatar
p45cal p45cal is online now Cannot delete content in a cell - please help :-) Windows 10 Cannot delete content in a cell - please help :-) Office 2021
Expert
 
Join Date: Apr 2014
Posts: 956
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

Quote:
Originally Posted by artmusicstudio2 View Post
What makes the cell so resistant?
Cell M1 is a column header of a table (a proper Excel Table (called Tabelle1 in your file)). You're not allowed to use formulae in the header of such a table. Each header of such a table must contain something (cannot be blank). If it is blank, Excel assigns a name to it; Spalte1 in german, Column1 for an english locale. Try to delete any other column header and you'll get Spalte2 etc. Right-clicking the header (or any cell in a table column) and choosing Delete|Table Columns deletes the table column (cells to the right move to the left) and column M is no longer part of the table, so you can put what you like in M1.



I have no idea why, when you try to put a reference to another cell (eg. =W5) it returns plain value 0 (even if there is something else in W5). I can understand it removing the formula, but not why it puts in a 0 (if you try and do that again with another header it puts in 02 etc.).

If your .xls file uses macros you could write a macro to change the headers automatically.
Reply With Quote
  #2  
Old 05-10-2025, 02:26 AM
artmusicstudio2 artmusicstudio2 is offline Cannot delete content in a cell - please help :-) Windows 10 Cannot delete content in a cell - please help :-) Office 2019
Novice
Cannot delete content in a cell - please help :-)
 
Join Date: Mar 2021
Posts: 7
artmusicstudio2 is on a distinguished road
Default

just aying thanx to everyone.

the solutiON AT LEAST WAS CONVERTING THETABLE FROM A NEW FORMAT TO STANDRD SHEET (context)

stan
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
IF cell in Col A is populated BUT cell in Col C is blank DELETE ROW ChrisOK Excel Programming 7 05-05-2019 09:00 PM
Cannot delete content in a cell - please help :-) Wish to delete letters to the right of the cursor in a Table cell, but whole cell is being deleted vjvj123 Word VBA 12 09-27-2018 03:09 PM
Cannot delete content in a cell - please help :-) Delete cell content that has a specific format Daniel Arbeit Excel Programming 1 06-20-2016 03:02 PM
Cannot delete content in a cell - please help :-) Cell Background Color: Base it on Content of Cell? tatihulot Excel 4 08-14-2013 03:24 PM
How can I delete the content of a cell in column if the cell value is more than 1000? Learner7 Excel 2 06-27-2011 05:44 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:54 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