Undo – Redo – Undo – Redo… I don’t know about you, but I find that I tend to use that cycle of events a lot when I’m putting finishing touches on things… especially on one of my “picky” days when everything has to be perfect.

Anyway, it’s a great feature, and I’m sure that I’m not the only one using it.

Ever find that you need the column width from one column transferred to others without all the data and other formatting?

Maybe the width you need is in a column formatted as bolded text and, while the width needs to be transferred, the rest doesn’t. In a case such as this the old Format Painter won’t help as much as we’d like it to, since it transfers… Continue reading

So, you’ve found yourself once again entering a bunch of text into an Excel worksheet… and once again, the text is getting repetitive.

Let’s say that you’ve got a list of employees and need to enter the department they work in for each one. This means that you’re in column B typing the same things over and over again – after all, there are a finite number… Continue reading

I’d say that Excel has an issue when you’re actually trying to type an equal sign into a cell without starting a formula – in other words you need to treat the equal sign like text instead of a formula starter.

If you tend to take information from Word, PowerPoint, the Web, or wherever to MS Excel, then I’m positive that you know about your formatting choices when you paste.

We’ve all seen the Paste Options button appear. This is where you can decide to have the information keep its original formatting, or have Excel reformat it to match the rest of the worksheet.… Continue reading

I can’t speak for everyone, but when I’m using pictures in my documents, e-mail messages, spreadsheets or presentations, I’m looking to make an impression.

While a picture in its own right can be a very powerful message, sometimes it would be nice to have that same picture presented in a different manner, maybe as a pencil sketch, a chalk sketch, an image seen through glass or even… Continue reading