It's Friday so that means some more Formula Fun. Today let's look at calculating the percentage of cells in a range that contain a specific string. I have used this to as an alternative to a Pivot Table to look at the percentage of customers that each of my companys Sales people represent. It is a straightforward formula that searches in my list of customers and Sales people and returns how many customers each of those Sales people are responsible for. This percentage then changes as we … [Read more...]

## Formula Friday – Find And Hide All Formulas On An Excel Worksheet

Happy Formula Friday Excellers, today let's look at an awesome way to quickly find all of our formulas on an Excel worksheet and hide them. Today's post is in response to a question I was asked recently, as a colleague needed to find all of the cells on a (big...very big) Excel worksheet and hide them, so the worksheet could be distributed without fear of all of their hard work on their formulas being undone, with the click of an end users (clumsy) mouse. I do myelf often hide formulas, … [Read more...]

## Formula Friday – 2 Ways to Switch First And Last Names In Cells In Excel

Today's blog post was actually a question from one of my colleagues at work earlier this week, they had a list of first and surnames of employees, seperated by a comma, with the surname first and the first names last and they needed to switch them around for example ,from "Green, John" to" John Green". So let's look at two of the ways we could easily do this in Excel. The first method involves 2 steps. Method 1. Text To Column & TextJoin First we can use Text To Columns to … [Read more...]

## Formula Friday – Using Keyboard Shortcuts To See Precedent or Dependent Cells In Excel

Today let's look at how to use Excel keyboard shortcuts to see Precedent or Dependent Excel cells in an Excel workbook. I use these two commands to easily audit my Excel formulas. Cells that are referenced to in a formula or provide a value for a formula in another cell are called PRECEDENTS- you can see them below in this simple formula by selecting the cell that contains our formula in cell D3, then selecting Formulas Tab - Formula Auditing - Trace Precedents. Alternatively cells … [Read more...]

## Formula Friday – Move Your Formula Quickly Around Your Excel Worksheet Without Changing Cell References

Happy Friday, it is a somewhat zippy quick Formula tip today. Let's look at saving some time with your Excel Formulas. Even though the relative cell referencing in Excel is one of it's most powerful features, so when you copy a formula to a new location in your worksheet or workbook, then all of the relative cell addresses also change.... But.... Sometimes however, you may want to move your formula around your worksheet, but not change the cell references at all. We can easily do this by … [Read more...]

- « Previous Page
- 1
- 2
- 3
- 4
- 5
- …
- 11
- Next Page »