Quick question about spreadsheets - MS Excel in particular

[Howard]

I want to fill up a column of cells with each cell being a multiple of 20, so it would look like this:

20
40
60
80
...

What's the quickest way to do this?

 

[Zanix]

type in 20 and 40, then drag the corner down as far as you want it to go

Edit: the corner that has the little triangle in it. Excel will figure out the pattern and fill the rest in.

 

[KLin]

sigh. Why even bother having other forums?

 

[Howard]

Originally posted by: KLin
sigh. Why even bother having other forums?

I need a quick answer. Otherwise I'd figure it out myself.

 

[Zanix]

Originally posted by: KLin
sigh. Why even bother having other forums?

Time. He's probably working on something and would like a quick response.

Edit: Now if someone would only help ME out...

 

[edro]

Originally posted by: Zanix
type in 20 and 40, then drag the corner down as far as you want it to go

Edit: the corner that has the little triangle in it. Excel will figure out the pattern and fill the rest in.

Freakn awesome!

 

[Howard]

Originally posted by: Zanix
type in 20 and 40, then drag the corner down as far as you want it to go

Edit: the corner that has the little triangle in it. Excel will figure out the pattern and fill the rest in.

Thanks. Call on me any time if you need something I can help you with.

 

[dionx]

i have a quick question in excel too:

if i had data in every other row and every row in between was blank, is there an automatic way to remove the blank rows so that data exists in every row in a more condensed way?

 

[Zanix]

Originally posted by: dionx
i have a quick question in excel too:

if i had data in every other row and every row in between was blank, is there an automatic way to remove the blank rows so that data exists in every row in a more condensed way?

I don't think there's an automatic way. Ctrl and shift are your friends.

 

[Zanix]

Originally posted by: Howard

Originally posted by: Zanix
type in 20 and 40, then drag the corner down as far as you want it to go

Edit: the corner that has the little triangle in it. Excel will figure out the pattern and fill the rest in.

Thanks. Call on me any time if you need something I can help you with.

actually... Look here.

😛 🙂

 

[Yossarian]

Originally posted by: dionx
i have a quick question in excel too:

if i had data in every other row and every row in between was blank, is there an automatic way to remove the blank rows so that data exists in every row in a more condensed way?

yes you could write a little macro in VBA.

 

[z0mb13]

Originally posted by: dionx
i have a quick question in excel too:

if i had data in every other row and every row in between was blank, is there an automatic way to remove the blank rows so that data exists in every row in a more condensed way?

quick and dirty way is to use filter.. you can choose non blanks..

then copy the whole thing and paste in a new sheet

 

[etalns]

Originally posted by: Howard

Originally posted by: KLin
sigh. Why even bother having other forums?

I need a quick answer. Otherwise I'd figure it out myself.

A1: 20
A2: =a1+20

Then copy and paste A2 all the way down and it will change the formula. A1 and A2 being the cell names, and the stuff beside it being the contents of each cell.

If you don't understand what I mean, let me know.

 

[dionx]

Originally posted by: z0mb13

Originally posted by: dionx
i have a quick question in excel too:

if i had data in every other row and every row in between was blank, is there an automatic way to remove the blank rows so that data exists in every row in a more condensed way?

quick and dirty way is to use filter.. you can choose non blanks..

then copy the whole thing and paste in a new sheet

awesome, thanks. i've done the CTRL way for too long.

 

[Howard]

Originally posted by: Qosis

Originally posted by: Howard

Originally posted by: KLin
sigh. Why even bother having other forums?

I need a quick answer. Otherwise I'd figure it out myself.

A1: 20
A2: =a1+20

Then copy and paste A2 all the way down and it will change the formula. A1 and A2 being the cell names, and the stuff beside it being the contents of each cell.

If you don't understand what I mean, let me know.

D'oh, can't believe I didn't think of this.

Sorry Zanix, I have no idea what Access is or does.