I changed the Command-M key from Minimize Window to Merge Cells. I click the shortcut key and either nothing happens or, if I replaced a keystroke, the previous command happens Ex. CTRL + Shift + #: Change date format with the day, month, and yearI see it in the Current Keys: menu box above, I click okay and it brings me to the Excel file again.PC Shorcut:Ctrl+Tab Mac Shorcut:+Tab Previous Tab This Excel Shortcut moves to the previous tab (worksheet). CTRL + K: Insert a hyperlinkNext Tab This Excel Shortcut moves to the next tab (worksheet). Some sections have additional sub sections based on different actions/tasks (navigating, writing formulas, formatting, etc.).This shortcut quickly gives you access to the default date format.
![]() ![]() 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. Borders are generally a good idea to use if you want to organize your worksheet and make it appear more professional.This really does pay dividends in the long run. 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. ![]() CTRL + F12 : Open another workbookForgot that the data you needed was in another workbook? Hit this shortcut and quickly open the open file dialog box. 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. 2 in the cell before formatting.Alternatively, insert a formula to calculate percentages and then format as needed. For example, if you want 20 percent, you will need to have. Download drag racing 4x4 mod unlimited moneySadly, 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 + 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. Useful for repeating cells or if you want a new cell with a slightly altered formula quickly. Download game mario kart 8 pcCTRL + 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. Alt + Q: Let Excel help you out when in a bindDo you ever find yourself stuck with no idea what to do in Excel? Utilize this shortcut to quickly land in the help search bar.Source: nofrills/Flickr 43. Shift + F3: Find PreviousIf something in your data is starting to look a little repetitive, you can use this shortcut to make sure you aren't just going crazy. Source: Jim Makos/Flickr 47. You can then delete the entire row or make whatever changes you think are necessary.Alternatively, you can click on the row number on the left of the screen. Shift + Spacebar : Select the entire rowIf you are working in a cell and realize you need to select the entire row that cell is in, hitting this Excel shortcut will automatically select the row. 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. Here are some of the most common ones that everyone should take advantage of.Pivot tables are some of the most powerful data organization tools in Excel.
0 Comments
Leave a Reply. |
AuthorPriscilla ArchivesCategories |