CTRL + K: Insert a hyperlinkFirst, you need to select where you want a hyperlink to appear. Using 'Alt + Shift + Ctrl + F9' keys, all the dependent formulas are rechecked and recalculated in all the open workbooks.This still works in the Mac world if I enter it manually, but in the Windows version of Excel, there was a keyboard shortcut (highlight A1 in the formula.This shortcut quickly gives you access to the default date format. It recalculates all the formulas in your excel workbook.CTRL + Shift + &: Applies border to cellsInstead of navigating through endless menus, use this Excel shortcut to quickly add borders to the cells you have selected. Ctrl + Shift + U: Expand or collapse the formula bar Source: Isriya Paeireepairit/FlickrThis shortcut expands or collapses the formula bar, a useful tool when you're moving about a variety of workspaces and inspecting cells.Very handy indeed. It will apply to multiple cells as well, if you have them selected. CTRL + Shift + $: Applies the currency format to the selected cellsIf you quickly want to change a cell to the currency format, you can select it and hit this shortcut.
![]() View Formula Function Key For Excel Om Mac World IfCTRL + U: Underline textUse this to quickly underline or un-underline a cell or text. CTRL + I: Italicize/un-italicize textUse this to quickly italicize or un-italicize a cell or text. CTRL + B: Bold/unbold textUse this to quickly bold or unbold a cell or text. Plus it makes you feel nice and fuzzy on the inside. ![]() CTRL + Shift + ! : Number styleUsing this will give you access to a cells number style. This useful for all us engineers out there.This shortcut will give you quick access to the time of day style and allow you to add it into a cell. CTRL + Shift + ^ : Scientific notation styleWorking with a big number? Use this shortcut to quickly convert to scientific notation. Easiest cad software for macCTRL + D: Copy equation down Source: Rocco/FlickrThis command will make an exact copy of the formulas in the cell above it. Sadly, this one only works in Excel, not real life.Hitting this will list your properties/methods/constants within a worksheet. CTRL + : Insert the current date in the active cellCan'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. CTRL + [: Select all cells directly referenced by formulas in the selectionThis shortcut is especially useful in Excel worksheets that have seemingly endless formulas. CTRL + Spacebar : Select the entire column Source: Ben Hutchison/FlickrInstead of using your mouse to click on the header, use this shortcut to automatically select the entire column that you are working in.This is really, really, useful. CTRL + Left arrow: Move leftThis does the same thing as the page right above, except it pages left. CTRL + Right arrow : Move rightEssentially, this pages right in your Excel worksheet. This is also incredibly powerful for mass-changing formulas and large amounts of data. CTRL + H: Find and replaceIf 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 functionForgot where you put that crucial piece of data, use this shortcut to quickly find it. CTRL + Enter: Stay in your active cellThis handy shortcut lets you remain in the active cell after editing it, instead of moving to the next one down. CTRL + Down arrow: Move downUse this function to page down in a worksheet, obviously. CTRL + Up arrow: Move upUse this function to page up in a worksheet. ![]() But the principles behind operations stay the same. If you use them a lot or just want to become a pivot table guru, take a look at the pivot table shortcuts below.Open the context menu for the selected cell, column, or row.And that, Excel enthusiasts, is your lot for today.Using some of these shortcuts can seem tedious at first, but as soon as you get the motions down, it can speed up your work pace by a lot! All of these shortcuts should work on Windows machines, but Mac keystrokes will likely be different.Some will be similar while others simply may not exist.
0 Comments
Leave a Reply. |
AuthorVeronica ArchivesCategories |