Your Excel Hints and Tips

Soldato
Joined
20 Feb 2004
Posts
23,340
Location
Hondon de las Nieves, Spain
I'm no stranger to a long confusing looking formula in Excel and sometimes it can take me ages to work out what i've actually done.

I was recently sent a file from someone who'd used "Alt-Enter" in the formula bar to lay out the formula to be more "code like"

I thought it was handy and made a note to try and use it in practise.

It's turned this confusing shambles of text from this

o2zybAB.png


to this, which i'm sure you can agree is much easier on the eye!

WPcwU07.png





So what are your tips when working in Excel?
 
Back
Top Bottom