Change All Formats on a Worksheet While Using Minimal Memory


If you want to change most of the number, date, or time formats on a worksheet, don’t change them cell by cell that takes memory in large worksheets and can reduce speed. Instead select the entire column by clicking on the column header (or press Ctrl+spacebar) or the entire row by clicking on the row header (or press Shift+Spacebar), then apply the format. To select the entire worksheet click the corner space at the top left where row and column headers intersect (or press Shift+Ctrl+spacebar) and apply the format.

Share the power...