How to delete columns with headings but rows are empty

Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 1

How to delete columns with headings but rows are empty

Hi,
I have data where columns have headings but rows are blank. I have
approx 500 rows of data.

ID Student Course 1 Course 2
2 Tom 0
3 Suzie

Thanks for your assistance

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Hpw do I delete multiple empty rows found between filled rows?	Bill	Excel Worksheet Functions	2	November 15th 09 07:12 PM
Cut filtered rows, paste into next empty row of new sheet, and delete cut rows	Scott	Excel Worksheet Functions	0	December 13th 06 01:25 AM
Delete rows that are empty across columns	ALATL	Excel Worksheet Functions	0	November 6th 06 04:09 AM
Delete rows with empty cells in columns B&C	Richard	Excel Discussion (Misc queries)	3	March 18th 06 12:15 AM
how do i delete the extra empty rows and columns that i dont need.	lindaY	Excel Discussion (Misc queries)	3	March 20th 05 03:48 PM

All times are GMT +1. The time now is 03:54 AM.

Menu

About Us