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

Tagged , , , , | 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

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

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

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

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())

Tagged , , , , , , , , , , , | 4 Comments

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

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

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

Tagged , , , , , , , | 2 Comments

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

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

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

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

Tom’s Tutorials For Excel: Identifying Your Active Window’s Top Left Cell

Tom’s Tutorials For Excel: Identifying Your Active Window’s Top Left Cell Here are a few macros that identify the top left cell of your active window’s spreadsheet. The first example relates to this picture, where cell HX63524 happens to be … Continue reading

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

Tom’s Tutorials For Excel: Toggling to Show All Formulas or All Values

Tom’s Tutorials For Excel: Toggling to Show All Formulas or All Values By pressing the Ctrl+~ keys on your keyboard, you can toggle between showing all the worksheet’s formulas or showing only values.

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