Maybe you could record a macro when you format it the way you like.

Then you could run that macro to get that look when you want.

tkaplan wrote:

I am trying to create a pivot table based off of data in Sheet2. I need to
look to be different than any of the autoformats. is there a way that i can
create my own autoformat, maybe in VBA, that i can use for other tables as
well?

--

Dave Peterson