How to Hide and Unhide Columns and Rows

By Bob Umlas, Excel MVP Here we’ll be exploring the various ways to hide and unhide rows and columns in Excel. The bulk of the discussion will address columns, but it applies to rows as well (unless otherwise noted). How to Hide Columns You can change a column width by dragging the column separator (the

Read More...

Excel’s JUSTIFY Command

By Bob Umlas, Excel MVP Have you heard of the Justify command? Let’s take a look at it here. Suppose you have the data below: and you’d like to make it look like this: You may not know that Excel has this ability already built-in! It’s called the Justify command, found on the right side

Read More...

Demystifying Excel VLOOKUP

By Bob Umlas, Excel MVP Using VLOOKUP in Excel seems to be a mystery to many. But you do it all the time in real life—you look up a word in a dictionary and scan a little to the right to read the definition. Well, it could be the same thing in Excel: If you wanted

Read More...