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...]

## Formula Friday – Let’s Use TEXTJOIN To Join Text Strings Without The CONCATENATE Complexity

Happy Friday Excellers. If you have Excel 2016 then you maybe already aware of some of the new functions that are available. One of thos functions is TEXTJOIN, and also CONCAT which was introduced in February 2016. I have been using TEXTJOIN recently to replace the function I used on a regular basis ---CONCATENATE, and I get the same results, without the hassle the CONCATENATE brings. Want To See How Simple TEXTJOIN is? Let's carry out the same process, first with CONCATENATE then … [Read more...]

- « Previous Page
- 1
- …
- 8
- 9
- 10
- 11
- 12
- …
- 17
- Next Page »