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:

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. 🙂


About MF

An Excel nerd who just transition into a role related to data analytics at current company......😊 Recently in love with Power Query and Power BI.😍 Keep learning new Excel and Power BI stuffs and be amazed by all the new discoveries.
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: Logo

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

Facebook photo

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

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.