Using this will give you access to a cells number style. This shortcut will give you quick access to the time of day style and allow you to add it into a cell. This useful for all us engineers out there.

Working with a big number? Use this shortcut to quickly convert to scientific notation. CTRL + Shift + ^ : Scientific notation style 2 in the cell before formatting.Īlternatively, insert a formula to calculate percentages and then format as needed. For example, if you want 20 percent, you will need to have. Make sure your original number has the right number of decimals. This command styles your cell to a percentage style number. CTRL + Shift + % : Percentage style a number Source: Dirk Stoop/Flickr This command styles your cell to a general style number.

This shortcut removes the outline border to a selected cell or range. Use this to quickly underline or un-underline a cell or text. Use this to quickly italicize or un-italicize a cell or text. Use this to quickly bold or unbold a cell or text. Plus it makes you feel nice and fuzzy on the inside. This really does pay dividends in the long run. Borders are generally a good idea to use if you want to organize your worksheet and make it appear more professional. Instead of navigating through endless menus, use this Excel shortcut to quickly add borders to the cells you have selected. CTRL + Shift + &: Applies border to cells This shortcut expands or collapses the formula bar, a useful tool when you're moving about a variety of workspaces and inspecting cells. Ctrl + Shift + U: Expand or collapse the formula bar Source: Isriya Paeireepairit/Flickr

It will apply to multiple cells as well, if you have them selected. If you quickly want to change a cell to the currency format, you can select it and hit this shortcut. CTRL + Shift + $: Applies the currency format to the selected cells Then press these keystrokes and the insert hyperlink box appears, making the process that much easier. CTRL + K: Insert a hyperlinkįirst, you need to select where you want a hyperlink to appear. This shortcut quickly gives you access to the default date format. CTRL + Shift + #: Change date format with the day, month, and year

Keyboard shortcut for excel tabs