Below are some main metrics for Microsoft Excel:-
Microsoft Excel 7.0 (95)
Maximum Sheet Size: 16,384 rows by 256 columns
Column Width: 0 to 255 characters
Maximum length of cell contents (text): 255 characters
Microsoft Excel 8.0 (97)
Maximum Sheet Size: 65,536 rows by 256 columns
Column Width: 0 to 255 characters
Maximum length of cell contents (text): 32,000 characters
Microsoft Excel 2000, 2002 and 2003
Worksheet size: 65,536 rows by 256 columns
Column Width: 255 characters
Length of cell contents (text): 32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar.
Setting Excel Range
The Excel Range field will now take additional options as well as Named Ranges.
Here are some examples:
=Sheet1!$B$2:$D$4
=Sheet1!$AC$17:$AF$20
=Sheet1
=Sheet1:August
=Sheet1:'Another One'
='Another One'
='Another One'!
=Sheet1:August!$AC$17:$AF$20
=Sheet1:August!AC17:AF20
=!AC17:AF20
=(sheet-range)!(cell-range)
where both sheet-range and cell-range are optional, if they are not supplied the default sheet range is all sheets and the default cell range is all cells.
sheet-range:
Either a single sheet name or two sheet names separated by a colon. If the sheet name includes spaces it must be put in single quotes. Single quotes may be used around any sheet name.
cell-range:
The $ symbols are ignored if present, they are used by Excel to define absolute versus relative ranges. Our values are all absolute (in effect relative ones are relative to the origin).