Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Numbers in Columns
Hey! I am wondering if anyone knows an easy way to write a column of numbers
(say beginning with 401 and ending with 499) without having to type in every number - whats the easiest way to do that? |
#2
|
|||
|
|||
Hi kelly
one way, type the 401 in a cell move the cursor over the bottom right hand corner until you see a + (this is the Autofill handle) hold down your control key and then your left mouse drag down the rows let the mouse go and then the control key. Cheers JulieD "kellyaek" wrote in message ... Hey! I am wondering if anyone knows an easy way to write a column of numbers (say beginning with 401 and ending with 499) without having to type in every number - whats the easiest way to do that? |
#3
|
|||
|
|||
Hi
one way: in the first cell (e.g. A1) enter 401 in the second one =A1+1 and copy this down -- Regards Frank Kabel Frankfurt, Germany "kellyaek" schrieb im Newsbeitrag ... Hey! I am wondering if anyone knows an easy way to write a column of numbers (say beginning with 401 and ending with 499) without having to type in every number - whats the easiest way to do that? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a chart with values from two columns | Charts and Charting in Excel | |||
I enter numbers and they are stored as text | Excel Discussion (Misc queries) | |||
How do I take two columns of sequential numbers and insert spaces | Excel Discussion (Misc queries) | |||
adding only positive numbers | Excel Discussion (Misc queries) | |||
Negative Numbers | Excel Discussion (Misc queries) |