Simpler and faster is always better in Excel.
We start with some of my favorite shortcuts, then move on to using Excel for everyday situations such as finding random numbers for passwords, or random numbers within a range, or discovering how much your monthly payments will be for a car or home loan.
1. Shortcut: Select the entire spreadsheetEveryone knows that Ctrl+A selects the entire spreadsheet, document, email, etc. In Excel; however, there’s an even faster way: Click the small green arrow in the square space between the row numbers and column letters.
2. Shortcut: Number formatsWhich is faster—the mouse or the keyboard? Those who use both work faster than either one or the other alone. Try these shortcuts: After you enter a number or column of numbers, highlight the target cells and press…Ctrl+Shift+! (exclamation point) to display the Number format with two decimal points,Ctrl+Shift+$ (dollar sign) to format the selected cells as currency,Ctrl+Shift+% (percent sign) to format as percentages,Ctrl+Shift+~ (tilde) for the General format,Ctrl+Shift+# (pound sign) for the Date format….
Continue Reading at Source: Excel tips: 6 slick shortcuts, handy functions and random-number generators | PCWorld