Prev: Dual Y Axis in Line Plots
Next: Looping Macros that change
From: Amy on 25 Feb 2010 11:42
This may be a stupid question, but I have lots of data to display in the
first row of cells, and I'd like to be able to condense it a little bit so
it's easier to read. Grouping is the best option I've come up with so far,
but I need to be able to name the groups because there will be several.

Thanks!
From: Bob I on 25 Feb 2010 11:45
You may name a "Range" which is cell or a block of cells

Amy wrote:

> This may be a stupid question, but I have lots of data to display in the
> first row of cells, and I'd like to be able to condense it a little bit so
> it's easier to read. Grouping is the best option I've come up with so far,
> but I need to be able to name the groups because there will be several.
>
> Thanks!

From: dlw on 25 Feb 2010 11:50
highlight the cells then Insert / Name / Define

"Amy" wrote:

> This may be a stupid question, but I have lots of data to display in the
> first row of cells, and I'd like to be able to condense it a little bit so
> it's easier to read. Grouping is the best option I've come up with so far,
> but I need to be able to name the groups because there will be several.
>
> Thanks!
From: Amy on 25 Feb 2010 16:19
I guess my problem is that I want the name displayed? If I name the cells
that way, I can't see it in the table. Is there a way that I can see it?

"dlw" wrote:

> highlight the cells then Insert / Name / Define
>
> "Amy" wrote:
>
> > This may be a stupid question, but I have lots of data to display in the
> > first row of cells, and I'd like to be able to condense it a little bit so
> > it's easier to read. Grouping is the best option I've come up with so far,
> > but I need to be able to name the groups because there will be several.
> >
> > Thanks!
 | 
Pages: 1
Prev: Dual Y Axis in Line Plots
Next: Looping Macros that change