| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
EXTENSION OF EXCEL SHEET COLUMNS BEYOND IV GRID
In worksheet I want to insert more column, but I can't do d same beyond grid
IV (Ato IV). Is there any way? so that I can insert more columns as I desire!! waiting for Ur immeD8 response! Jayanta Pramanik |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
EXTENSION OF EXCEL SHEET COLUMNS BEYOND IV GRID
If you're using Excel versions 2003 or earlier the number of columns per
worksheet is 256 and can not be expanded. Excel 2007 has more than 16,000 columns and 1 million rows. -- Biff Microsoft Excel MVP "Jayanta Pramanik" <Jayanta wrote in message ... In worksheet I want to insert more column, but I can't do d same beyond grid IV (Ato IV). Is there any way? so that I can insert more columns as I desire!! waiting for Ur immeD8 response! Jayanta Pramanik |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
EXTENSION OF EXCEL SHEET COLUMNS BEYOND IV GRID
Upgrading to Excel 2007 is the only way.
-- Regards Dave Hawley www.ozgrid.com "Jayanta Pramanik" <Jayanta wrote in message ... In worksheet I want to insert more column, but I can't do d same beyond grid IV (Ato IV). Is there any way? so that I can insert more columns as I desire!! waiting for Ur immeD8 response! Jayanta Pramanik |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
EXTENSION OF EXCEL SHEET COLUMNS BEYOND IV GRID
Sorry you cannot. The number of columns in XL2003 is limited to 256.
XL2003 Worksheet size 65,536 rows by 256 columns XL2007 Worksheet size 1,048,576 rows by 16,384 columns -- Jacob (MVP - Excel) "Jayanta Pramanik" wrote: In worksheet I want to insert more column, but I can't do d same beyond grid IV (Ato IV). Is there any way? so that I can insert more columns as I desire!! waiting for Ur immeD8 response! Jayanta Pramanik |
|
#5
|
|||
|
|||
Quote:
here are workarounds #1. delete un necessary columns at left side say AA, AB and insert columns left hand side of IV #2. migrate to excel 2007. all the best
__________________
Thanks Bala |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
EXTENSION OF EXCEL SHEET COLUMNS BEYOND IV GRID
On 5/18/2010 9:47 PM, Jayanta Pramanik wrote:
In worksheet I want to insert more column, but I can't do d same beyond grid IV (Ato IV). Is there any way? so that I can insert more columns as I desire!! waiting for Ur immeD8 response! Jayanta Pramanik How many rows of data does your worksheet have? If it's less than 256 you could transpose rows and columns. Otherwise you'll need to redesign your worksheet or upgrade as suggested. In more than 20 years of using spreadsheets I've never gone beyond 52 columns. YMMV. Bill |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 - "Snap To Grid" doesn't work on same grid line | Excel Discussion (Misc queries) | |||
| Grid lines in Excel not showing.Have tools,options,view/grid cked | Excel Discussion (Misc queries) | |||
| Excel spread sheet will not print with grid lines. | Excel Worksheet Functions | |||
| I need to convert grid.doc to an Excel Grid. | Charts and Charting in Excel | |||
| How can I shade columns but keep grid? | Excel Discussion (Misc queries) | |||
Hybrid Mode
