Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Amy Amy is offline
external usenet poster
 
Posts: 165
Default 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!
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,819
Default 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!


  #3   Report Post  
Posted to microsoft.public.excel.misc
dlw dlw is offline
external usenet poster
 
Posts: 510
Default 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!

  #4   Report Post  
Posted to microsoft.public.excel.misc
Amy Amy is offline
external usenet poster
 
Posts: 165
Default 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!

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Match a group of cells with another group of cells Rod in Oz Excel Worksheet Functions 1 October 9th 08 01:45 AM
Copy Data from One Group of Cells to Another Group Alan Auerbach Charts and Charting in Excel 2 May 27th 07 04:12 PM
from a group of cells.find average of cells containing values farm Excel Discussion (Misc queries) 1 December 21st 06 08:50 PM
How do I name a group of cells? barronka Excel Discussion (Misc queries) 2 March 9th 06 03:50 PM
copy group of cells to another group of cells using "IF" in third Chuckak Excel Worksheet Functions 2 November 10th 04 06:04 PM


All times are GMT +1. The time now is 10:27 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"