hide show
List of shortcuts for Excel 2007:
Alt+F1Create Chart Worksheet
Alt+F11Open VBE
Alt+F12Open VBA
Alt+F2Save As
Alt+F4Close Excel
Alt+F8Macro Window
Alt+TabSwitch between windows
Ctrl+*Select all connected data plus cell with cursor
Ctrl++Insert
Ctrl+-Delete
Ctrl+0Hide column
Ctrl+1Format Cells
Ctrl+2Bold
Ctrl+3Italics
Ctrl+4Underline
Ctrl+5Strike-Though
Ctrl+7Toggle Standard Menu
Ctrl+8Show outline
Ctrl+9Hide row
Ctrl+ASelect all connected data plus cell with cursor
Ctrl+Alt+F1Create Macro Worksheet
Ctrl+Alt+F2Open
Ctrl+ArrowMove to last data before blank space
Ctrl+BBold
Ctrl+CCopy
Ctrl+EndMove cursor to last row with data and last column with data
Ctrl+FFind
Ctrl+F1Help
Ctrl+F10Maximuze worksheet
Ctrl+F11Create Macro worksheet
Ctrl+F12Open
Ctrl+F3Create name
Ctrl+F4Close Worksheet
Ctrl+F5Restore worksheet
Ctrl+F9Minimize worksheet
Ctrl+HFind + Search
Ctrl+HomeMove cursor to A1
Ctrl+IItalics
Ctrl+NCreate new workbook
Ctrl+PPrint
Ctrl+PageDownSwitch to next sheet
Ctrl+PageUpSwitch to previous sheet
Ctrl+SSave
Ctrl+Shift+0Show column
Ctrl+Shift+1Change number to 2 decimal points
Ctrl+Shift+2Change number to time format
Ctrl+Shift+3Change number to date format dd-mmm-yy
Ctrl+Shift+4Change number to dollar notation rounded to nearest cent $DD...D.DD
Ctrl+Shift+5Change number to percentage format
Ctrl+Shift+6Change number to exponential notation
Ctrl+Shift+7Add border to selected area
Ctrl+Shift+8Select all connected data plus cell with cursor
Ctrl+Shift+9Show row
Ctrl+Shift+EndSelect all cells from cursor to last column and last row
Ctrl+Shift+HomeSelect all cells from cursor to A1
Ctrl+SpaceSelect Column
Ctrl+TabSwitch to next workbook
Ctrl+UUnderline
Ctrl+VPaste
Ctrl+ZUndo
F2Switch to text within cell
Shift+F11Insert new workbook
Shift+F3Open Function Window
Shift+SpaceSelect Row
News
Coding
Press Release
Blog
Business Solutions
eMarketing
Data Integration
Careers
Data

© 2009 ID1337. All Rights Reserved.
ID1337 is a small business solutions provider specializing in digital marketing, internet marketing, and eMarketing.