0
How do you auto-complete a column in Excell with the date from today to any other specific date?
Wiki User
∙ 14y ago
- Enter the date in a cell.
- Click and drag the small square (Auto-Fill) in the bottom right corner of the cell as far down the column as you like.
- Let go of the mouse button and observe the dates.
This method only copies the same date without change it .
I found a method to make change of the date :
1. Enter the date in a cell (lets say cell A1 )
2. Click the next cell under the first one( the cell B1) and then in the Formula bar put the formula " =A1+1 " ( without " ")
3. Click and drag the small square (Auto-Fill) in the bottom right corner of the cell as far down the column as you like.
P.S. : to enter a date in a cell you click in the upper tab Formulas > Date and time > Date
That way you will have on each cell all the dates you need.
Wiki User
∙ 14y ago
Add your answer:
Earn +20 pts
How do you work out percentage out on excel?
Enter the percent in one column, enter the other value in another column. In a third column tell excell to multiply the 2 columns and divide by 100.
Why do others attack those who excell at life?
Because people like to feel as if they have power.In other words, humans suck.
Do Men Excell in Various Aspects of Life or Women Excell?
Women are superior in all things. It's nonsense to suppose that either sex is dominant in all areas . So far, generally speaking, men excell in things that require physical strength , and women are much better at having babies . Other than that, most fields of endeavor are topped by individuals with brains, determination, and a willingness to work hard to achieve their goals .
What are Arabians use for?
You can find Arabians successfully competing in EVERY event any other light horse breed does. The excell at long distance rides
What is a column of data in a worksheet called?
It is called a column. There is no other official special name.
How strong is a fiberglass column in comparison to other other materials?
A fiberglass column is much lighter and stronger in comparison to other other materials. You can read more at www.kastenmarine.com/alumVSsteel.htm
How Can you repair a gm tilt steering wheel with no key in column?
If the column has no key cylinder, just like any other column. If the key is lost/missing re-building the column will replace the cylinder.
What is an artificial end to a column to balance columns or to provide space for the insertion of other objects?
manual column break
What is column width?
Column width is what it says -- how wide the column is.
What is the OTHER name for your backbone?
Vertebral column, or vertebra.
How does column chromatography separate a mixture of methylene blue and methyl orange?
Methylene blue and methyl orange will have different binding affinities with the column material, and thus one will pass through the column more slowly than the other. This will result in one of the compounds being eluted from he column before the other. The one with the weakest binding to the column will be eluted first.
What is a 4 figure grid refrence?
It is a method used to identify a specific area on a map. The map is overlaid with a grid or square boxes in columns and rows. Each row and column have a number. By giving a row and column number any particular box or part of the grid can be identified. It should be noted that in some countries the column number is given first followed by the row number, in other countries, this is reversed. Be sure you are aware of which convention is being used.
