Tag Archives: Fill

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 … Continue reading

Rate this:

Posted in Excel Tips | Tagged | Leave a comment

5 Little Excel Tips (tests)

First of all, Happy New Year of 2017!  Wish you all an Excellent year ahead! Let’s start the year with a simple “Game” which I developed for in-house Excel training in my previous company.  All participants were expected to have basic Excel knowledge. … Continue reading

Rate this:

Posted in Excel Tips | Tagged , , , , | Leave a comment

When you forget to hold Ctrl key for inputting same value to a range…

… Ctrl+D or Ctrl+R is ready to help 🙂 Ctrl+Enter is one of my favorite shortcuts.  It helps me to input a value or a formula to a range simultaneously.  As usual, Ctrl+Enter won’t let me down.  But many times, … Continue reading

Rate this:

Posted in Excel Tips | Tagged , | Leave a comment

Fill a series of month-end dates

In many cases, we may want to create a list of month end dates.  This can be done either by formula or Fill.  Either way, we should input the first month end date (starting date) manually. Using EOMONTH Syntax: EOMONTH(start_date, months)

Rate this:

Posted in Excel Tips | Tagged , , | 2 Comments

Feel justified with Fill Justify

Like majority of smartphone users, Excel users (know how to) use only a little portion of functionalities provided by the tool, even though we pay the full price for the tool… Fill Justify (on the editing group of the Home Tab) is … Continue reading

Rate this:

Posted in Excel Tips | Tagged , | 1 Comment

Combine contents in a range of cells into a single cell, with no VBA nor formula.

  Well, the first thing in your mind maybe using ampersand &  or CONCATENATE to combine them. =A1&” “&A2&” “&A3&” “…… =CONCATENATE(A1,” “,A2,” “……) which is more or less time consuming. Two ways to achieve this quickly Using a combination of … Continue reading

Rate this:

Posted in Excel Tips | Tagged , , | 6 Comments

Fill Series

Auto Fill is a very handy feature in Excel.  I believe many users use it every day.  A simple example is to fill a list of sequential numbers, say from 1 to 18. What you need is to input 1 … Continue reading

Rate this:

Posted in Excel Tips | Tagged | Leave a comment

Text Alignment – Fill

We talked about examples of using “Text Alignment – Indent” in the previous post.  In the coming posts, let’s talk about the rest of the less commonly-used text alignments.  Actually, I find it a bit challenging to cite real-life examples … Continue reading

Rate this:

Posted in Format | Tagged , , | 1 Comment