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...
Tag: Excel Tips
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...
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...
So, I am used to talking about weather temperatures in Celsius, some of my friends would do this as well but depending where they are in the world they would talk about Fahrenheit. I talk about a...