Life and Times of Three Young Professionals, Part 2

From: Emily Gibbons
Sent: Tuesday, February 08, 2011 1:09 PM
To: 'Tara.Garrett'
Subject: Question about excel

Hi TG,

Will you help me with something.

I want to repeat the same formula in different lines of an excel spreadsheet. Is there a way to copy and paste the formula even though the cell blocks are changing?

For example – one formula is (I26+I27)*(I28+I29)

So I want to transfer that same formula to rows A – H….make sense?

Can you help? Do you have any idea what I’m talking about :)

Xoxoxo Em


From: Emily Gibbons
Sent: Tuesday, February 08, 2011 12:11 PM
To: Tara.Garrett
Subject: FW: Question about excel

This is the actual formula… =SUM(H14+I14)*(J14+K14)

So what I actually want to do is just change the 14 so it works for rows 1 – 13…

From: Tara.Garrett
Sent: Tuesday, February 08, 2011 1:50 PM
To: Emily Gibbons
Subject: RE: Question about excel

Yea all you have to do is drag the bottom right box across the cells you want the formula copied to

Tara Garrett | Business Analyst | Seasonal and Stationery | Target.com | 612.304.5571

From: Emily Gibbons
Sent: Tuesday, February 08, 2011 1:48 PM
To: Tara.Garrett
Subject: RE: Question about excel

I don’t get it…

From: Tara.Garrett
Sent: Tuesday, February 08, 2011 2:53 PM
To: Emily Gibbons
Subject: RE: Question about excel

Click on the cell with the formula you want copied. On the bottom right of the box there is a black box that you can click on and drag across other cells…




From: Emily Gibbons
Sent: Tuesday, February 08, 2011 1:48 PM
To: Tara.Garrett
Subject: RE: Question about excel

Omg you are a genius.

A Plane Moment

“Are you from San Diego?” Her chin wobbled as she spoke.

“Originally.” He wasn’t interested in small talk with this woman whose body was a bit too large for her seat.

“I couldn’t be more excited,” she went on without encouragement. “I’ve never been past Arizona.”

He looked at her trying to hide his disgust. He could smell hotdogs and cigarettes on her breath. There was a blotch of dried mustard on her chest.

“It’s quite a sight,” he said.

“You been gone long?” Clearly she was not getting the hint. He grunted in response.

“My name’s Kristi.” She offered with a too wide grin.

“Of course it is.” He muttered at her and turned to the window.

“Don’t you love the runway?” She said.

“Sometimes I wish the whole plane could be made of glass so we could really see everything.” She offered again when he didn’t reply.

“It’s alright.” She said after a moment. “I agree with you really. A plane is the one place in the world you can think anymore. No phones ringing, no e-mails to be answered, televisions to watch. Just you with your thoughts for the whole flight. It’s something to be treasured really.”

At that moment the flip screen televisions came to life in front of them and he grinned as she groaned to herself and shut her eyes.