| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I have over 16000 rows & it treats it like 2 tables???
I can't sort all the information of format the enitre table a a whole. It is
treating it as two seperate tables on one sheet. When I select the entire document, it will not allow me to sort at all. i can only sort the first 5975 and then I have to put the cursor in another row below those and then sort again. All of the information in this sheet has been pulled copied and pasted from several different spreadsheets. Help to me to have one sheet with one table of information that can have all the same properties and commands applied at the same time as a whole. Thank you. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I have over 16000 rows & it treats it like 2 tables???
Rows and more rows! wrote:
I can't sort all the information of format the enitre table a a whole. It is treating it as two seperate tables on one sheet. When I select the entire document, it will not allow me to sort at all. i can only sort the first 5975 and then I have to put the cursor in another row below those and then sort again. All of the information in this sheet has been pulled copied and pasted from several different spreadsheets. Help to me to have one sheet with one table of information that can have all the same properties and commands applied at the same time as a whole. Thank you. Is there a completely blank row separating the two parts of your table? If so, you need to delete it. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| When using an IF-formula, my diagram treats empty cells as zero | Excel Discussion (Misc queries) | |||
| Paste special treats cells as a picture | Excel Discussion (Misc queries) | |||
| error: OBE-15502 Can only have 16000 per document | Excel Discussion (Misc queries) | |||
| Pivot Tables: How do I show ALL field rows, including empty rows?? | Excel Worksheet Functions | |||
| Unlinked Chart Treats Time Axis As Value - Any Fix? | Charts and Charting in Excel | |||
Linear Mode
