Clearing one cell’s format
If a whole row/column is formatted and you want to clear just one cell’s format, click edit>clear>format
Downfill
Another way to downfill is to highlight range, and double click on hairline cross
Create Style
Sit on a cell format>style>overtype & click ok
‘Split’ enables you to scroll different parts of a spreadsheet at the same time
Linking multiple cells
Ensure each worksheet is exactly the same. =sum(select first cell on worksheet>shift>last worksheet) enter
Locking cells
F3 key makes a cell ‘absolute’ by locking it in. Click on cell description and press F4
Once $c$2, always c and always 2 absolute
Again c$2, always 2
Again $c2 always c mixed
Again c2 relative
Rounding
=Round (_______,x) (x denominates the number of decimal places)
=Roundup (_______,x)
=Rounddown (_______,x)
e.g. =Round(salary1/12,0)
If Function
=if (text, true, false)
e.g. =if(c2>b2,c2*5%,”You’re fired”)
text must always be surrounded by speech marks
Nested function
=if(c2=b2,c2*5%, if(c2>b2,c2*10%,”You’re fired”))
=if test, true click on FZ test, true, false
if conditional formatting, always a good idea to name the range
Charts
Highlight area to chart, and press F11