Go to Special

[psrs0810]

Where can I get more information on the functions in Go To - Special?

thanks

 

[RoryA]

Excel Help? What did you want to know?

 

[psrs0810]

Excel help was not that helpful. I want to know what each function under Special does.

 

[Andrew Poulsom]

Which ones don't you understand? Presumably it's not all of them.

 

[psrs0810]

what is the difference between Current Region and Curreny array?

What is Row and Column Differences and Precedents and Dependents?


These are ones that I don't use and I am not sure what their functionality are.

Thanks

 

[Andrew Poulsom]

Current Region is a range bounded by blank rows and blank columns (relative to the active cell), ie a rectangle. The Current Array is the range containing the same array formula (entered in multiple cells at once). Precedents are cells that are referenced by the formula in the active cell. Dependents are cells which reference the active cell in their formulas.

For Row and Column Differences, here's a video:

http://www.mrexcel.com/Excel_Row_Differences_training.html

 

[psrs0810]

I am not getting current array to work. So I am not understanding it

 

[Andrew Poulsom]

Do you have an array formula in the active cell?

 

[psrs0810]

can you give me an example?

 

[Andrew Poulsom]

Have a read of this:

http://www.cpearson.com/Excel/ArrayFormulas.aspx