| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How can I separate rows to the bottom of the page with missing inf
I am still some what new to these Data Sheets and the different types of
functions. Let me show by example what I am trying to do. A B C D E 1DVD MOVIE 16292 14.98 2140497 2140497 2DVD MOVIE 28264 14.98 2133826 2133826 3DVD MOVIE 56428 14.98 2114870 4DVD MOVIE 75638 14.98 2114869 5DVD MOVIE 35482 14.98 2111693 2111693 6DVD MOVIE 18792 14.98 2148557 7DVD MOVIE 27865 14.98 2133826 2133826 Basically I would like to move rows 3,4,6 to the bottom of the list because they are missing the information in column F. Like I said I am still somewhat new on all the features Excel can do and would like any help that you can provide. Thanks in Advance. |
|
#2
|
|||
|
|||
|
Select the table.
Data menu - Sort Sort by Column F, descending order. "Mcobra41" wrote: I am still some what new to these Data Sheets and the different types of functions. Let me show by example what I am trying to do. A B C D E 1DVD MOVIE 16292 14.98 2140497 2140497 2DVD MOVIE 28264 14.98 2133826 2133826 3DVD MOVIE 56428 14.98 2114870 4DVD MOVIE 75638 14.98 2114869 5DVD MOVIE 35482 14.98 2111693 2111693 6DVD MOVIE 18792 14.98 2148557 7DVD MOVIE 27865 14.98 2133826 2133826 Basically I would like to move rows 3,4,6 to the bottom of the list because they are missing the information in column F. Like I said I am still somewhat new on all the features Excel can do and would like any help that you can provide. Thanks in Advance. |
|
#3
|
|||
|
|||
|
Thanks alot that worked great! :)
"Tee" wrote: Select the table. Data menu - Sort Sort by Column F, descending order. "Mcobra41" wrote: I am still some what new to these Data Sheets and the different types of functions. Let me show by example what I am trying to do. A B C D E 1DVD MOVIE 16292 14.98 2140497 2140497 2DVD MOVIE 28264 14.98 2133826 2133826 3DVD MOVIE 56428 14.98 2114870 4DVD MOVIE 75638 14.98 2114869 5DVD MOVIE 35482 14.98 2111693 2111693 6DVD MOVIE 18792 14.98 2148557 7DVD MOVIE 27865 14.98 2133826 2133826 Basically I would like to move rows 3,4,6 to the bottom of the list because they are missing the information in column F. Like I said I am still somewhat new on all the features Excel can do and would like any help that you can provide. Thanks in Advance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Keep rows on same page in Excel | Excel Discussion (Misc queries) | |||
| Greybar at the bottom of the page | Excel Discussion (Misc queries) | |||
| empty rows at bottom of worksheet | Excel Discussion (Misc queries) | |||
| make first few rows print on every page? | New Users to Excel | |||
| how to print a row on the bottom of every page | Excel Discussion (Misc queries) | |||
Linear Mode
