CONTROL + 1: Opens Format Cells dialog box.ALT + H + O + W: Autofits column widths.ALT + H + B + T: Gives an outline border to the dataset.ALT + H + B + A: Applies borders to the cells.CONTROL + B: Applies bold font formatting to headers.Here are my top five Excel formatting shortcuts: My immediate next step is to apply some basic formatting so that it can further be used. I often get a lot of data download from colleagues or files from databases that have no formatting to it look raw and ugly.
