Oct 13 2013
This might be a bit of an obscure issue but one worth keeping in mind. If you work with Microsoft Excel under both Mac OS X and Windows then you may find an issue with date values changing by themselves when you open them on the other platform (i.e. opening a spreadsheet creating in Mac …
Mar 15 2013
For whatever reason, you may end up with a huge amount of e-mail stuck on a mail server and it all just needs to go. Maybe you’ve been lax in clearing e-mail, your e-mail application isn’t managing your mailbox properly or perhaps you’ve just been spammed into oblivion. However, if you’ve got hundreds or even …
Feb 06 2013
Following on from yesterday’s tip on how to search for carriage returns in Excel spreadsheets, here’s how you can incorporate this non-printable character into your formulae. The secret sauce for carriage returns is to include CHAR(10) into your formulae. For instance, if you want to concatenate two cells but put the values on different lines in …
Feb 05 2013
Most people know how to use the search and replace function in Excel spreadsheets but it can be a tricky task if what you’re looking for is a non-printable character like a carriage return (i.e. hitting Enter on the keyboard). Thankfully, it’s easy enough to do once you know how 🙂 In the Find and …
Jul 28 2012
Last night I decided to try out Office 2013 – perhaps not the smartest thing to do just as the university semester is getting underway but I couldn’t help myself. Anyway, I just wanted to share my first impressions of it with you starting with the installation. First of all, the time between kicking off …
Jul 26 2012
Here’s something to try if you have a spreadsheet that seems to occupy far too much disk space given the content it contains. One sheet at a time, try moving a sheet to a blank workbook and then moving it back to the original workbook until you have done it for all workbooks. I can …
Feb 13 2012
From time to time you might receive an Excel spreadsheet that has been created by an application but it has output the dates in its own text format instead of being stored as an actual date value. I’ve seen instances where the time has been placed before the date which would leave many to think …
May 26 2011
A lot of us would have come across a situation where the text in our web browser just became twice as small for an unknown reason. With so many keyboard shortcuts and buttons on mice it can be hard to work out if you pressed a key or clicked on something by accident to create …
Feb 28 2011
More people are making the switch to Office 2007 and Office 2010 however there are still those clinging on to older versions who are unable to open the newer Office 2007 formats (such as .docx and .xlsx which are differentiated from older versions with the extra “x” on the end of the file extension). I …
Follow Us!