|
|
#6
11-15-2015, 03:56 AM
|
||||
|
||||
In Excel 2007 & later, the maximum worksheet size is 1,048,576 rows by 16,384 columns, meaning it has 64 times as many rows as columns. The normal way of populating workbooks with periodic data is to lay it out with columns for the data types and rows for the periodic data. Your existing data can probably be transposed to conform to that layout. There are many advantages to using the normal layout, including being easier to traverse, analyse, tec.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Excel sheets
|
ubns | Excel | 4 | 04-15-2012 10:48 PM |
| Copying sheets | DavidSNPCPA | Excel | 2 | 01-19-2012 03:54 AM |
| Balance from different sheets | andre | Excel | 0 | 11-29-2011 02:36 PM |
| Linking sheets to fetch transactions from sheets to another | waqer | Excel | 4 | 09-01-2011 12:35 PM |
|
Repeated Cells in different sheets
|
mhdagtas | Excel | 2 | 04-27-2011 12:02 AM |
Windows 7 64bit 
Office 2010 32bit
Threaded Mode