Enter Data into Noncontiguous Cells in Excel

If you're new here, you may want to subscribe to my RSS feed. Thanks for visiting!

If you have the same data that you need to enter into several cells that are not next to each other, there is no need to enter it in manually or use copy and paste. Simply select the noncontiguous cells and use Ctrl + Enter to fill the cells with your data.

To enter data all at once into noncontiguous cells:

1. Hold down the Ctrl key and select all of the cells into which you want to enter data (Holding down the Ctrl key allows you to select noncontiguous cells).
2. Type your data.
3. Press the Ctrl + Enter keystroke combination. Excel will enter the data you typed into all of the cells you selected.

Similar Posts:

• Creating a Refreshable Web Query in Excel
• Enter data in multiple cells in Excel 2007
• Using Excel 2007′s Extend Mode to Select Cells
• Using Flash Fill – a new feature in Excel 2013
• Move Text using Drag and Drop in Word 2007
• Creating a Hanging Indent in Word
• Easily Move or Copy a Worksheet in Excel

Tagged as: Excel Tips, Microsoft Office Tips