atlas

Monthly Archives: January 2012

Tom’s Tutorials For Excel: SUMIF formula examples

Tom’s Tutorials For Excel: SUMIF formula examples Here are examples of formula constructions with the SUMIF function. When you want to refer to a cell in the formula, enclose the mathematical operators in quotes. In the pictured Example 1, the … Continue reading

Tagged , , , , , , , , , , , , , | Leave a comment

Tom’s Tutorials For Excel: Listing Your Worksheets

Tom’s Tutorials For Excel: Listing Your Worksheets Here are a few ways to list the names of the worksheets in your workbook. For starters, you can right-click on the sheet navigation buttons to the left of your sheet tabs, and … Continue reading

Tagged , , , , , , , , , , , , , | Leave a comment

Tom’s Tutorials For Excel: Listing and Verifying Fonts

Tom’s Tutorials For Excel: Listing and Verifying Fonts While you can press Alt+O+E to call the Format Cells dialog box and see what fonts are available, with the below macro named ListFonts you can see your fonts on a worksheet … Continue reading

Tagged , , , , , , , , , , , , , , | Leave a comment

The Twelve Phases of Project Development

The Twelve Phases of Project Development Taken and jerry-rigged from this famous image sequence.

Leave a comment

Tom’s Tutorials For Excel: Printing Some Sheets, Not Printing Others

Tom’s Tutorials For Excel: Printing Some Sheets, Not Printing Others In some cases you want an easy way to print only certain sheets from your workbook. There are two approaches — identifying which sheets to include, or which sheets to … Continue reading

Tagged , , , , , , , , , , , , , , , | Leave a comment

Tom’s Tutorials For Excel: Filtering Columns

Tom’s Tutorials For Excel: Filtering Columns Free and safe downloadable workbook to filter by columns As you know, Excel only provides a built-in method of filtering for rows by individual columns. If you want to filter columns by their row … Continue reading

Tagged , , , , , , , , , , , , , , | Leave a comment

Tom’s Tutorials For Excel: Showing or Hiding Specific AutoFilter DropDowns

Tom’s Tutorials For Excel: Showing or Hiding Specific AutoFilter DropDowns You might want to AutoFilter a range of data, but only have the AutoFilter drop-downs be visible in the header row for some columns and not for others. This is … Continue reading

Tagged , , , , , , , , | Leave a comment

Tom’s Tutorials For Excel: Showing And AutoClosing a UserForm

Tom’s Tutorials For Excel: Showing And AutoClosing a UserForm Sometimes you might want to only show a UserForm for a brief time, say 5 seconds. For example, you might want to show a quick message that’s custom-formatted beyond what a … Continue reading

Tagged , , , , , , , , , , , , , , | Leave a comment

Tom’s Tutorials For Excel: Force an Entry Into an InputBox

Force an Entry Into an InputBox Previously, I posted this example for capturing Cancel with InputBoxes. In some development situations, you may need to force the user to make an entry to an InputBox. The below example is one way … Continue reading

Tagged , , , , , , , , , , , , , | Leave a comment

Tom’s Tutorials For Excel: Updating Links (or Not)

Tom’s Tutorials For Excel: Updating Links (or Not) You’ve no doubt seen this pop-up message upon opening a workbook: To automatically update links sans VBA, if the work being done is always on your computer… …In versions 2003 or before: … Continue reading

Tagged , , , , , , , , , , , , , , | 2 Comments