Shortcut Keys for Manipulating Worksheets in Excel 2003

Learning keyboard shortcuts will make operating your worksheets easier in Excel 2003. Here are some shortcut keys to basic commands in your Excel worksheets:



















































PressTo
Ctrl+Page DownActivate next sheet in the workbook
Ctrl+Page UpActivate previous sheet in the workbook
Shift+Ctrl+Page DownSelect current and next sheet in workbook
Shift+Ctrl+Page UpSelect current and previous sheet in workbook
Shift+F11 or Alt+Shift+F1Insert new sheet in workbook
Alt+OHRRename current sheet (Format→Sheet→Rename
Alt+OHHHide current sheet (Format→Sheet→Hide)
Alt+OHUUnhide current sheet (Format→Sheet→Unhide)
Alt+OHTSelect new color for sheet tab (Format→Sheet→Tab
Color)
Alt+EMMove or copy current sheet in workbook or to new workbook
(Edit→Move or Copy Sheet)
Alt+EDDelete current sheet (Edit→Delete)



dummies

Source:http://www.dummies.com/how-to/content/shortcut-keys-for-manipulating-worksheets-in-excel.html

No comments:

Post a Comment