Reliable Web Design - Flagstaff Website Design, Domain Registration, Website Hosting, Search Engine Marketing, and other Internet Marketing Services - Flagstaff Central [Arizona]
Reliable Web Designs - Flagstaff Website Design, Domain Registration, Website Hosting, Search Engine Marketing, and other Internet Marketing Services - Flagstaff Central [Arizona]
Reliable Web Designs - Flagstaff Website Design, Domain Registration, Website Hosting, Search Engine Marketing, and other Internet Marketing Services - Flagstaff Central [Arizona]

Fill Series Command in Excel

I learned a new tip from a client today that really saved me a whole bunch of time working on something for him… I needed to do a whole series of dates and was not looking forward to having to type a whole year into a chart. When I described how it was going to work to the client, he told me about the “Fill Series” command in Excel.

Here are basic instructions:

1) Open a new worksheet in Excel.

2) Type in the date in the first space (which is A1).

3) Right-click on that date and choose [Format] if you wish to change the way it displays (in other words you could have it as 2/27/13 or February 27, 2013 etc…).

4) Click on that date field and either pan to the right (if you want to do this in rows) or pan downward (if you want it in columns) until you have highlighted as many fields as you like to fill in.

5) Go to [Edit] [Fill] [Series]. This opens up a pop-up menu.

6) Change any of the settings you want in the [Series] pop-up menu, and then hit [OK].

This will then fill in all of the dates for you in a series…

This can also be used for other things in a Series too including putting the Days in Order (Sunday, Monday, Tuesday, etc…), consecutive numbers (5,6,7,8 etc…), even doing a row of dollars ($4, $5, $6, $7 etc…)… Very neat!

Latest News | Web Tips Blog

Favorite Quote from Dune

“I must not fear. Fear is the mind-killer. Fear is the little-death that brings total obliteration. I will face my fear. I will permit it to pass over me and through me. And when it has gone past I will turn the inner eye to see its path. Where the fear has gone there will… Continue >>>

Welcome to Munro Law PLLC

I had an interesting conversation with a new client this past week that I thought I’d share.  And, it comes with a recommendation…! As you all probably know, lawyers can be difficult to deal with in business.  Over the years, I’ve had a few lawyer clients and it just hasn’t gone well.  They are picky… Continue >>>

Contact Information

Flagstaff Central.com, Inc.

“Reliable Web Designs” (dba)

Mailing Address:
2532 N 4th Street, PMB#125
Flagstaff, Arizona 86004-3731

Phone: (928) 526-6991
Email: info@flagstaffcentral.com

Facebooktwittergoogle_pluslinkedinmail

For more information about our services, please contact us.

Flagstaff Web Design
& Internet Marketing!

Copyright©1999-2017. All Rights Reserved. The content of this
website featuring Domain Registration, Flagstaff Web Design,
Flagstaff Web Hosting, and Search Engine Marketing site is
owned exclusively by Flagstaff Central.com, Inc. [Flagstaff Arizona].
(All posted prices are subject to change.)

Let us Help you with Your Website!