excel computer training - How big can an excel spreadsheet be?

Resolved · Low Priority · Version Standard

How big can an excel spreadsheet be?

Victoria has attended:
Excel Intermediate course

by - delegate Victoria [1 post] (2007 Sep 14 Fri, 14:18) Reply

as above

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 4 Thu + 5 Fri	Bloomsbury	3	book now	£475	£495
2007	2008 Dec 11 Thu + 12 Fri	Bayswater	4	book now	£499	£530
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	8	book now	£345	£425
2003	2009 Jan 22 Thu + 23 Fri	Southwark	5	book now	£450	£485
2003	2009 Jan 29 Thu + 30 Fri	Bayswater	6	book now	£450	£485
2007	2009 Feb 5 Thu + 6 Fri	Bloomsbury	7	book now	£450	£475
Full Schedule: See all 34 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: How big can an excel spreadsheet be?

by - trainer Anthony gold contributer [113 posts] (2007 Sep 25 Tue, 16:04) Reply

Hi Victoria. Excel workbooks can contain 255 worksheets. In each worksheet, you can have up to 256 columns and 65,536 rows, giving you about 16M cells. Should you so wish!

Hope this helps,

Anthony

· Microsoft Excel Training - Discover A Hidden Power At Your Fingertips
· Creating Smarter, Customized Invoices for your Small Business with Microsoft Excel
· How to Create Better Excel Spreadsheets: Part Two
· How to Create Better Excel Spreadsheets: Part One
· From the Classroom to the Corporate World

Excel tip:

Generating Random Numbers

To generate a random number in Excel use the = RAND() function.

The value returned will always be between 0 and 1. To convert this to some other random value, you will need to multiply the result by the highest number you want to consider. For example, if you wanted a random number between 1 and 25, you could use the following code line:
= INT(25 * RAND()+ 1)

Since RAND() will always returns a value between 0 and 1 (but never 1 itself), multiplying what it returns by 25 and then using the Integer function INT on that result will return a whole number between 0 and 24.

Finally, 1 is added to this result, so that x will be equal to a number between 1 and 25, inclusive

View all Excel hints and tips

Rate this page: