Posted on 22 May 2008
Tags: Excel, keyboard shortcuts, Microsoft Excel, Microsoft Office, Office, productivity
Using keyboard shortcuts is a much more efficient way of working than choosing options through the menu. Here are a few killer keyboard shortcuts for Microsoft Excel that can save you time.
| Action |
Shortcut |
| Apply the outline border to the selected cells |
Ctrl+Shift+& |
| Apply the Date format with the day, month, and year |
Ctrl+Shift+# |
| Apply the Time format with the hour and minute, and AM or PM |
Ctrl+Shift+@ |
| Enter the current time |
Ctrl+Shift+: |
| Enter the current date |
Ctrl+; |
| Hide the selected columns |
Ctrl+0 (zero) |
| Alternate between displaying cell values and displaying formulas in the worksheet |
Ctrl+’ |
| Display the Find and Replace dialog box, with the Replace tab selected |
Ctrl+H |
| Display the Print Preview window |
Ctrl+F2 |
| Switch to the next workbook window |
Ctrl+F6 |
| Display the Macro dialog box to create, run, edit, or delete a macro |
Alt+F8 |
If you're new here, you may want to subscribe to my RSS feed or get updates through email. Thanks for visiting!
Posted on 10 May 2008
Tags: Excel, Office, office 2007, ribbon, word
Never leave the key board
Using keyboard shortcuts to choose options is definitely faster than reaching out for the mouse everytime. Office 2007 makes it easy. Tap the Alt key while in any Office 2007 application and the ribbon is instantly covered in small letters indicating the keystrokes. Type the for the different ribbon tabs (H for Home, N for Insert etc) to access individual ribbon controls and more key shortcuts. Read the full story
Posted on 23 April 2008
Tags: Excel, google docs, Office, Protect Worksheet, Zoho Sheet
Ever come across an Excel file that you can open and view but if you wanted to edit it, you can’t, since it is has been protected? And when you try to unprotect, it asks for a password.
Here are a couple of ways to overcome the situation. While, you may not be able to make the original document editable without the password, you can create editable copies. Read the full story
