Error in Excel workbook

%3CLINGO-SUB%20id%3D%22lingo-sub-3096797%22%20slang%3D%22en-US%22%3EError%20in%20Excel%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3096797%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20an%20excel%20workbook%20with%20pivot%20tables.%20The%20source%20data%20worksheet%20I%20made%20a%20mistake%20with%20and%20formatted%20to%20table%20without%20identifying%20area.%20I%20just%20spent%206%20hours%20ridding%20columns%20but%20can't%20get%20the%20rows%20deleted.%20(1M%2B)%20can%20you%20advise%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3096797%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3099935%22%20slang%3D%22en-US%22%3EBetreff%3A%20Error%20in%20Excel%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3099935%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1293027%22%20target%3D%22_blank%22%3E%40Rosealee%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3EWithout%20the%20Excel%20file%2C%20it%20is%20difficult%20to%20assess%20whether%20and%20what%20kind%20of%20error%20there%20may%20be.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3EJust%20into%20the%20blue%2C%20I%20would%20recommend...%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3ESelect%20the%20first%20row%20from%20the%20top%20you%20want%20to%20delete%20by%20clicking%20on%20the%20number%20of%20the%20row.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3EPress%20Ctrl%20%2B%20Shift%20%2B%20Down%20Arrow%20...%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3Ethis%20will%20select%20all%20rows%20down.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3EThen%20right%20click%20and%20select%20%22Delete%20Cells%22%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3E%3CSPAN%3Eall%20selected%20rows%20will%20be%20deleted.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3EHope%20I%20could%20help%20you%20with%20that.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel-blog%2Fmeet-niko-chatzoudis-excel-forum-contributor%2Fba-p%2F2941385%22%20target%3D%22_blank%22%3ENikolinoDE%3C%2FA%3E%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I have an excel workbook with pivot tables. The source data worksheet I made a mistake with and formatted to table without identifying area. I just spent 6 hours ridding columns but can't get the rows deleted. (1M+) can you advise?

1 Reply

@Rosealee 

Without the Excel file, it is difficult to assess whether and what kind of error there may be.

Just into the blue, I would recommend...

Select the first row from the top you want to delete by clicking on the number of the row.

Press Ctrl + Shift + Down Arrow ...this will select all rows down.

Then right click and select "Delete Cells" all selected rows will be deleted.

 

Hope I could help you with that.

 

NikolinoDE

I know I don't know anything (Socrates)