Pages

Sunday 24 July 2011

Top 10 Excel Shortcuts

Ctrl+P                      – To Print selected region if region
Shift +F11              – To open new worksheet
Alt+F1                     – To create new chart (Selected cell should contain the chart values)
Alt+D+P                   –To create pivot table link (Current cell should belongs to raw data)
Ctrl+D                     -To Copy & paste the top cell’s content in the selected cells down
F4                           -To Repeat Last Action
Shift+Spacebar   -To Select entire row
Ctrl+Spacebar       -To Select entire Column
Ctrl+1                      -To Reach the Format Cells Dialogue box
Ctrl + ~                   -To change the format in General View

No comments:

Post a Comment