Cutting it short
shortcut for save
What's CTRL + S?
inserts 10 ascending numbers in a column
What's sequence(10)?
View > Arrange All > Vertical
How to compare two sheets vertically?
shortcut for formating number
What's CTRL + SHIFT + 4?
changes unformatted date into a date value
What's datevalue?
Remove duplicates is located here
What is Data?
shortcut to format date
What's CTRL + SHIFT + 3?
combines two email addresses (email1 and email2)
What's email1&email2?
Conditional formatting is located here
What's Home?
shortcut to select all rows
What's CTRL + SHIFT + DOWN?
finds the row number in a lookup range
What's match?
Moves to the next sheet
What's CTRL + PAGEUP?
shortcut to select a row
What's CTRL + SPACE?
finds the value in an array
What's index?
1,048,576
What's the row limit in XLSX?