Microsoft Excel: Go To Special - Formulas
In this video, we will look at selecting cells that have data obtained from formulas. When the dataset is big and cells with formulas are spread across the dataset then, it becomes very difficult to find those cells. It consumes a lot of time. In such cases, Microsoft Excel has provided a feature called 'Go To Special'.
Go to special has a formulas option in it. There are 4 types mentioned under it. Numbers, Text, Logicals, and Errors. These types provide the cell selection as per their name. For example, if we select Numbers in the Go to Special formula option then, it will select all the cells that are numerical and the values are obtained from a formula. Similarly, other types make their cell selections.
This video tries to cover the same. I hope the video proves to be useful. Thak you.