Flagging duplicate values in Excel

I was working with Sandra the other day on a project that involved an Excel spreadsheet and about 2400 lines of data. I had to check to see if I had any duplicate values in one of the columns. Since I’m not the sharpest tool in the drawer when it comes to Excel, I asked her if she could help me somehow find potential duplicates instead of me scanning through the list manually. I was duly embarrassed when she showed me just how simple that is… 🙂

Smaller Excel spreadsheets by removing “blank” cells

OK… I haven’t lost my mind here… It is very possible that if you have a large spreadsheet that has very little data in it, you might have a large number of blank rows in one of your worksheets. Each of those “blank” cells in the “blank” rows takes up space, and it can add up rather quickly when it comes to the overall size of your spreadsheet… let me show you how to fix that.

Running a “paper tape” in Excel

Today’s tip comes courtesy of Francis Hayes – The Excel Addict, where he explains how to simulate a “paper tape” function in Excel. For you young’uns who are confused by this concept… in the olden days, people used to add numbers on an adding machine, which often produced a paper tape as the numbers were entered. You would get a total, plus a visual list of numbers that got you to that total. You could then confirm that you entered everything correctly. Some habits die hard however, and here’s how you can do the same type of “paper tape” function in Excel.

Concatenating Excel data with Fill Justify

This is one of those tips you may not know about, but it will be a lifesaver if you only have to use it once. Using the Fill > Justify feature in Excel, you can concatenate data from multiple Excel cells into a single cell. It’s easy, and here’s how it works…

Multiple Office Clipboards in Office applications

Having done this tip gig for a number of years now, I don’t often find a tip that blows my mind. It’s even more rare that I find a tip that blows my mind, *and* has apparently been there for years. Today’s tip fits that bill… you can have up to 24 selectable Office Clipboard entries to choose from when you’re working in Outlook, Word, Excel, or PowerPoint. Even better is that they are shared across all those programs!  Here’s how it works…

Using the Screenshot feature in Excel

Here’s a feature in Excel that I never noticed before… like *that’s* a surprise! 🙂 If you need to add a screenshot in an Excel spreadsheet (perhaps for documentation), you can use the Screenshot feature that’s built into Excel… and you can manipulate the image once it’s out there! Here’s how you do that…

Changing an Excel column of text numbers to actual numbers in a couple of clicks

I have a bit of a love-hate relationship with Excel. I know it’s very powerful, but I really don’t know how to use it beyond the very basics. Today was one of those instances where I had a column of “numbers” in a spreadsheet that I wanted to sort, but Excel thought they were text strings. I wasn’t sure how to get Excel to truly treat them as numbers until I found this cool trick…