ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel 2007 spreadsheet - blank rows (https://www.excelbanter.com/excel-discussion-misc-queries/243890-excel-2007-spreadsheet-blank-rows.html)

pc4n6

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!

Gary''s Student

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!


tom

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!


David Biddulph[_2_]

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...





All times are GMT +1. The time now is 04:24 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com