Blog & Excel Tips

Can you copy from left to right in Excel in the same way as when you double click a copy to go downwards?

As indicated in a previous post, one of the tools that 'notices' colours in Excel cells is the Data Filter. By combining this with some other tools/ functions you can get a sum, count or average of the coloured cells.

If you have text in many cells and you want to (easily) combine the text into one cell there are a couple of ways you can do it.

If you want Excel to check if a cell in Excel is NOT equal to something, you can do it in one of two ways.

Once you have created your spreadsheet with your impressive charts, you may need to copy the Excel chart into PowerPoint or Word. There are a few options for this which are worthwhile considering.

Spreadsheets are great at sorting and identifying numbers but what can you do to match positive and negative numbers in excel. If you sort the numbers the 'matches' are as far apart as could be possible.

With the recent interest rate increase, it is important to understand the impact on your loan, typically your home loan.

Shortcut to make the columns in multiple sheets have matching widths without manually changing every column.