Save Custom Format

[amajor99]

Hi all,

I have an excel book with three tabs. The first tab I dump data in, and then the second pulls the data in =sheet1!c4 as such. Issue is, I need the second tab to format as "Auto fit row height"

I tried reformatting and saving but I cannot get the "auto fit row height" to remain in the file without having to keep going in and selecting it. Any thoughts on this?

using version 2013 for excel

Thanks!