Applying OUTLINE Border to the Selected Range While the default border color is black, you can change the color Home –> Font –> Line Color. Use the following keyboard shortcut to apply the border to the selected data set: ALT + H + B + A (press the ALT key followed by H and B and A). This simple formatting transforms the data from raw data dump to something that looks more like a refined report. You’ll be surprised to see how better the data/report looks when you give it a border. Similarly, you can also use similar shortcuts such as Control I to italicize and Control-U to apply the underline format. Use the following keyboard shortcut: Control + B (hold the Control key and then press B). This formatting shortcut comes in handy when you have headers, and you want to highlight it by making the font bold. Read on to learn more about these Excel formatting shortcuts. 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.
#M s excel shortcut keys download
I often get a lot of data download from colleagues or files from databases that have no formatting to it look raw and ugly.
Applying OUTLINE Border to the Selected Range.Applying Bold Font Formatting to Headers.
0 kommentar(er)
