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 – How To See Values And Formulas On The Same Spreadsheet At The Same Time

Hey Exceller's here is a great tip I want to share with you I have used myself this week. Being able to see both your values and formulas on the one spreadsheet at the same time. It' quick and simple - Click into your worksheet you want to view values on and formulas on Hit the View Tab - New Window. You will now see 2x windows with your workbook, the original sheet will have :1 after it's name and the second version of your sheet with have :2 after the file name. … [Read more...]

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