Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Outlook 2003 How to Remove Blank Lines

Status
Not open for further replies.
JohnBates

JohnBates

MIS
Feb 27, 2000
1,995
US
hi experts,

I have an Excel 2003 worksheet with 1000 rows. Some rows are blank.

How can I remove the rows that have blank/null values in the column?

Thanks, John
 
Sort by date Sort by votes
Hi JohnBates,
You can sort on the column with blanks. That puts all the blanks together. Then you can delete them all at once.
HTH,


Best,
Blue Horizon [2thumbsup]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

T
Can I move My Apple Mail Emails to Outlook?
Replies
2
Views
531
PatrickRoggers
PatrickRoggers
E
  • Locked
  • Question
Extract lines from table into new table
Replies
2
Views
610
SkipVought
S
S
  • Question
MS Project - how to add a new task into an existing baseline
Replies
0
Views
99
selazar
S
R
  • Locked
  • Question
Issues with Outlook default account and performance
Replies
0
Views
475
radleymartinez
R
AndrewMozley
  • Locked
  • Question
Remove recently used symbol
Replies
8
Views
637
Deniall
Deniall

Part and Inventory Search

Sponsor

Back
Top