limits on labels?

P

pamela

What kind of cell limits are there? I know 1,024
characters per cell. But what about formulas? I cannot
do 55 non-contiguous cells when using the average function.

Also, when creating labels, I miss about 15 references
even though I have the cell selected when creating the
label - I have tried several times.

When I try editing the label, the entire contents are
erased and I have to start over instead of just adding a
few missing cells.
 
G

Gord Dibben

Pamela

There is a difference between "labels" and "defined names".

See Help on "labels"(no quotes) to see what's up with each.

Perhaps you should be using just named ranges and not labels.

Also note that in order to use labels you must have Tools>Options>Calculations
"Accept labels in formulas" checked.

To edit the "refers to" box you must place the mouse cursor in the box then
hit F2 to enter Edit mode.

Gord Dibben Excel MVP
 
G

Guest

hi,
as a work around you might create a few "sub totals" along
the way to stay under the 1024 limit. then in your Total
cell, add up the sub totals.
as for label, i am not sure what you mean?
could you define lable?
 
M

Myrna Larson

Since the cells aren't contiguous, I expect you are typing something like
=SUM(B22,K13,M86) etc. When you do that, you are limited to 30 references.

If you select these cells, then assign a name to the multiple selection, that
will reduce the number of arguments just 1.

As for editing the RefersTo box when defining a name, click on that box, then
press F2 to get into Edit mode.
 
D

Dave Peterson

See one more response at your other post.
What kind of cell limits are there? I know 1,024
characters per cell. But what about formulas? I cannot
do 55 non-contiguous cells when using the average function.

Also, when creating labels, I miss about 15 references
even though I have the cell selected when creating the
label - I have tried several times.

When I try editing the label, the entire contents are
erased and I have to start over instead of just adding a
few missing cells.
Click to expand...
 
G

Gord Dibben

And.......you are limited to 255 characters in the Insert>Name>Define "refers
to" box if that's where you are missing cell references.

Gord Dibben Excel MVP
 
Top