## Really stupid excel question

Moderator: Baseball Moderators

### Really stupid excel question

Ok, I haven't used excel for a long time, so it's all very fuzzy.
let's say I have different numbers in column A and I want to subtract the same number from all of them.
What is the easiest way to do this?
I could probably figure it out, but my Japanese hasn't gotten quite good enough to understand what even half of the functions will do.

Thanks.
My apologies. I have a nephew named Anfernee, and I know how mad he gets when I call him Anthony. Almost as mad as I get when I think about the fact that my sister named him Anfernee.
nikku88
Major League Manager

Posts: 1434
(Past Year: -4)
Joined: 10 Oct 2004
Home Cafe: Baseball
Location: Osaka

You could make a static field (meaning some random field somewhere) with the number you want to subtract...then do an easy function A(X = whatever field your column of numbers are) - B(Y = wherever your number is located) and then just copy down the function.

Or, I'm sure there is a way in the function menu to just input the same formula without having the number you want to subtract in a field...then copy it down the whole way.

The One, The Only, The Incomparable Mercer Boy.
MySpace blog (updated 6/21 - Pirates walkout.)
Mercer Boy
General Manager

Posts: 3205
(Past Year: -250)
Joined: 22 Oct 2003
Home Cafe: Football
Location: New Castle, PA

In the top cell of the new column where the new numbers should show up (I'll assume this is B1 with the column of old numbers starting in A1) type "=(A1-X)" where X is the number you're subtracting, and without the quotes around it. Then, highlight the entire column, starting with B1 and moving down, and then go to Edit; Fill Down. You can also click and drag down the bottom right corner of cell B1 and that does the same thing.

If you have any more excel questions, let me know, I've been using it a ton recently. A cool thing I noticed is that if you want the top row to stay visible even if you're scrolling down hundreds of cells (such as, say, looking at a bunch of baseball stats ) then all you have to do is click on Row 2 so the entire row is highlighted, and go to Window; Freeze Panes. It's so simple, but I never noticed it until a few days ago.

"Jack, will you call me, if you're able?"

"I've got your phone number written, in the back of my Bible."
LBJackal
Hall of Fame Hero

Posts: 9018
(Past Year: -178)
Joined: 1 Jul 2003
Home Cafe: Baseball
Location: The Hotel Yorba

I would recommend a simple formula in cell B1... =A1-X.

Copy and paste. Pretty simple.

I'm not an expert, but as an accountant, I have to use Excel for every freaking thing I do. You're more than welcome to ask me questions, too.

Want an easy icon?
http://www.fantasybaseballcafe.com/forums/viewforum.php?f=133
All you have to do is beat a few guys at picking Sunday's winners.[/url]
StlSluggers
Hall of Fame Hero

Posts: 14414
(Past Year: -302)
Joined: 24 May 2004
Home Cafe: Baseball
Location: Parking in the gov't bldg @ 7th and Pine. It's only \$3.00 on game day!

Thanks for all the help guys. I managed to do it. Stupid Chinese characters!
My apologies. I have a nephew named Anfernee, and I know how mad he gets when I call him Anthony. Almost as mad as I get when I think about the fact that my sister named him Anfernee.
nikku88
Major League Manager

Posts: 1434
(Past Year: -4)
Joined: 10 Oct 2004
Home Cafe: Baseball
Location: Osaka