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.

Dollars in your eyes

Print
PDF

Written by inservo | 08 February 2010

Todays post is all about dollars! Well, to be honest, it's more about the $-sign (I think it's usually known pronounced as "string"), but hey, I wanted to make you curious. We will talk about referencing which can help you a lot when entering greater amounts of formulas or copying them.

Read more... Add new comment

Quick-Tip: Easy way to select ranges

Print
PDF

Written by inservo | 29 January 2010

In yesterdays post I showed you an effective approach to enter formulas in cells all at once by selecting the range, entering the formula and pressing CTRL+Enter instead of only Enter. Todays post will enhance this technique a little bit more.

Read more... Comments (1)

Quick-Tip: Easy entering

Print
PDF

Written by inservo | 28 January 2010

Today I want to focus on a little technique, that makes it easy to enter a big amount of formulas in a very short time.

 

Read more... Comments (1)

Quick-Tip: Align chart to cells

Print
PDF

Written by inservo | 14 January 2010

Today I want to share a quick tip with you which I learned recently. I think you know the problem: Sometimes it is hard to give a nicely created chart an exact position. You can of course CTRL-klick your chart to treat it like a graphic and nudge it with your arrow keys (see this post) but there is an even easier way.

Read more... Add new comment

Quick-Tip: Make values invisible

Print
PDF

Written by inservo | 05 January 2010

Todays Quick-Tip is really a very very short one. It's about formatting a value towards invisibility. Sometimes you need values in cells only for calculation purposes and don't want your users to see them.

 

Read more... Add new comment

More Articles...

Tweet, Tweet...

Click the little blue friend to follow Phil on Twitter!

Advertisement

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

Popular in the Forums

1. Conditional styles - discussion (915 Views)
2. Exceed Excel 2003 limitations - discussion (424 Views)
3. 3 immediate tips for your chart - discussion (303 Views)
4. Forming your spreadsheet - discussion (287 Views)
5. Nudge charts w/ arrow keys - discussion (257 Views)