This shortcut allows you to enter the same data at multiple locations at the same time.

This can be a great time-saver whenever you are either entering data or making corrections.

  • Hold down the Control key while selecting the cells to be populated with the same data.
  • With all the cells selected, start entering the data into any of the selected cells.
  • While typing it looks like it’s only going to one location but press CTRL+Enter when done, instead of just Enter and all the selected cells will be populated with the same information.

You can select non-contiguous cells, type an entry, and then press CTRL+Enter.  Whatever you’ve typed goes into all those cells.  It works with Text, Values and Formulas.

Please subscribe to view the full article

Please subscribe to view the full article

You have Successfully Subscribed!