Excel.Tips.Net: Copying Cells to Fill a Range

April 23, 2012 by in Excel Tips

By Allen Wyatt for Excel.Tips.Net

Copying Microsoft Excel Cells to Fill a Range

Excel provides a pair of nifty shortcut keys that can be used to copy cells down and to the right. For instance, let’s say you want to copy the contents of cell C3 to the fifteen cells just below it. All you need to do is select the sixteen cells (making sure that cell C3 is the top cell in the selection) and then press Ctrl+D. Cell C3 is copied to all the other cells below it.

Article Continued Here

Excel Tips

About Excel Tips

The tips and ideas from ExcelRibbon.Tips.Net are designed specifically for users of Excel starting with Excel 2007. You'll find just about everything you need to become productive with the program right away. (If you need help with other versions of Excel, visit the ExcelTips site.)

Leave a Reply

Your email address will not be published. Required fields are marked *


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Scan with PC Matic

Sign up for our FREE Newsletter

Our weekly newsletter is packed with computer tips & tricks.
As a bonus, receive monthly emails with exclusive offers.

Which device is the most important to you?

View Results

Loading ... Loading ...


Contributors