Re: I have over 16000 rows & it treats it like 2 tables???
Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance
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.
.
Relevant Pages
- Just a thank you from someone also helped by this
... It's these little bits of help here and there that help people like myself go from viewing Excel as taking up valuable disk space to being a really useful application that can save time and money in any number of ways. ... So I suppose I need to sort the entire sheet, not just the date column, ... I need to have my sheet setup to automatically sort data every time I ... I do not know what your ranges are so can't speak to that. ...
(microsoft.public.excel) - Just a thank you from someone also helped by this
... It's these little bits of help here and there that help people like myself go from viewing Excel as taking up valuable disk space to being a really useful application that can save time and money in any number of ways. ... So I suppose I need to sort the entire sheet, not just the date column, ... I need to have my sheet setup to automatically sort data every time I ... I do not know what your ranges are so can't speak to that. ...
(microsoft.public.excel) - Re: Le Ventoux (encore!)
... We conceal once, add correctly, then assist as well as the sheet ... sort of the chapel. ... Zephram, have a normal squadron. ...
(rec.arts.poems) - Re: Rearranging and organizing data imbedded in rows
... The following macro will move the data to another sheet and set it out in the format you require. ... Alf+F11 to return to Excel ... I can use the list and sort features. ... the existing spreadsheet so I can sort and perform frequency analysis on the ...
(microsoft.public.excel.misc) - RE: HELP! How do you--> Lock a set of rows but also link worksheet
... Row 1 is always at the top of the sheet, regardless of the sort. ... Excel is rearranging data vertically. ... Selecting everything in the sheet tells Excel to sort everything. ... If you select only a single cell before performing the sort, ...
(microsoft.public.excel.misc) |
|
