- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel.misc
- 2003 October
- Re: cant write a formula in some cells

Subject: | Re: cant write a formula in some cells |

Posted by: | Tom Ogilvy (twogil…@msn.com) |

Date: | Sun, 26 Oct 2003 |

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).

--

Regards,

Tom Ogilvy

Kevin <kevin.brenn…@worldnet.att.com.RemoveMe!> wrote in message

news:vz0nb.16176$Ec1.14601…@bgtnsc05-news.ops.worldnet.att.net...

> 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

- Re: cant write a formula in some cells posted by Kevin on Mon, 27 Oct 2003

cant write a formula in some cells posted by Kevin on Mon, 27 Oct 2003