Thursday, January 12, 2012

Shortcut Keys in Excel

!.......Pls find below shortcut keys in Excel......!

Delete Sheet:- Alt+E+L
Move Sheet:- Alt+E+M

Insert Pivot Table:- Alt+D+P
Sheet Rename:- Alt+O+H+R
Create List:- Alt+D+L
Advanced Sort:- Alt+D+S
AutoFit to text :- Alt+O+C+A
Insert New Sheet :- Shift+F11
Insert Comment:- Shift+F2
Format Cell options:- Ctrl+1 & Alt+O+E
Fill down Text:- Ctrl+D
Bold Text:- Ctrl+B & Ctrl+2
Italic Text:- Ctrl+I & Ctrl+3
Underline Text:- Ctrl+U & Ctrl+4
Insert Strike into Text:- Ctrl+5
Hide Active or Selected Row:- Ctrl+9
Hide Active or Selected Row:- Ctrl+0
Insert Function Option:- Shift+F3
Print Preview:- Ctrl+F2
Toggle b/w Excel & VBA Editor:- Alt+F11
Show Macros in Current Workbook:- Alt+F8
Create Hyperlink Text:- Ctrl+K
Insert New Row or Columns:- Ctr+
Delete New Row or Columns:- Ctr-
Insert Chart:- F11
Save As Workbook:- F12
Select 1st Cell in Worksheet:- Ctrl+Home Key
Toggle b/w two or more workbooks:- Ctrl+Tab
Toggle b/w sheets:- Ctrl+PgUp key move next sheet & Ctrl+PgDn key move previous sheet
Show all Formulas in workbook:- Ctrl+~
Insert or Remove Filter:- Ctrl+Shift+L & Alt+D+F+F
Active Paste Special Menu:- Alt+E+S
Display Text to Column Menu:- Alt+D+E
Increase or Decrease formula bar height:- Ctrl+Shift+U
Show Go To :- F5 & Ctrl+G
Show Find & Replace:- Ctrl+H
Create Table:- Ctrl+L
Show Custom Color Menu:- Alt+O+H+T
Show Font Menu:- Ctrl+Shift+P & Ctrl+Shift+F

1 comment:

Excel VBA to send email from excel with HTML table in a email body

'' Excel vba script to send email from outlook & email body in HTML table format. ''Write down email body in HTML tags...