Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 36
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,886
Default 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



  #3   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default 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

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,651
Default 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





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
IS THERE A WAY TO HAVE CELLS IN AN EXCEL SPREADSHEET REQUIRE DATA? LAKEISHA M. Excel Worksheet Functions 3 August 4th 06 07:24 PM
Slanting cells across top of Word table or Excel spreadsheet? Capital Park FHC - Donna Setting up and Configuration of Excel 1 July 15th 06 01:59 AM
The cursor on my Excel spreadsheet is not selecting cells. auberginewellies Excel Discussion (Misc queries) 2 March 20th 06 06:36 PM
copy & paste spreadsheet cells from excel to outlook to excel mismarple Excel Discussion (Misc queries) 1 September 20th 05 11:16 PM
How do I password protect cells in a spreadsheet created in Excel [email protected] Excel Worksheet Functions 0 November 22nd 04 09:21 PM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"