Excel Tip – Type the same information into multiple cells at the same time

Select all the cells that you want to populate with the same information, type the information once and then hold down the “Ctrl” key and press “Enter”.

If the cells you want to enter information in to are not together:

Click the first cell you want to highlight

Hold down the CTRL key

With the CTRL key held down click all the other cells you want to highlight

Share this tip on