Blog Archives

Tom’s Tutorials For Excel: Delete Rows With Blank Cells

Tom’s Tutorials For Excel: Delete Rows With Blank Cells

Sometimes you have a list for which you need to delete rows where a cell is blank in a particular column. If the list is small, you can eyeball each blank cell, select it, and delete the row manually,

Read more ›

Posted in Tom's Tutorials for Excel
Tags: , , , , , , , , , , , , , ,

Tom’s Tutorials For Excel: Show Your Named Ranges

Tom’s Tutorials For Excel: Show Your Named Ranges

If you actually want to see your named ranges labeled on your worksheet, you can set your window’s Zoom to 39% or less. Here’s an example.

In this first picture is a company’s annual budget organized for Income,

Read more ›

Posted in Tom's Tutorials for Excel
Tags: , , , , , , , , , , , , , ,

Tom’s Tutorials For Excel: Hide the right-click Mini Toolbar

Tom’s Tutorials For Excel: Hide the right-click Mini Toolbar

In versions 2007 and 2010, there is a mini toolbar that appears when you right-click a worksheet cell. There is an option to show that mini toolbar but not an option to hide it.

In Picture #1,

Read more ›

Posted in Tom's Tutorials for Excel
Tags: , , , , , , , , , , , , ,

Tom’s Tutorials for Excel: Delete Hyperlinks, Keep Their Text

Tom’s Tutorials for Excel: Delete Hyperlinks, Keep Their Text

At some point you have probably inherited or created a worksheet that contains active hyperlinks, when all you want in the cells is the hyperlink text itself. It’s annoying to unwittingly click onto a hyperlink cell that interrupts your work by suddenly taking you away from your worksheet.

Read more ›

Posted in Tom's Tutorials for Excel
Tags: , , , , , , , , , , , , , ,

Tom’s Tutorials for Excel: Dynamic Conditional Formatting By Group

Tom’s Tutorials for Excel: Dynamic Conditional Formatting By Group

To improve the readability of your lists, you can conditionally format alternating groups of primary items. The challenge is to make this happen when the count of each client name varies in the list, which can change at any time.

Read more ›

Posted in Tom's Tutorials for Excel
Tags: , , , , , , , , , , , , ,