NOBLE SOFTWARE SOLUTIONS - WE MAKE IT CLICK!

Fast & Easy Method of Filling Non-Consecutive Cells in Excel

By Laura Noble

You may have tried to copy a  group of selected non-consecutive cells and Excel inform you that it can't use this command with a multiple selection. There is a solution to this problem.
 
  1. Select the first cell
     
  2. Press and continue hold down the Ctrl key
     
  3. Select additional cells
     
  4. Release Ctrl key
  1. Type in a selected cell
     
  2. Press Ctrl + Enter. All selected cells will be filled with same entry.
     


The Ctrl + Enter will also work with consecutive cells. After selecting cells, type in entry in a cell and press Ctrl + Enter and cells will be filled with same entry.

©Noble Software Solutions - www.NobleSoftwareSolutions.com - 519-680-2689

Home    Why NSS?    Tips & Tricks   Overview    Course Topics    Contact NSS   Training Rates  Media Room  Privacy

Copyright 2000-2008. Noble Software Solutions, London, Ontario, Canada. All Rights Reserved.

Logo Designed by Elly Fox Graphic Designer