Expanding the Excel Workbook

sean98 · Apr 5th, 2002, 10:31 AM

Is there a way of expanding the workbook beyond column IV, which I believe is the last column as it seems to be the end column in every workbook I am using.

I tried running a search on this site but it continues to result in errors so I apologize if this question has been answered previously.

Any thoughts would be appreciated.

Thanks
Sean

[ This Message was edited by: sean98 on 2002-04-05 09:35 ]

dan2 · Apr 5th, 2002, 10:38 AM

Sean

IV is the last column for excel.

If you need anything bigger then I beleive the only way is to tie to other sheets or workbooks.

Other than that I think Lotus has more columns if you want to change programs.

HTH

Dan.

Jack in the UK · Apr 6th, 2002, 09:29 AM

Hi

If you short of columns remeber you could transpose

or split over more than one sheet.

dk · Apr 6th, 2002, 10:23 AM

The Office Spreadsheet control (which is basically a cut down version of a normal Excel worksheet) has 702 columns. You could use it to store data and then extract into a regular worksheet for more advanced manipulation of the data.

There's plenty of info on the net - type Microsoft Office Spreadsheet Control into a search engine. If you have any problems please post back.

Regards,
Dan

Apr 6th, 2002, 09:29 AM	#3
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	Hi If you short of columns remeber you could transpose or split over more than one sheet. __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 5th, 2002, 10:31 AM	#1
sean98 New Member Join Date: Apr 2002 Location: Ontario Posts: 26	Is there a way of expanding the workbook beyond column IV, which I believe is the last column as it seems to be the end column in every workbook I am using. I tried running a search on this site but it continues to result in errors so I apologize if this question has been answered previously. Any thoughts would be appreciated. Thanks Sean [ This Message was edited by: sean98 on 2002-04-05 09:35 ]

Apr 5th, 2002, 10:38 AM	#2
dan2 Board Regular Join Date: Mar 2002 Posts: 60	Sean IV is the last column for excel. If you need anything bigger then I beleive the only way is to tie to other sheets or workbooks. Other than that I think Lotus has more columns if you want to change programs. HTH Dan.

Apr 6th, 2002, 10:23 AM	#4
dk MrExcel MVP Join Date: Feb 2002 Location: Sydney, Australia Posts: 2,908	The Office Spreadsheet control (which is basically a cut down version of a normal Excel worksheet) has 702 columns. You could use it to store data and then extract into a regular worksheet for more advanced manipulation of the data. There's plenty of info on the net - type Microsoft Office Spreadsheet Control into a search engine. If you have any problems please post back. Regards, Dan