Saturday, August 3, 2013

Auto-Fill Out The Respective Data Intervening by Non-Adjacent Cell Each

Suppose we have input data into the cells in Excel lines of spreadsheet already. The problem to be fixed is how to fill out the respective contents/data automatically such as the 12 months of a year {Jan., Feb., Mar,.}.

Also, one with the term of condition that in the cells of every other row has the empty rows(non- adjacent cell) between each of the row.

Here we go together to tackle this kind of problem with the tip below:
  • Fill out the first word of the respective data into the first cell. According to the upper illustrated image providing below, it has the word “Jan” in cell “D2”.
  • Next step input the secondary respective content into the active cell underneath next to the left-adjacent cell. In here the “Feb” is in the cell “D4”, see the illustrated picture shown below as well.
  • Moving the cursor of your mouse to select the cell "D2" to "D5".
  • Move the arrow cursor mouse to the "Fill Handle"[a small black square symbol] at the lower right corner of Cell “D5”
  • Last action, do double click onto the "Fill Handle"[a small black square symbol] or drag downward vertically and then stop at any cell as you desire.

See the image below, the result should came out serially the “Mar” appearing in cell “D6”, “Apr” in cell “D8”, “May” in the cell “D10”,. and so on.


The function works with the almost entire standard respective contents/database such as:

Number {(1, 2, 3, 4...), or (1, 3, 5, 7...)}
Weekday {Monday, Tuesday, Wednesday...}, or {Tuesday, Thursday, Saturday...}
Month {January, February, Mar, April...} or {Mar, Jun, Sept, Dec...}

The order of the respective data can be skipped 1 word, 2 words, 3 words, and so on as wanted, remember that the further data will display depend on how many the order skipping between each.

See more:

Thursday, August 1, 2013

Trick Auto-Adding Number, Date, Letter...Excel Column w/ [Double Click]

Do you know any trick for adding date, number; and so on with double click instead of copying and dragging?

In Excel, we are able to input data into the entire column that they are in the same standard respectively with just only a double click such as:
  • Number {1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11...}, 
  • Day {Sunday, Tuesday,. Monday}, 
  • Month {January, February, March, ..December}
  • Year {2000, 2001, 2002, 2003..}
  • Year {2000, 2002, 2004, 2006..}
  • Year {2001, 2003, 2005, 2007..}
  • And more 
And it’s pretty simple for handling such that the stated operation too.

It is not necessary starting from cell 1. The beginning cell can be started at any cell where wanted to operate it.  

Please have a look an image attached for more ease understanding.

See methods step by step below:
  1. In put a beginning data of your respective database into the first upper cell of a column. [Here is number “1” in Cell “A1”]
  2. This step, input a secondary database in the beneath cell as of the line above. [Number “2” in Cell “A2”]
  3. Move a mouse pointer to a [Fill Handle], a very small square at the below right corner Cell “A2” and double click on it.
Immediately, the future respective standard database is coming out in the cell A3, A4, A5, A6, A7,..until the ending cell of the column that must along to the next adjacent column too.

Anyhow, this task will work only the column next to the adjacent active cell(s) column. It means the connecting column with cell(s) has data inside it through the column from top to down. 

In case there is an empty cell; the blank cell which has no any data inside it, between all cells in the same column. The respective data that being auto-fill out will end up at the last cell in the column which there is any non-active cell on the left or right column. Only clicking on the "Fill Handle" lower right corner the recently end cell that just it has been done. 

After do double click, once if the operation would stop at any cell again, keep doing double click on the "Fill Handle" repeatedly and again until your job being done.

Did you find this article useful?

See you in the next article.
Michael Leng.

See more tips: