Tech Talk Discuss PC Hardware, Software, Internet and Other Technology

Simple excel question

Old 09-07-05, 10:40 AM
  #1  
DVD Talk Platinum Edition
Thread Starter
 
Join Date: Feb 2001
Location: New Brunswick, Canada
Posts: 3,161
Simple excel question

for excel, say you have numbers like this your spread sheet

1
2
3
4

How do you select the rest of the cells below that to make it auto fill in 5,
6, 7, 8, etc

instead of typing them all out
ElementZ is offline  
Old 09-07-05, 10:44 AM
  #2  
DVD Talk Legend
 
Join Date: Apr 1999
Location: Aostin, TX, USA
Posts: 19,876
Easy.

Just put 1 and then 2 right underneath. Then highlight both cells at the same time. You will notice that the lower right corner of the highlighted area looks different. Like this:


Click on that corner (your cursor should turn into a '+' sign when you are in the right spot), and drag it down for as many as you need.

This also works with full dates, months, days of the week, etc.

It also recognizes patterns. Like if I start with 1, 3 then it will give me odd numbers.

You also don't need to start at '1'.

Last edited by Y2K Falcon; 09-07-05 at 10:50 AM.
Y2K Falcon is offline  
Old 09-07-05, 10:49 AM
  #3  
Member
 
Join Date: Aug 2000
Posts: 227
Highlight the cell with 4 in it (you'll see a little box appear in the lower right corner of the cell).
Hold down the Ctrl key, and put the cursor over the little box (you'll see a little + sign appear).
Holding down the Ctrl key, and pressing the left mouse button, drag down for as many cells as you would like.
buffotoad is offline  
Old 09-07-05, 10:57 AM
  #4  
DVD Talk Platinum Edition
Thread Starter
 
Join Date: Feb 2001
Location: New Brunswick, Canada
Posts: 3,161
perfect, thanks guys
ElementZ is offline  

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Thread Tools
Search this Thread

Archive Advertising Cookie Policy Privacy Statement Terms of Service

Copyright 2018 MH Sub I, LLC dba Internet Brands. All rights reserved. Use of this site indicates your consent to the Terms of Use.