Skip to main content

Posts

Showing posts from August, 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 th

Trick Auto-Adding Number, Date, Letter...Excel Column With Double Click | Exceltip2day

Hello there. I'm Michael Leng. Today, in my blog "Exceltip2day" , I'm going to talk about: How to use the  "Fill Handle" to get the varies  6 results.   Tip Quiz Do you think which ribbon tap will be used for escape from the header and hooter function? What are the highlights you will learn from our article: ➤  The 6 methods of how to proceed and getting the returning result of an Excel. ➤  The figure shows all the step by step of the method. 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