Browsing the blog archives for July, 2007
Keywords: cell formatting, two values in one cell, average value, confidence interval
Version: Should work in any Excel version from Excel 97 and forward.
Sometimes it is useful to have the output from your excel sheets arranged in such a way that you can cut and paste directly into your Word file (report, paper och whatever it [...]
Popularity: 6% [?]
When you buy an external HD casing and a new hard drive you will notice after assembling drive and casing that it’s not quite plug n’ play, but initialization and formatting is neede to make it work properly and show up in for example Windows Explorer.
1. Go to the Start menu and open the Control [...]
Popularity: 2% [?]
Keywords: Excel automation, VB controls, scrollbars
Version: Excel 97 or later
Let have a look at the VB controls in Excel. They can be quite handy when creating user oriented spreadsheets, or when building models to study relationships between parameters. In this article we will look at a simple scrollbar control.
1. For the purpose of this tutorial, [...]
Popularity: 3% [?]
