How to expand coloms beond the last avaliable one in a Worksheet
 

Can anyone tell me how to expand coloms beond the last avaliable one in a
Worksheet?
--
Kjeld K

How to expand coloms beond the last avaliable one in a Worksheet
 

Use another worksheet???

xl2007 offers 16384 columns. Maybe it's time for an upgrade?

KJELDK wrote:

Can anyone tell me how to expand coloms beond the last avaliable one in a
Worksheet?
--
Kjeld K

--

Dave Peterson

How to expand coloms beond the last avaliable one in a Workshe
 

Dave, if thats the case why can't I get more that to the Collum "IV" - What
to do???
--
Kjeld K


"Dave Peterson" skrev:

Use another worksheet???

xl2007 offers 16384 columns. Maybe it's time for an upgrade?

KJELDK wrote:

Can anyone tell me how to expand coloms beond the last avaliable one in a
Worksheet?
--
Kjeld K

--

Dave Peterson

How to expand coloms beond the last avaliable one in a Workshe
 

You're using xl2007?

If yes, make sure you're working on a file that you didn't open in that earlier
"compatibility" mode.

(I don't use xl2007, so you may have to look--or wait for more details from
someone else.)

If you're using xl2003 or earlier, column IV is the last column.

KJELDK wrote:

Dave, if thats the case why can't I get more that to the Collum "IV" - What
to do???
--
Kjeld K

"Dave Peterson" skrev:

Use another worksheet???

xl2007 offers 16384 columns. Maybe it's time for an upgrade?

KJELDK wrote:

Can anyone tell me how to expand coloms beond the last avaliable one in a
Worksheet?
--
Kjeld K

--

Dave Peterson


--

Dave Peterson

How to expand coloms beond the last avaliable one in a Workshe
 

You can only get more than 256 columns if you have Excel 2007. Even if you
do old workbooks open in 'compatibility mode' and still display only 256.
Pick "Convert" from the Office menu to upgrade the workbook into the newer
format and you'll get all 16K columns.

--
Jim
"KJELDK" wrote in message
...
| Dave, if thats the case why can't I get more that to the Collum "IV" -
What
| to do???
| --
| Kjeld K
|
|
| "Dave Peterson" skrev:
|
| Use another worksheet???
|
| xl2007 offers 16384 columns. Maybe it's time for an upgrade?
|
| KJELDK wrote:
|
| Can anyone tell me how to expand coloms beond the last avaliable one
in a
| Worksheet?
| --
| Kjeld K
|
| --
|
| Dave Peterson
|

How to expand coloms beond the last avaliable one in a Workshe
 

Thanks Dave - I'll have to wait for someone else to give me the magic answer!
Have a nice day
--
Kjeld K


"Dave Peterson" skrev:

You're using xl2007?

If yes, make sure you're working on a file that you didn't open in that earlier
"compatibility" mode.

(I don't use xl2007, so you may have to look--or wait for more details from
someone else.)

If you're using xl2003 or earlier, column IV is the last column.

KJELDK wrote:

Dave, if thats the case why can't I get more that to the Collum "IV" - What
to do???
--
Kjeld K

"Dave Peterson" skrev:

Use another worksheet???

xl2007 offers 16384 columns. Maybe it's time for an upgrade?

KJELDK wrote:

Can anyone tell me how to expand coloms beond the last avaliable one in a
Worksheet?
--
Kjeld K

--

Dave Peterson


--

Dave Peterson

How to expand coloms beond the last avaliable one in a Workshe
 

If you're using XL 2007 in compatibility mode you will see columns to IV. If
you're using XL 2007 in 2007 mode, you will see 16000+ columns.

Dave
--
Brevity is the soul of wit.


"Dave Peterson" wrote:

You're using xl2007?

If yes, make sure you're working on a file that you didn't open in that earlier
"compatibility" mode.

(I don't use xl2007, so you may have to look--or wait for more details from
someone else.)

If you're using xl2003 or earlier, column IV is the last column.

KJELDK wrote:

Dave, if thats the case why can't I get more that to the Collum "IV" - What
to do???
--
Kjeld K

"Dave Peterson" skrev:

Use another worksheet???

xl2007 offers 16384 columns. Maybe it's time for an upgrade?

KJELDK wrote:

Can anyone tell me how to expand coloms beond the last avaliable one in a
Worksheet?
--
Kjeld K

--

Dave Peterson


--

Dave Peterson

How to expand coloms beond the last avaliable one in a Workshe
 

"What to do" is to look again at what version of Excel you've got, and at
Dave's answer.

The answer was that xl2007 has 16384 columns. You have timed your enquiry
very well, as Office 2007 went on sale yesterday.
--
David Biddulph

"KJELDK" wrote in message
...
Dave, if thats the case why can't I get more that to the Collum "IV" -
What
to do???

"Dave Peterson" skrev:

Use another worksheet???

xl2007 offers 16384 columns. Maybe it's time for an upgrade?

KJELDK wrote:

Can anyone tell me how to expand coloms beond the last avaliable one in
a
Worksheet?

How to expand coloms beond the last avaliable one in a Workshe
 

You'll wait a long time.
The Answers have been given.

Steve

On Wed, 31 Jan 2007 18:03:02 -0000, KJELDK
wrote:

Thanks Dave - I'll have to wait for someone else to give me the magic
answer!
Have a nice day