Ctrl + Enter Magic

Do you know Ctrl + Enter can be used to fill contents and formula in all the selected cells at one shot!!!!.

  • To Fill the Cells with Common Contents
  1. Select All the cells where you need to fill the contents.
  2. Type the content in the first cell like “Win”.
  3. Press Ctrl+Enter to fill all the Cells with Win!!!!.

To Fill the Cells with Formulas

  1. Select All the cells where you need to fill the formulas
  2. Type the formula in the First Cell.
  3. Press Ctrl+Enter to fill all the Cells with Formula.

Keep Learning
Win Corporate

Website: http://www.wincorptrg.com
profile: http://www.urbanpro.com/bangalore/vijayalakshmi-g-m/626432

Advertisements