It is really easy to insert line breaks into Excel cells, all you need to do is hit ALT+ENTER where ever you want one. I know that I normally use them to make text easier to read in cells, longer...
Category: Excel Tips& Tricks
As far as Excel shortcuts go this really ranks as one of my favourites. I don't ever go to File Save as when I can simply hit F12. Yes that's it F12 and my Save As dialog box...
Do you often find yourself needing to fill a column with the weekday name only? Excel's autofill feature can make this easy for you. In this blog post, we will show you how to set up Excel to...
If you ever need to move or copy or move permantly a worksheet form one workbook to another then here is the best way to do it in Excel - using the Move or Copy Dialog Box. Firstly open the...
Calculating A Percentage Difference In Excel… The Fastest Balls In Wimbledon…
I am a huge tennis fan (in particular Wimbledon), and the speed of the balls amaze me. So, just how much faster were the fastest balls this year in Wimbledon compared to last year?. A good excuse...
Having spikes in your data can sometimes make it difficult to carry out predictive analysis. These spikes can be due to seasonal fluctuations in sales, for example more sales of soft drinks and ice...