Blog & Excel Tips

Blog entries covering the latest Excel tricks and tips based on queries from clients and practical knowledge from our consultants.

Only print the graph in excel Jan 10, 2022

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.

Excel won’t insert a column or row Jan 3, 2022

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.'

Excel asking for a password on an unprotected file Jan 2, 2022

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?

Zero in Excel Jan 1, 2022

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.

Excel negative numbers Dec 17, 2021

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.

Consulting

We aim to provide the ultimate, one stop shop for all Excel users requirements, within South Africa and worldwide.

Find Out More

Live Training

"Recently we had a most successful in-house training session at our company. I would like to extend my thanks and gratitude."

Find Out More