Message #65487

[msmarieh]

There's tons of tips and tricks in Excel!

The afore-mentioned autofill feature is especially useful.

I also adore filters - which allow you to screen rows to see just data that meets your criteria and conditional formatting - which modifies the formatting of your cell when it meets certain criteria (i.e. turning the background red when a date is past due or a budget number is exceeded).

Another extremely useful (and underutilized) feature is GoTo. Not the first screen that comes up which allows you to go to a particular cell, but the link to Special on the GoTo screen that then allows you to select all cells with formulas, all cells with data validation / conditional formatting / etc. Way useful and yet so few people know about it!

Finally, I really love Paste Special which allows you to not only paste links to data but also apply mathematical functions or transpose columns.

Marie