Time Saving Keyboard Shortcuts in Excel

Ramesh Shah (CA Final) (228 Points)

19 January 2011  

 

 

10 Time Saving Keyboard Shortcuts in Excel
Select Entire Row* Shift +Space bar
Select Entire Column* CTRL+Space bar
Insert New Row * ctrl +
Insert New Column * ctrl +
Delete Entire Row * ctrl -
Delete Entire Column * ctrl -
Enter Current Date CTRL+Semi colon
Current time CTRL+ Shift+Semi colon
Move within worksheets CTRL+Space up or down
Hide Row CTRL+9
Hide column CTRL+0
Switch Applications ALT+Tab
Insert Hyperlink CTRL+K(select the file, click OK