Macro to format cells, adjust column widths, hide cells

Hi,

I am new here and have a question about a macro. I am using Excel 2010. Data is sent to me in an excel document and I would like to be able to reformat it so it can be easlily viewed and printed. I think a macro can be created to do this, but I have very little experience in this area. All the data is on one worksheet. This is what I would like to do:

Adjust column widths of A, H-K, M-S to 13.
Change text in cell A1 to "A", H1 to "H", and so on.
Bold text in cells A1, H1, K1, etc.
Underline text in cells, A1, H1, K1, etc.

Hide columns B-G, L, T-AH.

I can do all this manually, but I would like to be able to do something that would automate the process thus saving time and effort.

Any help provided would be most appreciated.

Thanks!!

Hello amsolmyers,

Welcome to the Forum!

This macro will format the specified columns to a width of 13, and add the column letter to the first row in bold,underlined and centered.

Please Login or Register  to view this content.

Hi Amsolmyers, welcome to the forum.

You can usually automate activities by using the macro recorder, especially if you're always referencing the same ranges/cells. The code created using the recorder is not always efficient, but it works. Below is some code that does what you're asking, not created using the recorder.

Please Login or Register  to view this content.

Hope that helps!