+- HP Forums (https://www.hpmuseum.org/forum)
+-- Forum: HP Calculators (and very old HP Computers) (/forum-3.html)
+--- Forum: HP Prime (/forum-5.html)
+--- Thread: Spreadsheet App question - how do I delete a column name ? (/thread-1530.html)
Spreadsheet App question - how do I delete a column name ? - Michael de Estrada - 06-04-2014 12:40 AM
I have a saved spreadsheet where I named several columns, and now I want to delete the names and revert to the default names, ie. A,B,C etc. I can change the names easily enough, but there doesn't any way to delete them. If I attempt to enter the original names such as A,B,C etc, or if I attempt to delete the current name and enter a blank line I get an error message "invalid input". I can delete the spreadsheet, but cannot reset it. Any ideas ?
RE: Spreadsheet App question - how do I delete a column name ? - Tim Wessman - 06-04-2014 01:20 AM
Tried entering no (empty) name? (dont have anything handy at the moment, but that would be my guess)
RE: Spreadsheet App question - how do I delete a column name ? - Michael de Estrada - 06-04-2014 01:23 AM
(06-04-2014 01:20 AM)Tim Wessman Wrote: Tried entering no (empty) name? (dont have anything handy at the moment, but that would be my guess)
Not sure what you mean, but it won't accept a blank name.
Edit, I just figured it out. You just highlight the cell and hit backspace.
RE: Spreadsheet App question - how do I delete a column name ? - cyrille de brébisson - 06-04-2014 06:04 AM
hello,
> How do I 'erase' a cell/ row/ column name
select the cell, do Format / Name / backspace / OK and the name will be erased and you will get back the original cell/ row/ column name.
cyrille
RE: Spreadsheet App question - how do I delete a column name ? - Michael de Estrada - 06-04-2014 12:52 PM
(06-04-2014 06:04 AM)cyrille de brébisson Wrote: hello,
> How do I 'erase' a cell/ row/ column name
select the cell, do Format / Name / backspace / OK and the name will be erased and you will get back the original cell/ row/ column name.
cyrille
No, this does not work. It leaves the name unchanged. However, if I simply select that particular cell and hit the backspace key it does work.