Incorporating the Same Data on Multiple Cells Instantly

Often we have to enter the same data in multiple cells at once. The cells can be consecutive, contiguous, split in spread place. This method will be very practical if you are already skilled use. For example when I enter data in a packing list for which data mostly have the same value.

Technique choose the cells that will contain the same data:

• If the cells form a range with adjacent cells.
  Press the F8 key, and move the active cell using the arrow keys, either to the right or to the bottom to form a range. Once the range is formed press F8 to turn off Extend mode.
  
• If the cells scattered in several places.
  Press and hold the CTRL key and click one by one the cells will be filled in the data of the same value.
  
• If the cells contained in a very large range.
  Click the first cell in the beginning of the range and press the F5 key. In the GO TO dialog box type the address of the last cell of the range. Press the SHIFT key while pressing the ENTER key.
  
• If you will select all the cells in the workbook.
  Press the shortcut CTRL + A (Remember, do not mess with this command in Excel 2007, because if later you enter the data means that you will enter data on tens of millions of interlocutory exist in this workbook. And this addition will take approximately one minute will also make use of your computer's memory directly to swell)
  

Entering data after the selected cells

Type the value of the data and then press the CTRL key while pressing ENTER.