Simpler and faster is always better in Excel.

Source: Excel tips: 6 slick shortcuts, handy functions and random-number generators | PCWorld

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

Software Tip of the Day

Don't Be an OLD DOG | Learn something new today!

You have Successfully Subscribed!