Clearing Input Cells with Colour

Let’s say you have a file that has numerous input cells, in numerous sheets. Each  month you must clear the input cells and start the new month. There is a technique that allows you to clear the input cells if you have used a dedicated colour for those cells.

Assuming you have a fill colour that is ONLY used for input cells then this technique is pretty straight forward.

You must do this one sheet at a time. Steps 2 and 3 are not needed for extra sheets, as the dialog remembers the colour.

  1. Press Ctrl + f to open the Find Dialog
  2. Click the Options button
  3. Click the Format drop down and click Choose Format From Cell. Click on one of the input cells.
    Find_1
  4. Click the Find All button
  5. Click inside the bottom section of the dialog and press Ctrl + a, this selects all the cells found, see images belowFind_2
    Find_3
  6. Click the Close button
  7. Type o (zero) and hold the Ctrl key down and press Enter
  8. Done! All the entries now have a zero entered – ready for input

 

Please note: I reserve the right to delete comments that are offensive or off-topic.