Take a look at the Transpose function.
It should give you the desired result.

Per Erik

On Wed, 23 Feb 2005 09:01:15 -0800, "Rynardt"
wrote:

I want to reference the values of row (all columns) 1 in sheet 1, in a
columns (horizontally) in sheet 2. The formula should look something like
this:

=SHEET1!A$1

This is a problem, cause the "A" in the formula stays constant, and needs to
change to B,C,D,E,F,etc.

How do I get it to change when filling the formula by dragging?