Tuesday, September 7, 2010

How to Editing Your sheet Through Shortcut command

These are common shortcuts you will use to edit your Excel workbook. Our favorite shortcut in this list is, quite obviously, Ctrl+Z. * Ctrl+C: Copy the current selection to the clipboard. After you copy something, you can paste it with the paste shortcut. * Ctrl+V: Paste the current item from the clipboard. * Ctrl+X: Cut the current selection and place it on the clipboard, which can be pasted. The difference between cut and copy is that cut will delete your selection, while copy will not. * Ctrl+Z: Undo your last change. This is can be repeated to remove again and again to undo many changes. * Ctrl+Y: Redo your last Undo. This only is available if you have just issued an Undo command. * Backspace: Deletes the current cell and enters edit mode for that cell. This will only delete one cell and not a selection. * Delete: Deletes the current selection. Use the delete key when you want to delete more than one cell at a time. * Page Up: Move one page up in your worksheet * Page Down: Move one page down in your worksheet. Note: The number of rows moved in both page up and page down depend on how many rows are currently displayed. The more rows you have displayed the greater amount the row jump will be when you do a page up/down. * Ctrl+Home: Move to the beginning of your worksheet * Ctrl+End: Move to the end of your worksheet * Tab: Move right one column * Shift+Tab: Move left one column * Ctrl+Page Up: Go back one worksheet * Ctrl+Page Down: Go forward one worksheet. Note: If you are not using multiple worksheets in your workbook you will probably not us These shortcuts will help you quickly format your data. * Ctrl+B: Toggles bold on and off for your selection * Ctrl+I: Toggles italic on and off for your selection * Ctrl+U: Toggles underline on and off for your selection * Ctrl+1: Opens up the Format Cell popup
 
Powered by Blogger