I don't know about you, but I get impatient and bored very easily. I find tedious work to be, well, tedious. Scrolling is one of those tedious tasks I find annoying sometimes. I mean really, it takes so much energy to move your hand from the keyboard to the mouse and back again every time you need to scroll. And let's face it, most of us don't have time to sit and wait for the little selection box in Excel© to scroll all the way to the bottom of that 5000 piece list! There has to be a more time and energy saving way!
Well, there is. Even though the above situation has been a bit over-exaggerated, there are times when messing around with huge Excel© documents gets time-consuming. Luckily, Microsoft™ has already programmed many shortcuts into their software. Many of these shortcuts also work for OpenOffice© but I cannot say for sure.
If you look online, you can find many full lists of all the shortcuts your heart could ever begin to desire. I found one such list and use it every time I'm editing an Excel© document. Here I have taken this list and expanded on it to hopefully make it easier to read and understand, for it can be a little tech-savvy sometimes. This list contains only those things I think practical to use. There are over two hundred shortcuts on the list, so if you really wish to use them, the link to the full list is at the bottom of this post:
f1 - Help
ctrl+p - Print
ctrl+f2 - Print Preview
ctrl+s - Save
f12 - Save as
ctrl+- - Delete
ctrl+f - Find
ctrl+h - Find and Replace
ctrl+alt+v - Display the Paste Special dialog box. Useful when making formulas into values
ctrl+v - Paste
ctrl+x - Cut the selected cells.
ctrl+z - Undo
ctrl+y - Redo
ctrl+c - Copy selected cells
ctrl+b - Apply or remove bold formatting.
ctrl+i - Apply or remove italic formatting.
ctrl+u - Apply or remove underlining.
ctrl+shift+: - Enter the current time.
ctrl+; - Enter the current date.
ctrl+shift++ - Insert
ctrl + arrow keys - Move to the edge of the current data region AKA if the cell is blank, it goes to the next non-blank cell; if it's non-blank, it goes to the next blank cell **Keep in mind that cells that look blank may not be blank if they have some formatting in them**
ctrl+end - Move to the last cell on a worksheet, in the lowest used row of the rightmost used column. If the cursor is in the formula bar, CTRL+END moves the cursor to the end of the text
home - Move to the beginning of a row
ctrl+home - Move to the beginning of a worksheet. (Cell A1)
alt+page down - Move one screen to the right in a worksheet.
alt+page up - Move one screen to the left in a worksheet.
ctrl+page down - Move to the next sheet in a workbook.
ctrl+page up - Move to the previous sheet in a workbook.
f4 - This is used for Functions to cycle through "absolutes". Absolutes are covered in a later post on functions.
ctrl+shift+" - Copies the value from the cell above the active cell into the active cell.
ctrl+d - Uses the Fill Down command to copy the contents and formats of the topmost cell of a selected range into the cells below.
alt+shift+f1 - Insert a new worksheet.
f2 - Edit the active cell.
ctrl+n - Create a new, blank workbook (this is a whole new document)
ctrl+spacebar - Select an entire column in a worksheet.
shift+spacebar - Select an entire row in a worksheet.
ctrl+a - Select the entire data range and a second time selects the entire worksheet.
shift+f3 - Insert a Function
alt+f8 - Display the Macro dialog box to create, run, edit, or delete a macro. **An introduction to Macros will be posted later.**
Many get frustrated when they want to create a new line in a cell, and the stupid thing exits the cell when they hit enter. Then they must retype everything back in and they still have the same road-block. Well, the Alt key is the answer. Alt + Enter allows you to enter inside a cell without exiting the editor. So next time you try to merge two cells in order to get that enter, just hit the Alt key.
I think that is enough of a deluge of information for now. Tune in next time for more ways to confuse yourself with in Microsoft™ Excel©.
**Thanks to shortcutworld.com for the original shortcut list, found at http://www.shortcutworld.com/en/win/Excel_2007.html.**
No comments:
Post a Comment