MS Excel

Computers are like air conditioners, they stop working properly if you open Windows.

  Man is still the most extraordinary computer of all. (John F. Kennedy)

Keyboard Shortcuts for Microsoft Excel

Speed up your outputs by using these shortcuts.

Practice is the key to success. Good Luck!

HOTKEY	DESCRIPTION
BASIC INFORMATION
Default sheets (per file):	3
Total Rows per sheet:	65,536
Total Columns per sheet:	256
Total Cells per sheet:	167,77,216
FUNCTION	FORMULA
Total Profit/loss Percent	=B63*B64/100 (actual amount*profit/100)
Total Amount (Profit)	=B56*B57/100+B56 (actual amount*profit/100 + actual amount)
Total Amount (Loss)	=D22*D23/100-D22 (actual amount*profit/100 - actual amount)
Percentage (Result)	=M7/750*100  (obtained Marks/Total Marks*100)
Square Root	=SQRT(B75) (find square root of a given number)
Average	=AVERAGE(D76:D83) (find average of a given range)
Maximum Amount	=MAX(D90:D97) (find maximum number in a given range)
Minimum Amount	=MIN(F90:F97) (find minimum number in a given range)
Count the Entries	=COUNT(D104:D115) (counts the entries in a given range)
Count if greater than 5000	=COUNTIF(B1:B31,">5000") (5000 is supposed amount)
Count if smaller than 5000	=COUNTIF(B1:B31,"<5000") (5000 is supposed amount)
Sum if greater than 5000	=SUMIF(B1:B31,">5000") (5000 is supposed amount)
Sum if smaller than 5000	=SUMIF(B1:B31,"<5000") (5000 is supposed amount)
Count by years from Today	=DATEDIF(D175,NOW(),"y") (counts a given date in years)
Count by months from Today	=DATEDIF(D176,NOW(),"m") (counts a given date in months)
Count by days from Today	=DATEDIF(D177,NOW(),"d") (counts a given date in days)
Choose Weekday	=TEXT(WEEKDAY(J182), "dddd")
Convert	=CONVERT(D19,"in","cm") (others: ft-m , lbm-kg , l-gal , C-F)
Large (First)	=LARGE(D203:D214,1) (find 1st highest number )
Large (Second)	=LARGE(D203:D214,2) (find 2nd highest number )
Large (Third)	=LARGE(D203:D214,3) (find 3rd highest number )
Small (First)	=SMALL(D203:D214,1) (find 1st smallest number)
Small (Second)	=SMALL(D203:D214,2) (find 2nd smallest number)
Small (Third)	=SMALL(D203:D214,3) (find 3rd smallest number)
Insert Current Date	=TODAY() (Keyboard Shortcut Ctrl + ; semicolon)
Insert Current Time	Ctrl + : (Keyboard Shortcut)
Insert Currency Symbol	Ctrl + Shift + $ (apply on an amount, already in a cell)
Change Date Format	Ctrl + Shift + # (change the date format, already in a cell)
Insert AutoSum Function	Alt + = (Keyboard Shortcut)
Show Formulas (Toggle)	Ctrl + ~ (show all formulas except results)
Move to Start /End of sheet	Ctrl + Home  /  Ctrl + End (Keyboard Shortcut)
Move to next/previous sheet	Ctrl + Page Up  / Ctrl + Page Down (Keyboard Shortcut)
Open the Format Cells dialog	Ctrl + 1 (Keyboard Shortcut)
Edit a cell's contents	F2 (Keyboard Shortcut)
To select a block/table of data	Ctrl + Shift + * (Keyboard Shortcut)
	Note: Red entries are supposed cells
Compiled and Tested by: Muhammad Ajmal Beig Naz Principal, Pentium Graphics Center & Training Institute

For more keyboard shortcuts and Tips, buy our book TIPS & TRICKS