This is also incredibly powerful for mass-changing formulas and large amounts of data. If you misspelled a word or just want to replace something with a new something, the find and replace function is the best way to go about it. CTRL + F: Quickly access the mighty find functionįorgot where you put that crucial piece of data, use this shortcut to quickly find it. Useful for repeating cells or if you want a new cell with a slightly altered formula quickly. This command will make an exact copy of the formulas in the cell above it. CTRL + D: Copy equation down Source: Rocco/Flickr Hitting this will list your properties/methods/constants within a worksheet. Sadly, this one only works in Excel, not real life. CTRL + : Insert the current date in the active cellĬan't get a date? Hit this shortcut to get one quickly. If you quickly want to see what cells are referenced in another cell, use this Excel shortcut to see them. This shortcut is especially useful in Excel worksheets that have seemingly endless formulas. CTRL + [: Select all cells directly referenced by formulas in the selection Instead of using your mouse to click on the header, use this shortcut to automatically select the entire column that you are working in. CTRL + Spacebar : Select the entire column Source: Ben Hutchison/Flickr CTRL + F12 : Open another workbookįorgot that the data you needed was in another workbook? Hit this shortcut and quickly open the open file dialog box. 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.
#EXCEL MAC SHORTCUT KEY FOR HOME PLUS#
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