Additional+Excel+Shortcut+and+function+keys

In addition to the other pages showing shortcut and function keys, there are so many more keys that are not listed and rarely use by other people. Since there are too many to list, I am listing the ones I normally use while creating and processing spreadsheets. CTRL+SHIFT+$ Applies the currency format w/two decimal places and also negative numbers. CTRL+SHIFT+% Applies the percentage format with no decimal places CTRL+SHIFT+: Enters the current time CTRL+SHIFT+; Enters the current date CTRL+SHIFT+& Applies the outline border to the selected cells CTRL+SHIFT+_ Removes the outline border from the selected cells Everyone is familiar with Function Keys F1 thru F12 Add CTRL in front of the Function key and it gives you a new function the same by added ALT in front of the Function key CTRL+F1 Displays or hides the Ribbon ALT+F1 Creates a chart of the data in the current range ALT+SHIFT+F1 Inserts a new worksheet CTRL+F2 Displays the Print Preview SHIFT+F2 Adds or edits a cell comment CTRL+F4 Closes the selected workbook window SHIFT+F6 Switches between the worksheet, Zoom Controls, Task Pane, and Ribbon I could keep going on and on with many other shortcuts and function keys. I just want to add some additional ones to the other reference pages. Another great shortcut function is to right click on the text and a mini toolbar shows up with many different quick formats. Microsoft Office 2007 has many great tools to make the application a lot easier than the older versions.