cant write a formula in some cells

  • Thread starter Thread starter Kevin
  • Start date Start date
K

Kevin

This is a two part question, first, I have a value that I want to copy all
the way from range B3:B6000, what I do is just write a formula in B4 as =B3
and then select B4 and drag the mouse with the autofill all the way to the
cell B6000! Is there a simpler, elegant way to copy the value of B3 form
B4:B6000?
Second question, when I write the formula in B4 or anywhere in the B:B range
the formula is not a formula???. I look to see if there is a macro that does
not allow to write a formula in that range but cant find any reference to
Column B in that Sheet. I check many thing and all I can think are, the page
or workbook are not protected, cant find any reference in Sheet 1 that
contains a macro on range B:B, I also tried to trace de formula but excel
said its not a formula, Does anybody has any Ideas!

Thanks in advance.

Kevin Brenner
 
In the name box type

B4:B6000 <cr>
this will select B4:B6000
go to the formula bar and type
=B3
then do Ctrl+Enter rather than just enter. This will enter the adjusted
formula in each cell (so every cell will reference the cell above it an they
will all hold the value of B3).

More than likely, you have some cells formatted as Text. Select Column B
and do format=>Cells, select number tab and select General.

The other possibility is that you are in formula view. If you can not put a
formula in any cell and have it act as a formula, the this might be
indicated. the view can be toggled with Ctrl+~ (ctrl + the upper left key
on the number row, no shift key).
 
Thanks! that worked. Some of the cell in the column where formatted as text
and was the reason.
And the Shortcut for writing the above cell worked great!

Thanks again

Kevin Brenner
 
Back
Top