| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 spreadsheet - blank rows
I imported telephone records (text file) into excel and when it was brought
over, every other row is empty/blank. How do I delete every other row of this spreadsheet? Want to thank you all in advance...this is such a great resource and I appreciate all the help and quick responses. Thank you! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2007 spreadsheet - blank rows
Pick a typical column, say column A. Switch on AutoFilter and select blanks.
Then delete the visible rows. -- Gary''s Student - gsnu200905 "pc4n6" wrote: I imported telephone records (text file) into excel and when it was brought over, every other row is empty/blank. How do I delete every other row of this spreadsheet? Want to thank you all in advance...this is such a great resource and I appreciate all the help and quick responses. Thank you! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2007 spreadsheet - blank rows
Hello can you help me figure out how or what the sign is for subtract in
formatting a column that has ex. a4:a10 and then i want to subtract e4??? Thanks "pc4n6" wrote: I imported telephone records (text file) into excel and when it was brought over, every other row is empty/blank. How do I delete every other row of this spreadsheet? Want to thank you all in advance...this is such a great resource and I appreciate all the help and quick responses. Thank you! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2007 spreadsheet - blank rows
- is the sign for subtract.
-- David Biddulph "tom" wrote in message ... Hello can you help me figure out how or what the sign is for subtract... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Removing Blank Rows in an excel spreadsheet | Excel Discussion (Misc queries) | |||
| Commas generated in csv files for blank rows in Excel 2007 | Excel Discussion (Misc queries) | |||
| How to delete blank rows at one time in a long excel spreadsheet? | Excel Worksheet Functions | |||
| Im trying to remove blank rows in an Excel spreadsheet Printout | Excel Worksheet Functions | |||
| How do I remove numerous blank rows from Excel spreadsheet? | Excel Discussion (Misc queries) | |||
Linear Mode
