Select K2:K51
Type 100
Hit Ctrl-Enter rather than just Enter
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Stefi" wrote in message
...
Type in K2: =$M$2 and fill down until K51!
Regards,
Stefi
"laz" ezt írta:
whatever number I enter into cell M2 I would like for that number to
show down the whole column K.
Ex. in cell M2 I enter the number 100, I should then see 100 in column
K in the range of k2:k51.
How can I make this possible. Any help would surely be appreciated.
Thank you in advance. I know this may sound silly but its hurting my
brain. lol
Lazarus
in Ca.
--
laz
------------------------------------------------------------------------
laz's Profile:
http://www.excelforum.com/member.php...fo&userid=2526
View this thread:
http://www.excelforum.com/showthread...hreadid=483844