### Author Topic: Excel challenged  (Read 5916 times)

#### Workinghard

• Pencil Stache
• Posts: 636
##### Excel challenged
« on: March 27, 2014, 10:06:27 AM »
Okay, kinda embarrassed here but I'm totally ignorant with Excel. My brother did this spread sheet for me. It's great as I can put in different sale prices on our home and figure out how long the money will last us based on his assumptions. However, I need to expand it further as it only goes 246 rows and if I increase the value of our home's selling price, I can't tell when the money will run out. I know there's a way to drag cells but I'm totally clueless on expanding it. Any chance someone can fix it for me? At least I know how to do attachments! Thanks.

#### Eric

• Magnum Stache
• Posts: 4057
• Location: On my bike
##### Re: Excel challenged
« Reply #1 on: March 27, 2014, 10:29:10 AM »
Ctrl C -- copy
Ctrl V -- paste

Copy the formulas* in the last row of cells.  Highlight where you want them to go.  Paste.

*And by copy formulas, I mean just highlight the cells and it will automatically know to copy the formulas.

#### the fixer

• Handlebar Stache
• Posts: 1029
• Location: Seattle, WA
##### Re: Excel challenged
« Reply #2 on: March 27, 2014, 10:32:48 AM »

#### Workinghard

• Pencil Stache
• Posts: 636
##### Re: Excel challenged
« Reply #3 on: March 27, 2014, 10:44:37 AM »
Hmm, when I highlight and do a copy/paste, it just copies the figures in the last row versus the built in formulas and new calculations. Obviously, I'm doing something wrong.

Trying to figure out things from the link the fixer sent.....

#### arebelspy

• Senior Mustachian
• Posts: 28461
• Age: -997
• Location: Seattle, WA
##### Re: Excel challenged
« Reply #4 on: March 27, 2014, 10:56:27 AM »
Hmm, when I highlight and do a copy/paste, it just copies the figures in the last row versus the built in formulas and new calculations. Obviously, I'm doing something wrong.

Trying to figure out things from the link the fixer sent.....

There's a few ways to do it, but press control-` (the symbol with the tilde ~, next to the 1) to change everything to formulas, then copy and paste them, then control-` back to change it back to numbers.

Dragging down doesn't work?  (I haven't looked at the spreadsheet).
I am a former teacher who accumulated a bunch of real estate, retired at 29, spent some time traveling the world full time and am now settled with three kids.
If you want to know more about me, this Business Insider profile tells the story pretty well.
I (rarely) blog at AdventuringAlong.com. Check out the Now page to see what I'm up to currently.

#### Le0

• Stubble
• Posts: 215
##### Re: Excel challenged
« Reply #5 on: March 27, 2014, 11:06:05 AM »
The year in that date column is really off. Unless you are forecasting into 2034.

Attached sheet goes to row 500.

Check out that date column.

#### senecando

• Bristles
• Posts: 480
• Age: 34
##### Re: Excel challenged
« Reply #6 on: March 27, 2014, 11:09:41 AM »
arebelspy: You just rocked my excel world. Holy moly.

#### arebelspy

• Senior Mustachian
• Posts: 28461
• Age: -997
• Location: Seattle, WA
##### Re: Excel challenged
« Reply #7 on: March 27, 2014, 11:37:52 AM »
arebelspy: You just rocked my excel world. Holy moly.

Yeah, it can be a useful trick.  :)
I am a former teacher who accumulated a bunch of real estate, retired at 29, spent some time traveling the world full time and am now settled with three kids.
If you want to know more about me, this Business Insider profile tells the story pretty well.
I (rarely) blog at AdventuringAlong.com. Check out the Now page to see what I'm up to currently.

#### Workinghard

• Pencil Stache
• Posts: 636
##### Re: Excel challenged
« Reply #8 on: March 27, 2014, 12:33:28 PM »
Hmm, when I highlight and do a copy/paste, it just copies the figures in the last row versus the built in formulas and new calculations. Obviously, I'm doing something wrong.

Trying to figure out things from the link the fixer sent.....

There's a few ways to do it, but press control-` (the symbol with the tilde ~, next to the 1) to change everything to formulas, then copy and paste them, then control-` back to change it back to numbers.

Dragging down doesn't work?  (I haven't looked at the spreadsheet).

That did it, afebelspy! I'll need to manually add in the dates but no biggie.

Thanks, LeO! Yes, I'm trying to forecast, more or less, how long the money from our home will pay for rent.

#### daverobev

• Magnum Stache
• Posts: 4006
• Location: France
##### Re: Excel challenged
« Reply #9 on: March 27, 2014, 01:29:12 PM »
To drag a series down.. ok try this on a new spreadsheet
Cell A1 type "1" (just the number 1), hit return
Type "2", hit return
Type "3", hit return

Then with the mouse select the three cells. While the three cells are selected (no mouse buttons down), put your cursor in the bottom right corner of the rectangle. It should turn into a black crosshair. Click and hold; drag down down down down. Release

It should fill in cells going down with 4, 5, 6...

#### MDM

• Senior Mustachian
• Posts: 11559
##### Re: Excel challenged
« Reply #10 on: March 27, 2014, 02:22:19 PM »
If you have a date in cell A7 and want cell A8 to have the same day but one month later, use =EDATE(A7,1).

If you have a date in cell A7 and want cell A8 to have the same day but one year later, use =EDATE(A7,12).

Etc.

Copying that formula saves a lot of typing.

#### Workinghard

• Pencil Stache
• Posts: 636
##### Re: Excel challenged
« Reply #11 on: March 27, 2014, 02:36:00 PM »
Thanks for the help everyone!