Cheat Sheet: 12 Tips and Tricks for Microsoft Excel

6

Comments

+ Add a Comment
avatar

inwo42

If you work with VBA code to make your own button functions, but don't know the programming for a specific task, I've found it useful to record a macro and examine the structure of the resulting code.  You can cut/paste into other functions, or use it as a template for similar commands.

avatar

LexiRedLion

VLookUp is garbage - fails if you don't have all data sorted.  A much, much better method is to use a combination of Index and Match.  Here's a real example of it and an explaination of what it's doing:

 

=INDEX(Wls_Status_11!F:F, MATCH(C:C, Wls_Status_11!B:B,0 ))

 

If what's in the current tab's column C:C matches what's in tab "Wls_Status_11" column B:B, return what's in "Wls_Status_11" column F:F

avatar

Paladin25

Anyone remember the old excel 97 3d thing?

avatar

bcarlzson

Download and install the ASAP utilities.  Tons of shortcut options.  And Free!

avatar

StahnAileron

Wouldn't it be easier to just select the column/cells with the formatting problem and just edit the cell properties to format the cells as numbers by default?

The method laid out in this article is one of the most roundabout ways I've seen for forcing a format style in a cell.

avatar

mario_ramalho

Why, oh why didn't you post this when I was taking the Microsoft Office Specialist certification last summer? This would have some in handy. I passed it anyway though. :P

Log in to MaximumPC directly or log in using Facebook

Forgot your username or password?
Click here for help.

Login with Facebook
Log in using Facebook to share comments and articles easily with your Facebook feed.