by Nate Moore | Jul 11, 2012 | Basics
Today Excel Video 274 will use Go To Special to find a cell’s precedents and dependents. We talked about precedents and dependents in Excel Video 197. Precedents and dependents are like having a crystal ball with a rear view mirror attached. Precedents are like the...
by Nate Moore | Jul 9, 2012 | Basics
If you’ve hidden rows or columns and don’t want to copy what you’ve hidden, watch Excel Video 273. There are a couple of different ways to not display something in Excel. You can format your data as a table and then filter out the rows you don’t want to display. If...
by Nate Moore | Jul 4, 2012 | Basics
Excel Video 272 is the first of several Excel Videos with practical examples using Go To Special. Today we’ll create a reusable expense form that makes it easy to delete all of last month’s data without having to recreate the form to enter this month’s data. There are...
by Nate Moore | Jul 2, 2012 | Basics
When you want to tell Excel where to go, Excel Video 271 may not be what you had in mind. Today we’ll talk about how to get Excel to quickly go to a specific cell or to quickly select and highlight all of the formulas, comments, conditional formatting, constants or...
by Nate Moore | Jun 27, 2012 | Basics
In Excel Video 270 we’ll find cells based on the format of the cell. If you don’t care about the contents of the cell but want to find all of the cells with a red background color or a blue font, here’s how to do it. You can also find cells based on both the content...
