Google Sheets - clear cells but keep checkboxes

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

jtn3833

Thread Starter
Joined
Dec 29, 2000
Messages
456
Hello all-

I'm new to Google Sheets, and need to use it for this spreadsheet I'm working on. In column 'A' I would like checkmark boxes (tick boxes). But the content of rest of the rows I need to clear occasionally. Is there a way so I can select an entire row and 'clear row', but have the checkmark box remain (ideally the checkmark box would remain and the checkmark would be cleared)?

Clearing the row is the easiest way I know to remove the contents of that row, but I don't want to loose the checkmark box in column 'A' of each row when I clear the contents.

Your thoughts are appreciated.
Thanks,
jtn
 

Couriant

James
Moderator
Joined
Mar 26, 2002
Messages
41,016
How many columns are you looking to clear on a row? and are they separate rows?
 

jtn3833

Thread Starter
Joined
Dec 29, 2000
Messages
456
Usually I clear each column in the row. Using a tablet I hold down the row number and select 'clear row'. By separations in the row, I assume you mean empty cells? There are no empty cells in the row.

Each row is a list of different information, when that information is no longer needed I want to clear it from the spreadsheet, ideally not removing the checkmark box from the first cell in the row.

Thanks for your help,
jtn
 

Couriant

James
Moderator
Joined
Mar 26, 2002
Messages
41,016
I can't say for sure the easiest way as I don't use Sheets, but you can select the cell next to the check (column b) and then hold CTRL+SHIFT and press the Right arrow key. This will highlight all the filled cells, then you can just hit delete. Same thing if you hold CTRL+SHIFT and press Down, it will highlight all the cells up to where there is a blank cell.
 

jtn3833

Thread Starter
Joined
Dec 29, 2000
Messages
456
Thanks for you time and help. I think I'm just going to take the easy way out and instead of using a checkmark box, I'll just put an 'X' in the cell.
Thanks,
jtn
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Members online

Top