By Bob Umlas, Excel MVP In this blog, I’ll discuss sorting, likely beyond features you knew were available! We’ll start with this screenshot of a file: It needs sorting. There are many ways to sort data. There are 3 ways to access sorting from the Data tab: 1– 2–You can right-mouse click on a cell
Read More...
By Bob Umlas, Excel MVP In this blog we’ll explore the various ways to hide and show rows and columns. The bulk of the discussion will address columns, but it applies to rows as well (unless otherwise noted). You can change a column width by dragging the column separator (the little line between columns) left
Read More...
By Bob Umlas, Excel MVP Excel has hundreds of keyboard shortcuts. In this blog, I’ll describe some of my favorites Ctrl+Shift+ numbers 1 thru 7, and 0 (and the tilde key, ~) can be used for formatting. Let’s start with this sample worksheet, and assume A1 thru B2 is already selected and contains 12345: Ctrl+shift+1
Read More...
By Bob Umlas, Excel MVP After reading this blog you should be an expert in Excel’s Dates and Times. If you enter the number 1 in cell I1, for example, then look at the Home tab’s Number Format’s dropdown, you’ll see this (without the arrows!): Notice that the number 1, formatted as a short date
Read More...
By Bob Umlas, Excel MVP In this blog I’ll continue the discussion from my last blog on basic filtering. This one is on advanced filtering. Let’s continue with the same worksheet used from the last blog: You can use advanced filtering for any of the features you use basic filtering. The advanced feature enables you
Read More...
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...
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...
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...
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...
By Bob Umlas, Excel MVP Still using long formulas to create grand totals in Excel? There is a better way! Suppose you have a worksheet which looks something like this: Clearly, what’s needed is the grand total in cell B38. Notice that there are several subtotals in the list. The formula in cell B9, for
Read More...