0

I have about 50 columns in my spreadsheet and around 5000 rows. In these 50 columns, there is either "TRUE" or it is blank. What's a shortcut to changing all of the blank cells to "FALSE"?

1

Search-and-replace, searching by cell for empty quotes "", replacing with FALSE.

Some versions of Excel may require a different expression to target the empty cells; I've always found it through experimentation and the local built-in help facility.

You can also Export to CSV, open that file in a text editor, do the search-and-replace there, and then load the CSV into a new spreadhseet....

2

First, select the area you'd like to modify. In the Home tab of the ribbon is the "Find & Select" menu; click "Go To Special", select "Blanks" and click OK.

If you'd like, the keyboard shortcut is [Alt] + [H] + [F] + [D] + [S] + [K]

Type in the value you'd like to be in the selected cells, hold down [CTRL] and press [Enter]. The value will fill in the empty cells.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.