Landa said:
I got some helpful reply from a user Harlan on how to move several columns of
data into one column. But because of my poor excel skill, I am stuck in the
first step, i.e. to name the selected cells as say TB1
First, a quick correction: .. Harlan is hardly a "user" <g>,
He's a very senior responder / contributor to many newsgroups, an excel
grandmaster / maestro who has posted tens of thousands of responses over the
years!
Ok .. One quick way to define ranges is to use the namebox
(the box with the drop arrow just to the left of the formula bar)
There are 2 defined / named ranges that Harlan describes in his response
One is: Tbl
Select A1:C4, then click inside the namebox
Key-in the name: Tbl, then press ENTER
(Note that the name is spelt: Tbl (with a lowercase "L", not: Tb1)
The 2nd one is : All
Select A1, then click inside the namebox
Key-in the name: All, then press ENTER
The normal way to create defined ranges is via clicking:
Insert > Name > Define
(as pointed by the other responder)
The options are there to create and delete defined ranges
There are also dynamic ranges - defined ranges which expand and contract
automatically - which must be created via this route.
And in case needed,
here's a quick sample implementation of Harlan's response:
http://cjoint.com/?fqj1Uge4fv
Landa_wks.xls
