Really stupid excel question - Fantasy Baseball Cafe 2014

## 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: 1438
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: 3455
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: 9196
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.
StlSluggers
Hall of Fame Hero

Posts: 14716
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: 1438
Joined: 10 Oct 2004
Home Cafe: Baseball
Location: Osaka

### Who is online

Users browsing this forum: No registered users and 6 guests

Forums Articles & Tips Sleepers Rankings Leagues

Today's Games
Wednesday, Sep. 17
(All times are EST, weather icons show forecast for game time)

 • LA Dodgers at Colorado(3:10 pm)
 • San Francisco at Arizona(3:40 pm)
 • Toronto at Baltimore(7:05 pm)
 • Boston at Pittsburgh(7:05 pm)
 • Washington at Atlanta(7:10 pm)
 • Miami at NY Mets(7:10 pm)
 • NY Yankees at Tampa Bay(7:10 pm)
 • Cincinnati at Chi Cubs(8:05 pm)
 • Cleveland at Houston(8:10 pm)
 • Chi White Sox at Kansas City(8:10 pm)
 • Detroit at Minnesota(8:10 pm)
 • Milwaukee at St. Louis(8:15 pm)
 • Seattle at LA Angels(10:05 pm)
 • Texas at Oakland(10:05 pm)
 • Philadelphia at San Diego(10:10 pm)