Hello,
Templates in xl2010 are quite a good thing.
However, as a consequence, I am now slowly forgetting my own conventions from the past.
Before xl2010, I used only very different styles for everything.
Essentially: few grey gridlines, texts in blues, numerical data in green, calculated data in red. For the tables, pivot tables, pivot chart, I just used these conventions and let xl re-use the palette.
I would like to avoid changing my styles every week till the end of this year.
I would like to make a definitve choice and concentrate on the business.
Therefore, I would be interrested to see some workbook with standard and consistent styles for eveything: texts, numbers, calculated values, tables, pivot tables, pivot chart, charts, hyperlinks, titles, subtitles, regular text, ...
I would like to chose the general workbook style that fits best my preferences, and keep these styles till I am retired!
Would you have developped such workbooks?
Would you know where I could find such a thing?
In my compagny, thise kind of standard layout is widespread for PowerPoint presentations as well as for some word documents.
There is nothing similar available for excel.
The templates available within excel2010 do not suit me very well as they are task-specific.
I would prefer a general style for everything.
My wish regarding excel is much simpler: I just want to chose one style for all type of object that I am using (see above) and stick to them in all situations: would it be a mass and heat balance, a chart of accounts or a schedule for example.
My ultimate goal would be to create a macro to set these styles automatically in any of my workbooks. This means, for example that any pivot table detected in a workbook would be formatted according to my standard.
Any suggestion or comment?
How do you standardize your own styles?
Thanks,
Michel
Templates in xl2010 are quite a good thing.
However, as a consequence, I am now slowly forgetting my own conventions from the past.
Before xl2010, I used only very different styles for everything.
Essentially: few grey gridlines, texts in blues, numerical data in green, calculated data in red. For the tables, pivot tables, pivot chart, I just used these conventions and let xl re-use the palette.
I would like to avoid changing my styles every week till the end of this year.
I would like to make a definitve choice and concentrate on the business.
Therefore, I would be interrested to see some workbook with standard and consistent styles for eveything: texts, numbers, calculated values, tables, pivot tables, pivot chart, charts, hyperlinks, titles, subtitles, regular text, ...
I would like to chose the general workbook style that fits best my preferences, and keep these styles till I am retired!
Would you have developped such workbooks?
Would you know where I could find such a thing?
In my compagny, thise kind of standard layout is widespread for PowerPoint presentations as well as for some word documents.
There is nothing similar available for excel.
The templates available within excel2010 do not suit me very well as they are task-specific.
I would prefer a general style for everything.
My wish regarding excel is much simpler: I just want to chose one style for all type of object that I am using (see above) and stick to them in all situations: would it be a mass and heat balance, a chart of accounts or a schedule for example.
My ultimate goal would be to create a macro to set these styles automatically in any of my workbooks. This means, for example that any pivot table detected in a workbook would be formatted according to my standard.
Any suggestion or comment?
How do you standardize your own styles?
Thanks,
Michel
Last edited:
