Delete option greyed out when trying to delete row 1

tpcervelo · #1 11-14-2011, 12:13 PM

I have a Excel 2007 workbook that has a SQL query returning 6 fields from a table. I need to delete Row 1 containing the field names so the workbook contains only data. When I right click on Row 1 the 'delete' option is greyed out. The workbook/row is not protected and I have removed the Auto-Filter function. I am able to delete any other row.
Any ideas?
Thanks for any help...

mgonda · #2 11-14-2011, 06:00 PM

Do you have a data connection that is bringing in the sql query? If so that can limit the field manipulation capabilities.

Mark Gonda

tpcervelo · #3 11-15-2011, 06:48 AM

Solved...there is a check box on the Design tab that allows header row to be turned off.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Cannot delete folders	klingenfelter	Outlook	10	02-04-2011 01:35 PM
delete email message via blackberry and have it delete on my pop3 and my outlook	Iamthestorm	Outlook	2	10-28-2010 12:21 AM
Delete sheet through VBA	Salim Khan	Excel	1	08-30-2010 09:11 AM
Some emails will not delete	Shawn76	Outlook	0	07-01-2010 01:33 PM
Needs option to delete foward only when deleting reoccurring	Peter Grono	Outlook	1	02-19-2006 04:22 PM