Forum Discussion
Solved
IF cell is empty
I have to upload a spreadsheet and all cells must have something in them. So I want to fill in all blank cells in column A with "A", column B with "B", etc. but if a cell has data I want to leave it ...
Instead of a formula, use the Goto/special function to select the blanks and then type the A, B, C, etc. Select Column A, then hit F5, then click the 'Special...' button, choose the "Blanks" option, then 'OK'. This highlights the blank cells only and all you have to do is type A and Ctrl+Enter. Repeat for the next columns.
Instead of a formula, use the Goto/special function to select the blanks and then type the A, B, C, etc. Select Column A, then hit F5, then click the 'Special...' button, choose the "Blanks" option, then 'OK'. This highlights the blank cells only and all you have to do is type A and Ctrl+Enter. Repeat for the next columns.
That works great! Thank you!
