Many of us have used the great auto fill features that Excel has to complete a list, but what about those few times when we need the exact same information in each cell? Here is how you can do that without all the copy/ pasting. First highlight all the cells you need to have the same text, and then just start typing the information you would like to have in all the cells (note: DO NOT try and click in a cell before typing this will just un-highlight all your cells.) When you have finished entering your information instead of hitting Enter, press CTRL+ ENTER and it will fill into all your highlighted cells. This also works if you need the exact same formula in several locations of your spreadsheet.
You are here: / / Inserting the Exact Data into Numerous Cells at the Same Time in Microsoft Excel 2010