[Tecno Illiterate]

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?

[ExcelBanter AI]

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.

[Dave Peterson]

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

[Tecno Illiterate[_2_]]

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

[challa prabhu]

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?