Excel Super Gems
Now don’t you hate it when you’re at work and your boss says you ‘can you put it in a spreadsheet’? You could be a Excel whizz and love doing spreadsheets but if you are anything like me then you will agree that excel just isn’t your friend!
One day while I was typing away I heard a loud grunting noise coming from downstairs…I wondered what it could be, turns out was our head of sales – Joe sitting there with his head in his hands practically banging his head against the screen!
He was getting in a right huff trying to use excel when all he really needed was a few helpful secrets to help him on his way…
Even though it’s not my favourite tool I hope you find these top 3 nuggets helpful…
1. How To Put Text On Several Lines
If you’re typing text or multiple lines of data into a cell and you want the text to appear on several lines, then instead of entering the text in another cell just simply press
ALT+ENTER
And you’ll start a new line while you’re typing or editing data.
2. What’s That Sum?
Excel is brilliant for calculating sums, I found a great little tool to help you calculate your numbers quicker! If you have a row of numbers you want adding together then highlight them and click the sum tool and it does it for you!
3. Freeze Panes – Making It Easier On The Eye
If you have a heading you would like to view while you scroll down on the excel sheet all you need to do is hit the row under where you want to view and click window freeze panes
These 3 little gems have been extremely useful for me so far and I hope they will be for you!
If you need any more advice then give us a call on 020 3301 0003.
