Thread: How to manage some sheets and sub-sheets?
View Single Post
 
Old 11-15-2015, 03:56 AM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,379
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
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]
Reply With Quote