Home |
Search |
Today's Posts |
#1
|
|||
|
|||
max rows on an Excel worksheet
I thought the maximum number of rows available on an Excel
spreadsheet was 65,536. But recently I was told the number of rows could be increased by decreasing the number of columns. Is that true? If so, how is it done. Sorry if this question has been asked before, I tried searching the site for others who might have asked this question, but the search feature is off. vbJenny |
#2
|
|||
|
|||
Hi
Sorry, your informant is incorrect. 65,536 is all you get. One option if you need more is to spread your data over a number of sheets and create a summary sheet to bring totals an other information back together. HTH Michael "vbjenny" wrote: I thought the maximum number of rows available on an Excel spreadsheet was 65,536. But recently I was told the number of rows could be increased by decreasing the number of columns. Is that true? If so, how is it done. Sorry if this question has been asked before, I tried searching the site for others who might have asked this question, but the search feature is off. vbJenny |
#3
|
|||
|
|||
"Michael" wrote in message ... One option if you need more is to ... use a database |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merging data from an excel worksheet into an excel template | Excel Worksheet Functions | |||
Weekly Transaction Processing | Excel Worksheet Functions | |||
How do I unhide rows 1 through 28 on an Excel worksheet? | Excel Worksheet Functions | |||
How do I replace a worksheet with another worksheet in excel | Excel Worksheet Functions | |||
Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) |