close

Login to Excel-King.com

Please use the login boxes below to log in to my webpage. You need to login in i. e. to make sure you can post to the forums.

Log in here!

Tips and Tricks

All those nitty gritty little things that make your life with MS Excel a lot easier will go into this section of the blog. Most of the times these are things like keyboards shortcuts or approaches to make your work a lot easier. Usually this is not worth a big tutorial but it helps improve your workflow with your spreadsheets and calcualtions.

Here is a quick tip or a little workaround for a limitation regarding conditional formatting in MSXL 2003. In this version, it is only possible to have max three different conditions for your table.

 

Todays post is about a very handy feature of MS Excel. If you have a file with similar structures you could use the grouping functionality in MSXL 2003 and 2007.

 

In this post I would like to talk about how to easily utilize the form controls which are available in MSXL without one line of VBA code!

 

As I was always struggling with this (and always wanted to learn it), I just want to show you, how to easily create a dropdown table that also could be used for references.

 

I just wanted to share with you a little trick that has been recently published. I will show you, how I use it to make my spreadsheets more informative.

Tweet, Tweet...

Click the little blue friend to follow Phil on Twitter!

Advertisement

Create Excel dashboards quickly with Plug-N-Play reports.