Three Ways To Enter Into A Range In #Excel

Here are three different ways to enter data or formulas into a range of cells in Excel:

You can download the file here and follow along. If you get a preview, look for the download arrow in the upper right hand corner.

The three ways you can enter data into a data range are:

1) Type in the data => Using the Auto Fill handle, drag it across the columns => Drag it down the rows

2) Highlight the data range first => Type in the data => Instead of hitting Enter, use Ctrl + Enter (hold down the Ctrl key while you hit Enter)

3) Type in the data => Highlight the data range => Hit the F2 key to put it into the Edit mode => Use Ctrl + Enter (hold down the Ctrl key while you hit Enter)

Happy Excelling!

Related Post

Free Download!

Subscribe to Download Your FREE Copy of
"My 70+ Favorite Excel Keyboard Shortcuts" Today!

, , , ,

No comments yet.

Leave a Reply