Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
cottage6
 
Posts: n/a
Default

Hi Leon,
When sheets are grouped whatever text/values are typed into one sheet also
show in all the other sheets in the group. This also includes all the
formatting applied such as column widths, fonts, etc., so it's pretty handy.
[Group] shows in the title bar whenever any or all sheets are in group mode.
To undo group, right-click on any sheet label, and choose "Ungroup sheets".
It's pretty easy to put sheets in group mode by mistake just by clicking once
on the first sheet name, holding your shift key, then clicking the last sheet
name.

HTH
"Leon Brown" wrote:

Hello,

I have a spreadsheet which has [Group] in the title bar. I can't create
charts, can't run other tools. I can't figure out how it got there, nor how
to get rid of it. I have resaved, but still can't figure it out.

Any hints appreciated.

--LEon

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
My Y-axis label is cut off in Excel charts tex_brazil Charts and Charting in Excel 1 May 26th 05 12:25 PM
can you make a title page using Excel? Really new to Excel Excel Worksheet Functions 1 April 7th 05 11:51 PM
How to leave the title row in MS Excel fixed? morisn Excel Worksheet Functions 3 February 19th 05 09:42 PM
My Excel Title bar does not indicate what file is open bobs walk Excel Discussion (Misc queries) 2 November 28th 04 04:09 PM
The x-axis title is truncated in EXCEL charts 2003. Bernard Liengme Charts and Charting in Excel 0 November 26th 04 05:25 PM


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

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"