excel computer training - how big can excel

AI Training: For Busy Decision Makers & Professionals Book now

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel computer training - How big can an excel spreadsheet be?

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

resolvedResolved · Low Priority · Version Standard

Victoria has attended:
Excel Intermediate course

How big can an excel spreadsheet be?

as above

RE: How big can an excel spreadsheet be?

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


 

Excel tip:

Sorting List Subtotals

If you find that you would prefer to show the items in a subtotalled list in a different order, eg ascending rather than descending, you can sort your list. To sort a subtotalled list, hide the detail rows and then sort the subtotal rows. When you sort a subtotalled list, the hidden detail rows are automatically moved with the subtotal rows.
IMPORTANT: If you do not hide the details rows before sorting a subtotalled list, your subtotals will be removed and all of the rows in your list will be reordered.

View all Excel hints and tips


Server loaded in 0.11 secs.