English Deutsch Français Italiano Español Português 繁體中文 Bahasa Indonesia Tiếng Việt ภาษาไทย
All categories

3 answers

When you have an empty sheet and press CTRL + down arrow you will reach the end of that sheet which is 65536 rows
And CTRL + right arrow will jump to the end of it in 256 columns (column IV)
so we have 256 cols x 65536 rows
This is right for Excel 2003 and below
Excel 12, or excel 2007 will have 1 million rows and 1 millions cols
Inserting rows and cols will shift the rows and columns to go outside the sheet, so you can insert as long as you have empty rows and columns

No of sheets depend on the memory (RAM) you have, I had a file with 400 sheets at one time, but it was hard to open it because it takes too long time to do.

XLMan

2006-08-30 00:01:23 · answer #1 · answered by Anonymous · 0 0

256 col
&
65536 row

2006-08-28 22:46:53 · answer #2 · answered by amr_osama 3 · 0 0

press the arrow key and count

2006-08-28 22:06:56 · answer #3 · answered by Red Scorpion 3 · 0 0

fedest.com, questions and answers