Infolinks

How to automatically Fill Numbers on Rows or Columns in Microsoft Excel 2007, 2010
by: Revengsky Joseph D. Reyes – rjdreyes

There is the chance that you encountered that you need an automatic fill numbers such as 1,2,3,4… in order to certain rows or columns.

HOW TO DO IT? SIMPLE.

1. At MS Excel 2007 or 2010,
Automatically Fill Numbers on Rows or Columns in MS Excel
Select the first cell that you want to fill in. Type the starting value in the cell to fill the series. Drag the fill handle for the appropriate range you want.

2. Use the Fill option then click Series…
Automatically Fill Numbers on Rows or Columns in MS Excel

3. Make an appropriate settings, if you want to automatically fill the numbers in series on the columns, then choose on Series in Columns, Type Linear.
Automatically Fill Numbers on Rows or Columns in MS Excel
Add the Step value 1 and the Stop value – this would be the end point of the value.

See the sample output below:
Automatically Fill Numbers on Rows or Columns in MS Excel

4. Another thing, if you want to make the series on rows, just select on Series in Rows, Type Linear.
Automatically Fill Numbers on Rows or Columns in MS Excel

Sample output would be:
Automatically Fill Numbers on Rows or Columns in MS Excel

BUY MICROSOFT OFFICE 2007,2010 AT AMAZON US:

Feel free to comment here if you found one interesting to share or your own experience. That’s all! I hope this guide and tips helps you out! Cheers! 😀

(Note: Microsoft (Windows and MS Office Suite – Excel) Logo/Images/Pictures has a respective copyright. I used it for demonstration purpose only.)

Related Entries / Links / Sources / Articles / Sources:
MS Office Help Support – Excel – Automatically number rows – Official Site

Related Posts Plugin for WordPress, Blogger...
Share

Leave a Reply

Your email address will not be published. Required fields are marked *