Excel Quick Tip- Enter Data Into Multiple Cells-Super Fast

Written by Barbara in Excel Tips& Tricks,Quickie Tips

 

Here is a really quick Excel tip for entering data into multiple cells super fast!!..just by using the CTRL+Enter.

  • Select the cells you want to enter the value or formula into
  • Type the value or formula you want into the active cell
  • Hold the CTRL key and hit enter
  • That’s it your cells cells are now filled!

Even More Excel Tips

 1. Create a timestamp in Excel with Formulas

2. Using the LEN function in Excel

3. Use the EXACT function to force upper case data entry

 

Barbara

Barbara is an experienced data analyst with over 20 years of experience. Author of the How To Excel At Excel Top 50 Excel tips Ebook, YouTuber and Excel Blogger.

Recent Posts