I'm trying to fill a series of rows with numbers from a different worksheet - product of 2 numbers. One number is constant and is located (for example) in B3. The series of numbers is from A9 through Z9 (same row)

So I put (for example) the formula in A10 as "=B3*A9", I get the product of what I want for that cell. However, when I highlight from A10 through Z10 and fill right, it will give me on B10 as "=B4*B9", on C10 it will be "=C4*C9", so on. I can't make it stop and it's frustrating the crap out of me. Older Excel versions didn't do this (that I recall), this Office 2003 sucks

 

All versions of Excel does this. In fact, this has been the case since the early versions of Lotus 1-2-3.

Type in "=B$3*A9" in A10

(the $ means 3 is constant, you can do $B$3 too, if you want the row to be constant as well)

 

really? that's cool. jeez, you know what I would always do?

I would just copy the constant # down the whole row pretty lame huh?

 

I guess that feature isn't very well documented. I've known about it since I was using Lotus 1-2-3 r2.x, so I just assumed it was common knowledge.

Ever wondered what the "Scroll Lock" key does? To the best of my knowledge, it's only used in spreadsheet programs (and to cause Windows to crash and die, if certain registry entries are present). Try it!

 

looks like the Scroll Lock actually makes my cursor move about 10x faster when I'm highlighting a series of cells in a column?

I was hoping it would actually slow down the cursor and have it highlight the cells more slowly.

 

Are you selecting with a mouse? Scroll Lock modifies the behavior of the cursor keys. It causes the cursor keys to "scroll" the sheet rather than move the selected cell.

I.e., let say you've got Excel open, with A1 being the top left cell visible, and C6 the selected cell. You hit "down, down, right," if,
Scroll lock is off: D8 is selected now, A1 remains the top left cell visible.
Scroll lock is on: C6 remains selected, but B3 is now the top left cell.

I never use it, and I don't really see how it's useful. I just know about it 'cos I was bored once and RTFMed.

 

Interesting, apparently it affect "Home" and "End" too.

 

aaaaah. yep, you're right.

 

thank you very much!!

 

Also, when you're entering a formula and click on a cell with the mouse - cell B3, for example - you can scroll through the various combinations - B3, B$3, $B3, $B$3 - by using the F4 function key.