-
Newest Blog Post
-
Recent Posts
- Tom’s Tutorials For Excel: Using Data Validation to Disallow Entry of Item in a List
- Tom’s Tutorials For Excel: Using Data Validation to Force a Decimalized Numeric Entry
- Tom’s Tutorials For Excel: Going To the Precedent Cell with a Keyboard Shortcut
- Tom’s Tutorials For Excel: Doing a Lookup for Last Number or Last Text in a List
- Tom’s Tutorials For Excel: Reverse Lookup of nth Highest and nth Lowest Numbers
Recent Comments
- Tom Urtis on Tom’s Tutorials For Excel: Summing The First Nth Numbers in a Mixed List
- Chuck Hamdan on Tom’s Tutorials For Excel: Summing The First Nth Numbers in a Mixed List
- Berry on Tom’s Tutorials for Excel: Color the active cell, row, or column
- Tom Urtis on Tom’s Tutorials For Excel: Dynamic Summing From the Active Cell
- Lukas on Tom’s Tutorials For Excel: Dynamic Summing From the Active Cell
Archives
- May 2013
- April 2013
- March 2013
- February 2013
- January 2013
- December 2012
- November 2012
- October 2012
- September 2012
- August 2012
- July 2012
- April 2012
- March 2012
- February 2012
- January 2012
- December 2011
- November 2011
- October 2011
- September 2011
- August 2011
- July 2011
- June 2011
- May 2011
- April 2011
- March 2011
Akismet Spam Counter
Total Spam Fought: 59,432
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
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: 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
Tagged @TomUrtis/Atlas on Twitter, Atlas Programming Management, Atlas Programming on Facebook, date, Excel, excel how to, frequently asked questions about Excel, Keyboard, Microsoft Excel, Microsoft MVP, shortcut, static, Time, Tom Urtis/ Atlas on facebook, Tom's Tips for excel, Tom's Tutorials for Excel
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 @TomUrtis/Atlas on Twitter, Atlas Programming Management, Atlas Programming on Facebook, excel how to, frequently asked questions about Excel, Keyboard, Microsoft Excel, Microsoft MVP, Shortcuts, Tom Urtis, Tom Urtis/ Atlas on facebook, Tom's Tips for excel, Tom's Tutorials for Excel
Leave a comment
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
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 @TomUrtis/Atlas on Twitter, Atlas Programming Management, Atlas Programming on Facebook, excel how to, frequently asked questions about Excel, Microsoft Excel, Microsoft MVP, show formulas, show values, toggle, Tom Urtis/ Atlas on facebook, Tom's Tips for excel, Tom's Tutorials for Excel
Leave a comment
