Fill so good…

Answer to the 5 little Tips (tests) – Part 2/5

Fill a series (of sequential numbers)

The task: Fill a big series of sequential number, say from 1 to 24567.

Answer:  You may find the answer to the question in this post:  Fill Series.

That post was indeed inspired by one of the winning MEME posts found in Bacon Bits.

Check this out for some Excel FUN:  http://datapigtechnologies.com/blog/index.php/excel-meme-contest-winners/

Want more?

Fill a series of month-end dates

Try yourself how to fill a series of weekdays only.  It’s super easy when you know where to start.

Feel justified with Fill Justify

This is a very well hidden feature about Fill… Justify.  Check it out and you will be amazed, especially if you are using Excel more on text input than data analysis. 🙂

I hope you feel good with Fill now. 🙂

Advertisements
This entry was posted in Excel Tips and tagged . Bookmark the permalink.

Comments, suggestions, corrections are welcome.

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s