# Tag Archives: Tom Urtis/ Atlas on facebook

## Tom’s Tutorials For Excel: Avoiding the #DIV/O! (Cannot Divide by Zero) Error

Tom’s Tutorials For Excel: Avoiding the #DIV/O! (Cannot Divide by Zero) Error I previously posted this example with the SUMIF function for bypassing the #DIV/O! error. Some errors are unavoidable, depending on the nature of your project. You probably know … Continue reading

| 1 Comment

## Tom’s Tutorials For Excel: VLOOKUP Without a Lookup Table

Tom’s Tutorials For Excel: VLOOKUP Without a Lookup Table When using a lookup function such as VLOOKUP, you can avoid a lookup table on a worksheet and insert the lookup elements directly into the formula itself. This is done by … Continue reading

## Tom’s Tutorials For Excel: Showing Your Named Ranges At 39% Zoom

Tom’s Tutorials For Excel: Showing Your Named Ranges At 39% Zoom Here’s a tip to get a bird’s eye view of the named ranges on your worksheet. All you need to do is set your worksheet’s Zoom to 39% or … Continue reading

## Tom’s Tutorials For Excel: Flipping a List

Tom’s Tutorials For Excel: Flipping a List If you want to flip a list so the order of items is vertically reversed, here’s one way to do that using this formula in the pictured example: =INDEX(A:A,COUNTA(A:A)+1-ROW())

## Tom’s Tutorials For Excel: Forcing entries in UPPER case

Tom’s Tutorials For Excel: Forcing Entries in UPPER Case Here’s how you can force users to enter all alpha (letter) characters in UPPER case, using Data Validation and no programming code. To make this happen, press Alt+D+L on your keyboard … Continue reading

## Tom’s Tutorials For Excel: Putting Comments In Formulas With The N Function

Tom’s Tutorials For Excel: Putting Comments In Formulas With The N Function You can add a text notation to a worksheet formula by using the N function. This is useful when you want to look at a formula and know … Continue reading

## Tom’s Tutorials For Excel: Entering a Static Date and Time

Tom’s Tutorials For Excel: Entering a Static Date and Time As you probably know, you can enter =TODAY() and get the current date, or =NOW() and format the cell as a time to get the current time. Those functions belong … Continue reading

## Tom’s Tutorials For Excel: Using the Keyboard to Select a Row, Column, or All Cells

Tom’s Tutorials For Excel: Using the Keyboard to Select a Row, Column, or All Cells Here are a few keyboard shortcuts for selecting your worksheet cells. To select the entire row of your active cell, press the Shift+Spacebar keys. To … Continue reading