#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default Free Cells

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4,339
Default Free Cells

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default Free Cells

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Finding Merged Cells (Part 2) - Free 58k macro Olden Excel Discussion (Misc queries) 0 January 17th 07 12:24 PM
any free add-ins? driller Excel Worksheet Functions 4 November 15th 06 09:27 PM
how do I free units cells? Pineapple m2 New Users to Excel 1 February 17th 06 12:45 PM
Everytime I need to format cells or text, Excel 2003 takes a lot of time or free Florimar Agostini via OfficeKB.com Excel Discussion (Misc queries) 1 April 1st 05 06:29 AM
New - Help - select cells + Free Tutor inventor84 Excel Discussion (Misc queries) 1 March 26th 05 09:58 AM


All times are GMT +1. The time now is 06:59 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"