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.
  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
  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.