Cycle frequently used number formats - Next generation tools for Microsoft Office
  1. Ampler.io
  2. Resources
  3. Excel tutorials
  4. Number
  5. Cycle frequently used number formats

Cycle frequently used number formats

  • Define standard decimal places and thousand separator
  • Define standard format for negative numbers, e.g. red

  1. Select the cells you wish to format as numbers
  2. Click ‘Cycle number format’ or press CTRL+SHIFT+1
  3. Click again to cycle to the next number format defined under Settings>Cycles
Was this article helpful?

Related Articles

Try free