Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default What does [Group] mean after my document name at top of page?

The top of my screen says the name of the doc, then [Group]. It won't allow
me to insert symbols into my spreadsheet. I've tried to re-save it as
different names, etc. but they all still come up with this [Group] thing. Any
ideas?
  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up Answer: What does [Group] mean after my document name at top of page?

Hi there!

The Group text that you see after the name of your document at the top of the page indicates that the workbook contains grouped sheets. Grouping sheets in Excel allows you to perform the same action on multiple sheets at once, such as formatting or entering data.

Regarding your issue with inserting symbols into your spreadsheet, it's possible that the sheets in your workbook are protected or that certain cells are locked.

To check if your sheets are protected,
  1. go to the Review tab in the Excel ribbon
  2. click on the "Unprotect Sheet" button.
If the button is grayed out, then your sheet is not protected.

If your sheet is protected, you will need to enter the password to unprotect it. If you don't know the password, you can try to contact the person who protected the sheet or try to use a password recovery tool.

If your sheet is not protected, then it's possible that the cells where you are trying to insert symbols are locked. To check if a cell is locked,
  1. select the cell
  2. go to the Home tab in the Excel ribbon
  3. click on the "Format Cells" button
  4. go to the "Protection" tab.
If the "Locked" checkbox is checked, then the cell is locked.

To unlock the cell, uncheck the "Locked" checkbox and click OK. If the cells are part of a protected sheet, you will need to unprotect the sheet first before you can unlock the cells.
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default What does [Group] mean after my document name at top of page?

You have multiple sheets selected.

rightclick on any of the selected sheets and choose Ungroup Sheets.

You may want check your last few entries. Almost anything done to a member of
that group is done to all the members of the group.

Nice for changing headers -- not so nice for changing other stuff.

Tecno Illiterate wrote:

The top of my screen says the name of the doc, then [Group]. It won't allow
me to insert symbols into my spreadsheet. I've tried to re-save it as
different names, etc. but they all still come up with this [Group] thing. Any
ideas?


--

Dave Peterson
  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default What does [Group] mean after my document name at top of page?

Thanks so much!

"Dave Peterson" wrote:

You have multiple sheets selected.

rightclick on any of the selected sheets and choose Ungroup Sheets.

You may want check your last few entries. Almost anything done to a member of
that group is done to all the members of the group.

Nice for changing headers -- not so nice for changing other stuff.

Tecno Illiterate wrote:

The top of my screen says the name of the doc, then [Group]. It won't allow
me to insert symbols into my spreadsheet. I've tried to re-save it as
different names, etc. but they all still come up with this [Group] thing. Any
ideas?


--

Dave Peterson

  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 663
Default What does [Group] mean after my document name at top of page?

Hi,

This means that you Worksheet are grouped.

To group worksheets:

Press the Shift key and click the last sheet tab. All the worksheet in the
workbook will be grouped or you can press the Ctrl key and only those
workseeht in the workbook you want to group. When you group the worksheet the
Excel workbook will display as filename.xls [Group]

To ungroup your worksheets

right-click on the worksheet that is part of the grouped worksheet and
select Ungrouped sheets. When you ungroup the worksheet the Excel workbook
will display only the filename.xls.

Challa Prabhu


"Tecno Illiterate" wrote:

The top of my screen says the name of the doc, then [Group]. It won't allow
me to insert symbols into my spreadsheet. I've tried to re-save it as
different names, etc. but they all still come up with this [Group] thing. Any
ideas?

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
Repeat group names on each page Erin Searfoss Excel Discussion (Misc queries) 0 June 14th 07 11:23 PM
Eliminating the page number from first page of document ExcelUser Excel Discussion (Misc queries) 1 March 9th 07 04:37 PM
In the name of document, what does [Group] mean? shfintz Excel Discussion (Misc queries) 3 August 9th 06 11:56 PM
How do I delete page 2 of a 2-page document? Katie New Users to Excel 3 June 14th 06 04:55 PM
How can I rid off a group excel document? Marisol Excel Discussion (Misc queries) 1 March 8th 05 02:12 PM


All times are GMT +1. The time now is 01:58 AM.

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

About Us

"It's about Microsoft Excel"