ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Can you name a group of cells? (https://www.excelbanter.com/excel-discussion-misc-queries/257369-can-you-name-group-cells.html)

Amy

Can you name a group of cells?
 
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!

Bob I

Can you name a group of cells?
 
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!



dlw

Can you name a group of cells?
 
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!


Amy

Can you name a group of cells?
 
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!



All times are GMT +1. The time now is 10:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com