Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I forgot if tere were any shortcuts to delete free cells between data. I mean
changing this 37966330000 0,722063319 90 60791100000 0,601184523 91 1,05265E+11 0,731593769 92 to this 37966330000 0,722063319 90 60791100000 0,601184523 91 1,05265E+11 0,731593769 92 1,90064E+11 0,805566098 93 |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Dat=Filter on 'Blanks' and then delete blank rows.
"Tsunamic" wrote: I forgot if tere were any shortcuts to delete free cells between data. I mean changing this 37966330000 0,722063319 90 60791100000 0,601184523 91 1,05265E+11 0,731593769 92 to this 37966330000 0,722063319 90 60791100000 0,601184523 91 1,05265E+11 0,731593769 92 1,90064E+11 0,805566098 93 |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thanks A Lot!
"Toppers": Dat=Filter on 'Blanks' and then delete blank rows. "Tsunamic" wrote: I forgot if tere were any shortcuts to delete free cells between data. I mean changing this 37966330000 0,722063319 90 60791100000 0,601184523 91 1,05265E+11 0,731593769 92 to this 37966330000 0,722063319 90 60791100000 0,601184523 91 1,05265E+11 0,731593769 92 1,90064E+11 0,805566098 93 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Finding Merged Cells (Part 2) - Free 58k macro | Excel Discussion (Misc queries) | |||
any free add-ins? | Excel Worksheet Functions | |||
how do I free units cells? | New Users to Excel | |||
Everytime I need to format cells or text, Excel 2003 takes a lot of time or free | Excel Discussion (Misc queries) | |||
New - Help - select cells + Free Tutor | Excel Discussion (Misc queries) |