Excel Tips

FORMULASFORMATTINGSHORTCUTSVBA
About Array Formulas Colour Even Rows Alt Keys Custom Functions
Colour Odd Rows Ctrl Keys GetFormula
Dates, Time and Age Colour Set Rows Function Keys GetColor
Add Months (EDATE) Colour Rows with Filter Shift Key GetFormat
Age Calculation Dates & Time AutoShapes SheetName
Age Check Fractions Sheets BookName
Count Weekdays Numbers & Currency Multiple Entry FullName
Count Hours Show Incorrect Entry HasFormula
Get Weekday Date Variable Format HasText
Calculate Shipping Date Zeros in front of Numbers GetComment
First of Month Hide Zeros GetFont
Last of Month (EOMONTH) Hide Entries IsColor
Instant Calendar Hide Errors CountColor
List Month Days Hide Formulas RowSize
Week Number (Absolute) Align Decimals ColumnSize
Week Number (ISO) Fill Cell GetNumbers
Week Number (WEEKNUM) Singular & Plural GetText
ISO New Year Find Protected Cells JoinText
ISO Week Count Find Formulas
Current Date Protect Formulas Comments
Get Day Find Duplicates Autofit Comments (Sheet)
Get Month Find Unique Values Autofit Comments (Selection)
Get Year Cell Text To Comment
Get Quarter Comment Height
Detect Leap Years Show Comments
Count Leap Years Hide Comments
Avoid Weekends Reposition Comments (Sheet)
Floating Dates Reposition Comments (Selection)
Get Weekday Occurence Add Rounded Comment
Decimal Time Add Comment With Text
Font Size
Text and Numbers
Count and Add with Criteria Worksheets
Count Characters in Single Cell Show All Sheets
Count Characters in Range Hide Active Sheet
Count Words in Single Cell Hide Selected Sheets
Count Words in Range Auto_Open (Unlocked Cells)
Count Numbers in Range Auto_Open (Select Cell A1)
Count Text in Range Protect Worksheets
Find Text in Range Protect Worksheets
Remove Numbers from Left Unprotect All Sheets
Remove Numbers from Right Change Sheet Name
Remove Text from Left Select All Objects
Remove Text from Right Delete All Objects
Remove Currency Group All Objects
Remove All Decimals Select Used Range
Remove Certain Decimals
Round to Nearest 5 Cents Toggles
Find the Decimal Display Formulas
Ordinal Numbers Show Zeroes
Find Maximum using Criteria Toggle Gridlines
Find Minimum using Criteria Toggle Display Headings
Find 3rd Largest using Criteria Toggle Scroll Bars
Sum Every 3rd Row Toggle Workbook Tabs
Sum 3 Largest Numbers Toggle Status Bar
Find 3 Largest Numbers Toggle Formula Bar
Convert to Feet & Inches
Basic Trigonometry Conditional Select
Random Numbers Select by Color
Ignore Errors (or Text) Select by Value
Count Errors Select between Values
Ignore Zeros Select Cells With Formulas
Ignore Duplicates
Number Duplicates (Single) Message Boxes
Number Duplicates (Multiple) Message Box Examples
Count Unique Values
Count Duplicates Events
Count If Similar BeforeSave Example
TRUE if Similar
Match If Similar
Get Nth Word
Get Last Word
Get First Name
Get Middle Name
Get Last Name
Reference
Compare Lists 1
Compare Lists 2
Find Cell Reference
Find Column Letter
Find First Cell Address
Find First Cell Value
Find Last Cell Address
Find Last Cell Value
Find Maximum Address
Find 3 Largest Values Addresses
Multiple Criteria Lookup
Show Every 3rd Row
Nested Ifs Workaround
Show Extra Rows
Instant Row Numbers
Reference Dates
Remove Blanks
Reverse List
Randomize List