16
Tools of the Trade / Re: Excel tips
« on: Jan 20, 2012, 01:14 pm »
This might not be news to anyone, but I jumped up and down with joy when I discovered it: If you need to change the width or height of all your cells to one uniform size, select all of them using the arrow in the upper-left corner and drag the width/height of the first cell to the size you want. All cells will adjust to that size. Or if you want all columns to adjust to fit their widest cells, select all and double-click on the break between the first and second column headers.
If memory serves, "Repeat row/column" was located in File>Page Layout>Sheet on older Excel.
If memory serves, "Repeat row/column" was located in File>Page Layout>Sheet on older Excel.