Excel equivalent of Words 'Quick Parts' or Building Blocks

[GreenBoy]

Hi

In word I have an option to use something called quick parts which is a effectively a powerful version of the clip board in that I can store text and formatting as well as data that is relevant to the document (page numbers, authors etc.)

Is there something like this in Excel?

I know I can use UDF's for functions that I use regularly that are not built in - my example is I use =Date(right(A1,4),Mid(A1,4,2),Left(A1,2)) to convert Dates exported from a SAP database where the only variable is the Cell being converted...

I would also like to supplement this with some other 'building blocks' that I use regularly - such as reports that always have certain information in them (Title, Company info, Confidentiality, Copyright etc) which would be great to just insert including formatting.

I guess I can also do this with VBA but it seems a little excessive...

Any comments gratefully received.

 

[bobhc]

Good day GreenBoy

You could create your own theme, perhaps that would be of help to you

http://office.microsoft.com/en-gb/w...ument-theme-in-word-or-excel-HA001229924.aspx

 

[GreenBoy]

Hi Bob - that looks interesting in terms of setting fonts and formats to the worksheet - I shall take a closer look and see how useful this is to me.

Still looking for something that will allow me to add predefined 'boilerplate' sections which could include text and formulas etc...

Thanks again for the helpful advice. If I find anything I will share.

Dave

 

[NARAYANK991]

Hi Dave ,

If you enter the words :

Customize Excel

in Google , there are quite a few interesting links.

One way is to use templates , another is to use a Personal.xls or Personal.xlsb to store many of the routine macros that you might be using on a regular basis.

Narayan