Excel 2013

How to Sequentially Input Data in your Excel Worksheet

It is not out of the ordinary to need to enter a series of numbers within a range of worksheet cells. For example, you may need to enter a series of numbers in the first ten columns of a certain row, or you may have a need to enter information just in a range of ten cells in a particular column.

To sequentially enter information in a range of cells, you should always first select your cells. You will notice that Excel will leave the top-left cell in the range as the input cell (it appears white and outlined). The rest of the cells in the range are shaded, to show that they have been selected.

Now all you need do is start entering your numbers. When you do, the value you keyed in is entered into the input cell. When you click Enter at the end of the value, Excel will save the value and move the input cell to the next cell in the selected range. Excel will move the input cell either left to right, top to bottom or top to bottom, left to right.

Good to know right?

Subscribers Word 2016

Subscribers: How to Have AutoFitting Tables in Word

We all know that it is very easy to add a table to our Word documents. However, once you have your table situated in your document,  you might want to adjust the width of your columns to suit your needs. There are many methods to do this, but one of the most expedient ways you […]

This content is exclusively for Carol's Corner Office Subscribers.
If you are a Subscriber please Log In below.

Not a Subscriber? Please Consider becoming one today for ONLY $20/yr. Your subscription supports the site and gives you access to many exclusive resources not available to non-subscribers, as well as substantial discounts on Carol's Microsoft Office books.

  • Exclusive in-depth content ONLY for subscribers. Use Microsoft Office like a Pro!
  • Large color screenshots illustrate the instructions so following along is easy!
  • Email notification of each new exclusive post for subscribers!
  • Exclusive discounts on Office books and other products!