Blog & Excel Tips

If you want to add the (±) plus minus symbol in Excel there are a number of ways to do it.

A couple of things to check if the scroll bars are missing in an Excel spreadsheet

If you use Conditional Formatting you will have come across the problem where edit using the arrows keys does not work in Conditional Formatting. A quick fix

Find email addresses with the same name but different domains in Excel.

How to combine text and numbers in an Excel cell so that the number retains its formatting

One reason why it may look like your scroll bars are not working (you scroll down but the screen stays in the same place)

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.