Basic Filtering in Excel

By Bob Umlas, Excel MVP  In this blog I’ll discuss filtering. In another continued blog, I’ll talk about advanced filtering. First, what is filtering? We’ll define it by looking at a very simple illustration. Suppose this is your worksheet: If you were only interested in the West region, you can show just the West items

Read More...

The Page Layout Tab, Part 3 of 3

By Bob Umlas, Excel MVP For the final part of the Page Layout tab series, we’ll complete the discussion of what’s available on the tab and a few other items. The Header/Footer tab of the page setup dialog is where we left off. Let’s look at this again. Click the dialog launcher below the Print

Read More...

The Page Layout Tab, Part 2 of 3

By Bob Umlas, Excel MVP Last time with the Page Layout tab, we left off with the “Breaks” icon. Next is the “Background” icon. This puts a graphic in the background of the sheet. This background does not print, it merely shows on the physical viewing of the sheet on your computer screen. When you

Read More...

The Page Layout Tab, Part 1 of 3

By Bob Umlas, Excel MVP It seems not much has been written about Excel’s Page Layout tab so I’ll cover the items shown here (which do not include all the commands) up until the Breaks icon. In parts 2 of 3 and 3 of 3, I’ll cover the icons from Background to the end, as

Read More...

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...