Blog & Excel Tips

A quick, simple method to build formula that will identify columns you want to hide and run a macro that will hide/ unhide these columns at a click of a button.

Compare Excel dates for month and year only without having to use an AND function and individually comparing the month and year.

When working in Excel and using the brilliant graphs and charts, you will occasionally want to see only the chart. The best way is to print this. But how can you only print the graph in Excel without all the other information.

Even the biggest of companies are not immune to spreadsheet errors. Marks and Spencer in the UK had to change their sales growth from a +1.3% to a -0.4% due to double counting in a spreadsheet.

If you come across a situation where Excel won't insert a column or row and gives you a message of 'To prevent possible loss of data, Excel cannot shift nonblank cells off of the worksheet. Select another location in which to insert new cells, or delete data from the end of your worksheet' you will need to follow a few simple steps to allow the insertion.'

A recent question we had went as follows: "Every time I open my “Example “ excel sheet, I get messages asking for a password for a completely different document, and a links message. Why is Excel asking for a password on an unprotected file? How can I stop it from happening or asking it without just clicking don’t update when I open it?

How to deal with zero in Excel including hide/ show zero numbers, use a dash as a zero number, hide, show zero percent or show zero percent as a dash.

Negative numbers in Excel can sometimes cause some confusion for users. In this Excel tip, we cover some of the most common issues/ questions addressing Excel negative numbers.