200 Excel Shortcuts for PC and Mac

Learn Microsoft Excel Download PDF

Use scientific format

Working with large numbers? This shortcut changes the format within all selected cells to a scientific-based format. When used shortcut will edit all numbers within your selection to include a single digit followed by two decimal places and your exponential. (I.E. 2.20E+03)

Ctrl Shift ^

Control Shift ^

Get more Reference tips and tricks

Subscribe to our email updates and get Reference tips direct to your inbox.