shortcut keys¶

format¶

• Ctrl + B Apply or remove bold format

• Ctrl + I Apply or remove italic format

• Ctrl + U Apply or remove underline format

• Ctrl + 5 Apply or remove strike format

• Ctrl + 1 Open the Format Cells dialog box

format values¶

• Ctrl + Shift + ~ Apply general format

• Ctrl + Shift + ! Apply number format

• Ctrl + Shift + @ Apply time format

• Ctrl + Shift + # Apply date format

• Ctrl + Shift + $ Apply currency format

• Ctrl + Shift + % Apply percent format

• Ctrl + Shift + ^ Apply scientific format

format table¶

• Ctrl + Shift + L table row

• Alt + H, O, A auto fit rows

• Alt + H, O, I auto fit cols

create chart¶

select data and then

• Alt + F1