Additional columns

ceelypa · Mar 14th, 2002, 11:45 AM

Is there any way to add extra columns to a spreadsheet above and beyond "IV"? If so, how?

Thx!

dk · Mar 14th, 2002, 12:28 PM

Unfortunately not. If you want to just display data or use very simple formulae then the Microsoft Office Spreadsheet Control (for use on forms or embedded in worksheets) allows up to ZZ (708 columns).

Regards,
D

dk · Mar 14th, 2002, 12:28 PM

Unfortunately not. If you want to just display data or use very simple formulae then the Microsoft Office Spreadsheet Control (for use on forms or embedded in worksheets) allows up to ZZ (708 columns).

Regards,
D

ceelypa · Mar 14th, 2002, 12:53 PM

D,

How do I get to the "Microsoft Office Spreadsheet Control"?

Thanks!
PAC

dk · Mar 14th, 2002, 01:04 PM

Sorry, should have mentioned how to do that. As far as I'm aware it's not installed with all versions of Excel but I know it's in 2000. To add it try this:-

Click View, Toolbars, Control Toolbox. Then click the More Controls button (the one which has a hammer and spanner icon). This will bring up a list of all the ActiveX controls available on your machine. Look for Microsoft Office Spreadsheet and click it. You can then 'draw' the control on a worksheet.

Once you get it you can the program it in all sorts of way, or you can enter directly on it. This is quite a big topic so if you've got any specific questions then post again.

Good luck!

D

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

Mar 14th, 2002, 11:45 AM	#1
ceelypa New Member Join Date: Mar 2002 Posts: 6	Is there any way to add extra columns to a spreadsheet above and beyond "IV"? If so, how? Thx!

Mar 14th, 2002, 12:28 PM	#2
dk MrExcel MVP Join Date: Feb 2002 Location: Sydney, Australia Posts: 2,908	Unfortunately not. If you want to just display data or use very simple formulae then the Microsoft Office Spreadsheet Control (for use on forms or embedded in worksheets) allows up to ZZ (708 columns). Regards, D

Mar 14th, 2002, 12:53 PM	#4
ceelypa New Member Join Date: Mar 2002 Posts: 6	D, How do I get to the "Microsoft Office Spreadsheet Control"? Thanks! PAC

Mar 14th, 2002, 01:04 PM	#5
dk MrExcel MVP Join Date: Feb 2002 Location: Sydney, Australia Posts: 2,908	Sorry, should have mentioned how to do that. As far as I'm aware it's not installed with all versions of Excel but I know it's in 2000. To add it try this:- Click View, Toolbars, Control Toolbox. Then click the More Controls button (the one which has a hammer and spanner icon). This will bring up a list of all the ActiveX controls available on your machine. Look for Microsoft Office Spreadsheet and click it. You can then 'draw' the control on a worksheet. Once you get it you can the program it in all sorts of way, or you can enter directly on it. This is quite a big topic so if you've got any specific questions then post again. Good luck! D