A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Setting up and Configuration
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Formatting not staying on



 
 
Thread Tools Display Modes
  #1  
Old February 7th, 2008, 12:26 PM posted to microsoft.public.excel.setup
AnnP
external usenet poster
 
Posts: 5
Default Formatting not staying on

I have some cells with Autofit ON on the first sheet of my workbook. I want
the same formatting on the other 4 sheets, but even although I have
individually applied Autofit to the cells I want, it does not see this
formatting. The idea is for all the sheets to mimick the first sheet.

Any help would be appreciated.
  #2  
Old February 7th, 2008, 06:52 PM posted to microsoft.public.excel.setup
Gord Dibben
external usenet poster
 
Posts: 20,252
Default Formatting not staying on

Autofit is a sheet only setting.

Must be set on each sheet.

Quick way to do this select first sheet then right-click on a sheet tab and
"Select all Sheets"

CTRL + a to select all cells.

FormatRowAutofit.

Right-click on a sheet tab to "ungroup" the sheets.


Gord Dibben MS Excel MVP


On Thu, 7 Feb 2008 03:26:00 -0800, AnnP wrote:

I have some cells with Autofit ON on the first sheet of my workbook. I want
the same formatting on the other 4 sheets, but even although I have
individually applied Autofit to the cells I want, it does not see this
formatting. The idea is for all the sheets to mimick the first sheet.

Any help would be appreciated.


  #3  
Old February 13th, 2008, 12:21 PM posted to microsoft.public.excel.setup
AnnP
external usenet poster
 
Posts: 5
Default Formatting not staying on

Many thanks for your reply. I did as you suggest and applied Autofit to the
appropriate cells on the appropriate sheets and saved the template. When I
type on the first sheet, the Autofit works, but not on the other sheets. Any
further suggestions?


"Gord Dibben" wrote:

Autofit is a sheet only setting.

Must be set on each sheet.

Quick way to do this select first sheet then right-click on a sheet tab and
"Select all Sheets"

CTRL + a to select all cells.

FormatRowAutofit.

Right-click on a sheet tab to "ungroup" the sheets.


Gord Dibben MS Excel MVP


On Thu, 7 Feb 2008 03:26:00 -0800, AnnP wrote:

I have some cells with Autofit ON on the first sheet of my workbook. I want
the same formatting on the other 4 sheets, but even although I have
individually applied Autofit to the cells I want, it does not see this
formatting. The idea is for all the sheets to mimick the first sheet.

Any help would be appreciated.



  #4  
Old February 13th, 2008, 12:25 PM posted to microsoft.public.excel.setup
AnnP
external usenet poster
 
Posts: 5
Default Formatting not staying on

I should perhaps have said that the formatting is being applied to the second
of 6 sheets. I type on the 2nd one and the data is copied to sheets 3 - 6.
Thanks again.

"Gord Dibben" wrote:

Autofit is a sheet only setting.

Must be set on each sheet.

Quick way to do this select first sheet then right-click on a sheet tab and
"Select all Sheets"

CTRL + a to select all cells.

FormatRowAutofit.

Right-click on a sheet tab to "ungroup" the sheets.


Gord Dibben MS Excel MVP


On Thu, 7 Feb 2008 03:26:00 -0800, AnnP wrote:

I have some cells with Autofit ON on the first sheet of my workbook. I want
the same formatting on the other 4 sheets, but even although I have
individually applied Autofit to the cells I want, it does not see this
formatting. The idea is for all the sheets to mimick the first sheet.

Any help would be appreciated.



  #5  
Old February 13th, 2008, 06:58 PM posted to microsoft.public.excel.setup
Gord Dibben
external usenet poster
 
Posts: 20,252
Default Formatting not staying on

Maybe because I left out the part about also setting "Wrap Text" at the same
time.

If the sheets are still grouped, whatever you type on the activesheet will also
be entered in the other sheets.

BTW..........if any merged cells, these will not autofit.


Gord

On Wed, 13 Feb 2008 03:21:02 -0800, AnnP wrote:

Many thanks for your reply. I did as you suggest and applied Autofit to the
appropriate cells on the appropriate sheets and saved the template. When I
type on the first sheet, the Autofit works, but not on the other sheets. Any
further suggestions?


"Gord Dibben" wrote:

Autofit is a sheet only setting.

Must be set on each sheet.

Quick way to do this select first sheet then right-click on a sheet tab and
"Select all Sheets"

CTRL + a to select all cells.

FormatRowAutofit.

Right-click on a sheet tab to "ungroup" the sheets.


Gord Dibben MS Excel MVP


On Thu, 7 Feb 2008 03:26:00 -0800, AnnP wrote:

I have some cells with Autofit ON on the first sheet of my workbook. I want
the same formatting on the other 4 sheets, but even although I have
individually applied Autofit to the cells I want, it does not see this
formatting. The idea is for all the sheets to mimick the first sheet.

Any help would be appreciated.




  #6  
Old February 13th, 2008, 06:59 PM posted to microsoft.public.excel.setup
Gord Dibben
external usenet poster
 
Posts: 20,252
Default Formatting not staying on

That is normal behaviour for "grouped sheets".

Ungroup to prevent that.


Gord

On Wed, 13 Feb 2008 03:25:00 -0800, AnnP wrote:

I type on the 2nd one and the data is copied to sheets 3 - 6.


  #7  
Old February 15th, 2008, 12:41 PM posted to microsoft.public.excel.setup
AnnP
external usenet poster
 
Posts: 5
Default Formatting not staying on

Thanks, but I did have Wrap Text on, no merged cells and ungrouped the
sheets. I even tried using a macro to apply the Autofit to the appropriate
cells after the text is typed, but that did not work either. Funnily enough,
if I manually select the cells after entering the text and apply Autofit, it
does work! I really didn't want the users to have to manually apply Autofit,
so am looking for another way round this.

Sorry to be a pain, but this is very frustrating.

"Gord Dibben" wrote:

That is normal behaviour for "grouped sheets".

Ungroup to prevent that.


Gord

On Wed, 13 Feb 2008 03:25:00 -0800, AnnP wrote:

I type on the 2nd one and the data is copied to sheets 3 - 6.



  #8  
Old April 28th, 2008, 10:51 AM posted to microsoft.public.excel.setup
AnnP
external usenet poster
 
Posts: 5
Default Formatting not staying on

I have since found that this is a bug in Excel 2003. Thanks for replies.

"AnnP" wrote:

Thanks, but I did have Wrap Text on, no merged cells and ungrouped the
sheets. I even tried using a macro to apply the Autofit to the appropriate
cells after the text is typed, but that did not work either. Funnily enough,
if I manually select the cells after entering the text and apply Autofit, it
does work! I really didn't want the users to have to manually apply Autofit,
so am looking for another way round this.

Sorry to be a pain, but this is very frustrating.

"Gord Dibben" wrote:

That is normal behaviour for "grouped sheets".

Ungroup to prevent that.


Gord

On Wed, 13 Feb 2008 03:25:00 -0800, AnnP wrote:

I type on the 2nd one and the data is copied to sheets 3 - 6.



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


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


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