#1   Report Post  
kellyaek
 
Posts: n/a
Default 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   Report Post  
JulieD
 
Posts: n/a
Default

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   Report Post  
Frank Kabel
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating a chart with values from two columns Ivan Charts and Charting in Excel 2 December 12th 04 07:31 PM
I enter numbers and they are stored as text burkeville Excel Discussion (Misc queries) 5 December 3rd 04 01:59 AM
How do I take two columns of sequential numbers and insert spaces cmrdjr Excel Discussion (Misc queries) 5 December 2nd 04 10:35 PM
adding only positive numbers Jacob Excel Discussion (Misc queries) 2 November 30th 04 12:24 AM
Negative Numbers Glenda Excel Discussion (Misc queries) 3 November 26th 04 02:06 PM


All times are GMT +1. The time now is 09:04 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"