ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How may cells are on one excel spreadsheet? (https://www.excelbanter.com/excel-discussion-misc-queries/135268-how-may-cells-one-excel-spreadsheet.html)

Curious

How may cells are on one excel spreadsheet?
 
Using office 2003 and want to insert the names of all my staff members in my
organisation and I don't know if one spreadsheet will be enough

Roger Govier

How may cells are on one excel spreadsheet?
 
Hi

In XL2003 there are
65,536 rows
256 columns
so the total number of individual cells is
16,777,216

Happy typing<vbg

--
Regards

Roger Govier


"Curious" wrote in message
...
Using office 2003 and want to insert the names of all my staff members
in my
organisation and I don't know if one spreadsheet will be enough




Max

How may cells are on one excel spreadsheet?
 
65536 rows by 256 cols per sheet. With names entered in A2 down, think there
should be enough rows to fit it all in.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Curious" wrote:
Using office 2003 and want to insert the names of all my staff members in my
organisation and I don't know if one spreadsheet will be enough


David Biddulph[_2_]

How may cells are on one excel spreadsheet?
 
.... but if that isn't enough, Excel 2007 has 1048576 rows by 16384 columns.
--
David Biddulph

"Roger Govier" wrote in message
...
Hi

In XL2003 there are
65,536 rows
256 columns
so the total number of individual cells is
16,777,216

Happy typing<vbg

--
Regards

Roger Govier


"Curious" wrote in message
...
Using office 2003 and want to insert the names of all my staff members in
my
organisation and I don't know if one spreadsheet will be enough







All times are GMT +1. The time now is 09:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com