Formatting in Excel takes time

[Faakhir]

hello friends,

In Microsoft Excel, since it has to deal with cells, it takes lots of time to edit and format the document. Sometimes, I wonder to regenerate the whole document from start....Is there any way I can save the time formatting documents in Excel ?

please provide your ideas.....thank you

[JonathanD]

You can save time formatting in Excel with custom styles...

Say you need to format each cell containing a sum total with a single line top border and a double-line bottom border. Also, the total results must be in currency format.

To create a style that would automatically format these cells for you,
follow these steps-

1. Click on one of the total cells in your worksheet.
2. Go to Format | Style.
3. In the Style name box, type Total cell.
4. Click Modify.
5. Under the Number tab, select Currency.
6. Under the Border tab, select Single Line under Line styles and click the Top Border button on the menu to the left.
7. Select the Double Line under Line styles, then click the Bottom Border button.
8. Click OK twice.

[chroma]

If you want to format a total cell,

• select the cell
• go to Format | Style choose Total Cell from the drop-down list
• click OK.

This feature wouldn't save you much time if you had to do it for every workbook; fortunately, you can copy the style to any other workbook by following these steps:

• Open the workbook that contains the already defined style.
• Open the workbook to where you would like to copy the style.
• In the workbook where you want to copy the style, go to Format | Style.
• Click Merge.
• Select the other open workbook from the list and click OK.

If you want to have your named styles available to all worksheets, you can merge them to an Excel template file.