Cell Styles

[Paraomaris]

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) I am aware that 2008 does not have the preset cell styles and I know how to add them. I have 2 questions about this though:
Is there a way that after a style has been added it permanently stays in my system, so that I can use it whenever I open new worksheets and not have to add them over and over.
Is there anywhere aside from using a pc's excel where I can get the attributes so that I can add these styles.

 

[Jim Gordon Mac MVP]

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) I am aware
that 2008 does not have the preset cell styles and I know how to add
them. I have 2 questions about this though:
Is there a way that after a style has been added it permanently stays in
my system, so that I can use it whenever I open new worksheets and not
have to add them over and over.
Is there anywhere aside from using a pc's excel where I can get the
attributes so that I can add these styles.

Hi

You are referring to text styles, which is a new feature introduced in
Excel 2007 for Windows, but did not make it into Excel 2008 for Mac.

Perhaps this feature will make it into the next release of Office for
Mac, but for the time being the answer is no, you can't use text styles
in Mac Excel.

-Jim

 

[CyberTaz]

If you're referring to Excel 2007 the term 'Style' is used in a variety of
different contexts. From your brief message it's difficult to tell exactly
what type of style you mean, but if the attributes of cell formatting as
offered in the Format> Cells dialog is what you're after then yes, you can
create custom Styles to include whatever attributes you want. You can create
a Style in either of two ways;

Style by Example:

Select a cell & format it as you wish using the Formatting Toolbar, the
Formatting Palette and/or the Format> Cells dialog. Then go to Format>
Style, type the name of your new style, then click OK. Your style will be
added to the list of styles so you can then select any additional cells, go
back to Format> Style & select the one you want to apply.

Style by Definition:

Select any cell you want to reformat then go to Format> Style, type the
style name as above, then click the Modify button. Once you've selected the
formatting attributes to be included OK out of both dialogs. The cell will
be formatted according to your new style & you can apply it to any other
cells by way of the Format> Style dialog.

NOTE: Styles are specific to the workbook in which you create them. If you
want to add the Styles to a different workbook open the one containing your
Style, bring the other workbook to the front & go to Format> Style, click
the Merge button & proceed from there.

HTH |:>)
Bob Jones
[MVP] Office:Mac

 

[Paraomaris]

What i am referring too is text styles. In 2007 they had preset text styles like the total, heading, and whatnot, in 2008 they are not available. You have to create the style yourself. But for those of us that are studying this our teachers request us to change our styles according to 2007 standards and attributes so I am looking to find a document of some kind that might have at list the attributes of each style listed so I can succesfully add that style to my excel and I need to know if after creating that style there is a way to use it repeatedly without having to recreate it every time

 

[CyberTaz]

Well, I don't mean to be contrary, but Excel for Windows & Excel for Mac are
not & never have been identical. As Jim replied, there is an exceptionally
radical disparity between Office 2007 apps and *any* of their predecessors
for Mac or PC. I'm afraid the feature you're referring to is in that realm.

If the class you're taking is specifically on the use of Office 2007 *or* if
it was stipulated by the school/class that Office 2007 must be used, then
you have no choice but to comply with those requirements. If you do
specifically have to use 2007 you have the option of buying CrossOver plus
Office 2007 for your Mac without having to invest in Windows OS as well.
Alternatives to CrossOver include Apple's Boot Camp, Parallels Desktop &
VMWare Fusion, but each of them also require that you invest in Windows XP,
Vista or Windows 7.

OTOH, if this is more of a "general" course on using spreadsheets it might
be a good idea to have a conversation with the instructor about how to
attain some sort of compromise.

Good Luck |:>)
Bob Jones
[MVP] Office:Mac