• Skip to primary navigation
  • Skip to main content
  • Skip to footer
WittySparks Logo White

WittySparks

Ignite Your Thoughts

  • Topics
  • Reviews
  • Subscribe
WittySparks / Technology / Software / Smart Tips on MS Excel 2007 – How to create a series?
Microsoft Excel 2007 Tips

Smart Tips on MS Excel 2007 – How to create a series?

Software December 8, 2008 by Kartik Subramaniam

For those of you who have used MS Excel 2003, the easiest way to creating a series comprising of continuous values would be to enter the first two or three values of the series and use the drag handle to fill the remaining values of the series, right?

Well, Excel 2007 gives you the freedom to do away with the mouse and use the keyboard alone to create a series. So, how does it work? The following steps would help you create a series with ease!

a) Enter two or three values of the series in consecutive cells (in one column)

b) Then select the number of cells which you wish to fill with values of the series (let’s say 10 in all)

Excel Series Step 1
Excel Series Step 1

c) Then, use the following shortcuts, Alt+h followed by FI and S. This means you would have to type the following one after the other:

Alt+h+FI+S

The shortcuts shown above take you to Home Tab and then to the Fill Option in which Series is selected. [There are several options in the Series ( linear, growth, date, Autofill) which you could use depending on your series ]

d) This would open the following box which is shown below

Excel Series Step 2
Excel Series Step 2

e) As you can see, the values entered are in the column, so the column field is selected and since the values are linear in nature so, the same option is selected.

f) There is an option by the name STEP VALUE, in this the value which appears is 10, which is the difference in the values of the series. In case, you change the value 10 to 20 in the step value option then, you would get a series which would be 10, 30, 50 …..190 in place of 10, 20, 30,….100. So, the first value of the series stays the same and the following values change. If the step value is not changed, the default value from the values entered in the original column is taken ( in this case being 10)

g) By clicking on OK, you would get the desire series.

I Hope, the post would help you in creating a series without using the mouse! More tips on using Excel 2007 effectively would follow soon, so watch out.

Appreciate your opinion on this topic on social media by tagging us @wittysparks
  • LinkedIn
  • Twitter
  • Like
  • Pinterest

Related Topics

  • Some smart tips on MS Excel 2007-Join & insert space between text
  • Smart Tips on MS Excel 2007 – How to use Subtotal function?
  • Using Vlookup for multiple sheets in Excel 2007
Launch Offer
Rocket.net - Managed WordPress hosting
Rocket.net - Managed WordPress hosting
$1 for first month, $25/month

A highly secured WordPress hosting platform powered by Cloudflare enterprises with customized services for agencies, eCommerce, and small businesses.

  • PageSpeed Guarantee
  • Ultra Secure Platform
  • FREE Migrations
  • Automatic Updates
Try for $1.00 Our Review
We earn a commission if you make a purchase, at no additional cost to you.

Our Favorite Tools

Semrush - SEO and Marketing Tools
Semrush - SEO and Marketing Tools
$119.95/mo
Try for FREE Our Review
Semrush - SEO and Marketing Tools
Lasso - All-in-one Affiliate Marketing Plugin for WordPress
$29/month
Start Free Trial Our Review
Semrush - SEO and Marketing Tools
Grammarly - AI-powered writing assistant
$12.00 / month
Try for FREE Our Review
Previous Post: « Create RSS SMS Alerts via Google SMS Channel
Next Post: Mumbai Terror attacks, resilience to what extent? »
Profile picture for Kartik Subramaniam

About Kartik Subramaniam

A dreamer of sorts & a Creative writer, passionate about reading diverse stuff.

View all posts by Kartik Subramaniam

    Footer

    Search

    Exclusive Coupons

    • Moqups Review - Use coupon code “WITTYSPARKS" for 20% off or "PARTNERS50" for 50% discount on all plans.
    • Serpstat Review - Use coupon code "wittysparks_discount" for 30% off.
    • WPForms Review - Use coupon code "WITTYSPARKS" for 50% off.
    • WPPayForm Review - Use coupon code "wittysparks" for 10% to 40% off.

    Affiliate Disclosure

    If you make a purchase from WittySparks links, we will receive a small commission. See our Affiliate Disclosure.

    Sponsors

    Partnered with FreePik to use the licensed images.

    turn to dhgate for smartphone

    Follow Us

    • Facebook
    • Twitter
    • Pinterest
    • LinkedIn
    • Instagram
    • YouTube
    • RSS

    Copyright © 2022 · Hosting sponsored by Rocket.net (Affiliate link)

    • About Us
    • Contact Us
    • Privacy Policy
    • Affiliate Disclosure