I had an enormous spreadsheet I’d made by saving a PDF as an Excel workbook and rearranging the data.
I needed to get the data into MySQL but there were countless empty cells where candidates received no votes and I knew that wouldn’t fly. I needed zeroes.
Select all the empty cells by clicking Find & Select in the Editing section of the Home tab in the spawn-from-Hell ribbon-thing and choosing Go To Special.
Select Blanks and click OK.
Press F2 (function key at the top of your keyboard) to select one of the selected empty cells (using F2 prevents deselecting all the other empty cells).
Type “0” and press either Ctrl+Enter on Windows or Cmd+Return on a Mac.