Hi I have a very large spreadsheet, some of the cells in it are completely blank, and I wish to change the blank cells so that they instead have a dash in them. Is there is quick way of achieving this?
1.Select the range that you want to apply dashes to (including non-blank cells)
2. Go Edit>Goto>Special Button>Check Blanks checkbox, click OK
3. Type: ="-" and confirm with Ctrl+Enter (ie not just Enter)