whats the most off the wall excel trick you have used?

excel is clever, but sometimes too clever, requiring a bit of lateral thought (or a eureka moment) to achieve what sounds simple but is in fact not catered for. an example is a recent post about how to copy formula across columns, but referring to cells down rows.

why not share your eureka moments with the world? solutions that solved a problem without resorting to visual basic!
Alastair Harris

Comments
There are 7 comments. Login or register to view them.

To show formulae in a sheet

lornajane |

Excel tricks...

AnonymousUser |

Unlock

AnonymousUser |

Drill down

AnonymousUser |

Exel is alright

AnonymousUser |

Thanks Rob Brown

velohead |

Not really that clever

Anonymous |