- #EXCEL SHORTCUT KEYS PDF 2007 HOW TO#
- #EXCEL SHORTCUT KEYS PDF 2007 SERIES#
- #EXCEL SHORTCUT KEYS PDF 2007 DOWNLOAD#
And if you’ve used a previous version of Excel, look for the “Nostalgia Corner” boxes, which tell how things have changed. You’ll learn all the best tricks throughout this book. Excel 2007 is chock-full of refinements, tweaks, and tune-ups that make it easier to use than any previous version.
Of course, this list is by no means complete.
#EXCEL SHORTCUT KEYS PDF 2007 DOWNLOAD#
Due to legal headaches, this feature didn’t quite make it into the Excel 2007 installation, but it’s available as a free download from Microsoft.
A PDF file is Adobe’s popular electronic document format that lets you share your work with other people, without losing any of your formatting (and without letting them change any of your numbers). In Excel 2007, lists morph into tables and get even more powerful. When Microsoft created Excel 2003, they added a wildly popular list feature that helped people manage lists of information. It prompts you with possible values when you type in complex formulas. The latest in a whole bunch of auto-do-something features, formula AutoComplete just might be the most helpful innovation yet. Excel 2007 shakes things up with a whole new graphics engine that lets you add fantastic looking charts to your spreadsheets.įormula AutoComplete. Keyboard shortcuts in Excel are commonly.
Excel charts have always been intelligent, but they’ve never made good eye candy. Mostly we prefer to use the shortcuts as its kind of amazing how much time we can save by not using the mouse clicks. Excel 2007 knows all about dual core CPUs, which means intense calculations are even faster on these computers.īetter-looking charts.
#EXCEL SHORTCUT KEYS PDF 2007 HOW TO#
(The CPU is the brain of any computer.) A dual core CPU can perform two tasks at once, but it performs best with software that knows how to take advantage of the way it works. One of the newest pieces of computing hardware is a dual core CPU. Although 99.87 percent of Excel fans never ran into any of these limits in previous versions, it’s nice to know that the Excel engine continues to get more powerful.įaster speeds. Excel worksheets can now be bigger, formulas can be more complex, and cells can hold way more text. All Excel gives you is the tooltip.įewer limits. And if you need to see the menu to remember what key to press next, you’re out of luck. It doesn’t work if you’re trying to use one of the few commands that doesn’t exist any longer. Of course, this feature can’t help you out all the time. It’s almost as though Excel has an invisible menu at work behind the scenes. If you go on to press S, you wind up at the familiar Paste Special dialog box, because Excel knows what you’re trying to do. When you hit Alt+E in Excel 2007, you see a tooltip appear over the top of the ribbon ( Figure I-6) that lets you know you’ve started to enter an Excel 2003 menu shortcut. The result is that you can still use your menu shortcuts, but they work in a slightly different way.
#EXCEL SHORTCUT KEYS PDF 2007 SERIES#
After all, Excel 2007 doesn’t even have a corresponding series of menus! Fortunately, Microsoft went to a little extra trouble to make life easier for longtime Excel aficionados. You can then press the S key to choose the Paste Special command.Īt first glance, it doesn’t look like these keyboard shortcuts will amount to much in Excel 2007. For example, if you press Alt+E in Excel 2003, the Edit menu pops open. If you’ve worked with a previous version of Excel, you might have trained yourself to use menu shortcuts-key combinations that open a menu and pick out the command you want. Microsoft Excel 2007 Keyboard Shortcuts ARROW KEYS Move one cell up, down, left, or right in a worksheet.NOSTALGIA CORNERExcel 2003 Menu Shortcuts CTRL+Shift+!Applies the Number format with two decimal places, thousands separator, and minus sign (-) fornegative values. the Time format with the hour and minute, and AM or PM. CTRL+Shift+#Applies the Date format with the day, month, and year. CTRL+Shift+^Applies the Exponential number format with two decimal places. CTRL+Shift+%Applies the Percentage format with no decimal places. CTRL+Shift+$Applies the Currency format with two decimal places (negative numbers in parentheses).
CTRL Shift ~Applies the General number format in Microsoft Excel. CTRL+Shift_Removes the outline border from the selected cells. CTRL+Shift+&Applies the outline border to the selected cells. CTRL+Shift+)Unhides any hidden columns within the selection. Microsoft Excel 2007 Keyboard ShortcutsCTRL combination shortcut keysCTRL+Shift+(Unhides any hidden rows within the selection. Example: bankruptcy Search Microsoft Excel 2007 Keyboard Shortcuts
0 kommentar(er)
