Thread: Deleting a date
View Single Post
Old 07-08-2013, 04:39 AM   #15
BetterRed
null operator (he/him)
BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.
 
Posts: 21,791
Karma: 30237628
Join Date: Mar 2012
Location: Sydney Australia
Device: none
Quote:
Originally Posted by davidfor View Post
BetterRed meant: Press F2, make sure all the text is selected, press the "-" key and then press enter. That will clear the date. Pressing the "=" key with set it to the current date.
BR meant exactly what he wrote

After I press F2 on ANY editable cell in the spreadsheet the content of the cell is always selected - to un-select it I must press home, end, left arrow or right arrow.

There is no need to check anything. To clear a date just press the F2 key, followed by the '-' key, followed by the Enter key; use the '=' to set to today. If you change your mind exit the cell edit with Escape.

BR
BetterRed is online now   Reply With Quote