Excel Tips and Work
around...
List of some work around easy to implement and increase productivity
reducing little bit of your time...
|
TO DO
|
SHORT CUT
|
|
Edit Active Cell
|
press F2 (places cursor in
the end)
|
|
Hide Current Row
|
press ctrl+9
|
|
Hide Current Column
|
press ctrl+0
|
|
Un hide Rows In Selected Range
|
press ctrl+shift+9
|
|
Un hide Columns In Selected Range
|
press ctrl+shift+0
|
|
Recalculate Formulas
|
press F9
|
|
Select Data In Current Region
|
press ctrl+shift+8
|
|
See Formulas In The Worksheet
|
press ctrl+shift+` (ctrl+~)
|
|
Absolute To Relative (Vice-Versa)
|
press F4
|
|
Format A Number As Currency
|
press ctrl+shift+4 (ctrl+$)
|
|
Apply Outline Border Around
Selected Cells
|
press ctrl+shift+7
|
|
Open The Macros Dialog Box
|
press alt+F8
|
|
Copy Value From Above Cell
|
press ctrl+’ and ctrl+d
|
|
Format Current Cell With Comma
Formats
|
press ctrl+shift+1
|
|
Go To The Next Worksheet
|
press ctrl+shift+pg down
|
|
Go To The Previous Worksheet
|
press ctrl+shift+pg up
|
|
Get The First Name Of A Person
|
use
'=LEFT(<name>,FIND(" ",<name>)-1)'
|
|
Get Nth Largest Number In A Range
|
use ‘=large(range,<number>)’
|
|
Get Nth Smallest Number In A Range
|
use ‘=small(range,<number>)’
|
|
Generate A Random Phone Number
|
use'=RANDBETWEEN(1000000000,9999999999)'
needs analysis toolpak if you are using excel 2003 or earlier
|
|
Calculate Weighted Average
|
use SUMPRODUCT() function
|
|
Remove Unnecessary Spaces
|
use =trim(text)
|
|
Get Partial Matches In V-lookup
|
use * operator like this:
=vlookup(“abc*”lookup_rangereturn_column)
|
|
Simulate Averageif() In Earlier
Versions Of Excel
|
use =sumif(range
criteria)/countif(range criteria)
|
|
Format Any Selected Object
|
press ctrl+1
|
|
Insert Current Date
|
press ctrl+;
|
|
Insert Current Time
|
press ctrl+shift+;
|
|
Repeat Last Action
|
press F4
|
|
Edit A Cell Comment
|
press shift + F2
|
|
Auto sum Selected Cells
|
press alt + =
|
|
See The Suggest Drop-Down In A
Cell
|
press alt + down arrow
|
|
Enter Multiple Lines In A Cell
|
press alt+enter
|
|
Insert A New Sheet
|
press shift + F11
|
Post a Comment