Best Microsoft Excel Bloggers

Tuesday, January 25, 2011

Another way to copy!

Everyone has their favorite way to copy. I have lost count on the how many ways there are to copy in Excel - but here is one that many of you may not be aware of. It is a quick way to fill down a column or across a row.
  • Select the range first
  • Enter the formula or value that you want to replicate
  • Press Control and Enter at the same time

Whatever you typed in the first cell will carry down throughout the entire range you selected.  This only copies the formula or value typed - it does not copy any pre-existing  formats that were in the first cell. If you format the data in the first cell and then press Control and Enter, the formatting will also replicate.

No comments:

Post a Comment

Ms. Excel- Resident Excel Geek