» Create styles directly from cells in Microsoft Excel

CATEGORY - Excel Format VERSION - All Microsoft Excel Versions

Add the Style icon to the Formatting toolbar.

Select a toolbar.
Right-click, and in the shortcut menu select Customize.
Select the Commands tab. In the Categories box, select Format.
From the Commands box, select Style. Drag the command to the Formatting toolbar, and drop it near the Font icon.

Create styles directly from cells
After you format a cell, you can quickly and easily save that format as a style by entering the name of the style in the Style box and then pressing Enter.

Note
After you have added the Style icon to the toolbar, using the Alt+' shortcut lets you select the Style in the icon itself. It does not open the Style dialog box.

Screenshot // Create styles directly from cells in Microsoft Excel

Book Store:

VIEW ALL BOOKS

Recommended Books:

Email Tip

Print Tip

Add to My Tips

Rate This Tip



1	2	3	4	5

Rating: 2.98 Views: 32290

How do I save Styles after adding

Dave Posted on: 31-12-1969

the styles that i add to the styles box do not save. when i open a new workbook they are not there - how do i make them permanent?

Found the answer to my Question and came up with a solution

Dave Posted on: 31-12-1969

After reading the rest of the tips I found where it tells you how to merge styels from another workbook.

What I've done is create a workbook named "Styles" and have created all the styels I want to use. Now it is simply a matter of opening that workbook and mergeing it into the one I'm working on to make the styles available in the new workbook.

Reply: Found the answer to my Question and came up with a solution - Dave from Aptos, CA wrote on March 21, 2003 4:46 PM EST

Alan Posted on: 31-12-1969

Hi Dave,

Good idea. I am going to do the same thing, except that I wil use my personal.xls file.

If you don't already use one of those, you might want to read up to see if that will enhance your idea.

Thanks for the tip,

Alan.