How to delete unwanted rows in Excel 365

%3CLINGO-SUB%20id%3D%22lingo-sub-1843449%22%20slang%3D%22en-US%22%3EHow%20to%20delete%20unwanted%20rows%20in%20Excel%20365%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1843449%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20do%20get%20back%20to%20row%201%20in%20my%20spreadsheet%20and%20then%20delete%20rows%2060%20to%20the%20max%20rows%20available%20in%20a%20spreadsheet.%26nbsp%3B%20Please%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1843449%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1843491%22%20slang%3D%22de-DE%22%3ESubject%3A%20How%20to%20delete%20unwanted%20rows%20in%20Excel%20365%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1843491%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F854039%22%20target%3D%22_blank%22%3E%40debelljr%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EWhat%20exactly%20(which%20lines)%20you%20want%20to%20delete%20(whether%20table%20or%20simply%20empty%2C%20etc.)%20I%20cannot%20see%20from%20the%20translation%20and%20your%20text.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22%22%3ETherefore%20w%3C%2FSPAN%3E%3C%2FSPAN%3Eith%20your%20permission%2C%20if%20I%20can%20recommend.%20It%20can%20help%20us%20all%20if%20you%20upload%20an%20Excel%20file%20(without%20sensitive%20data).%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EDescribe%20exactly%20what%20the%20problem%20is.%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3EYour%20description%20should%20be%20able%20to%20answer%20the%20following%20questions%3A%20Where%20did%20the%20problem%20occur%20(operating%20system%2C%20Office%20application)%3F%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EWhich%20version%20is%20your%20application%20(office%20version%20e.g.%202016%20or%202019%20or%20365%20web%20or%20365%20pro%2C%20etc)%20and%20your%20operating%20system%20(e.g.%20Win10%20(2004)%2C%20Win%2010%20(1903)%2C%20Mac%2C%20etc.)%3F%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EWhen%20is%20or%20does%20the%20problem%20always%20arise%3F%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EDoes%20it%20only%20happen%20in%20this%20application%20(e.g.%20Excel)%20or%20only%20in%20this%20workbook%2C%20worksheet%3F%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EThis%20means%20that%20an%20outsider%20can%20better%20understand%20your%20problem%20and%20offer%20you%20a%20better%20solution.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E-----------------------------------%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EHere%20are%20some%20possible%20solutions%2C%20as%20far%20as%20I%20could%20see%20from%20your%20description.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EOptions%20to%20delete%20the%20lines%3A%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EExcel%3A%20Delete%20all%20empty%20lines%20and%20unnecessary%20lines%20from%20a%20list%201.%3C%2FSPAN%3E%20%3CSPAN%3EManually%3A%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22%22%3Emark%20the%20lines%20on%20the%20left%20in%20the%20numbering%20and%20then%20press%20Remove%20(deletes%20the%20text)%20or%20with%20the%20right%20mouse%20button-%26gt%3B%20remove%20lines%3C%2FSPAN%3E%3CBR%20%2F%3Ethis%20works%20very%20quickly%20with%20a%3CSPAN%3Esmall%2C%20limited%20number%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3E2)%20Mark%20and%20filter%20columns%3C%2FSPAN%3E%3CBR%20%2F%3EYou%20can%20mark%20the%20columns%20and%20then%20click%20on%20the%20filter%20and%20then%3CSPAN%3Eremove.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EUnfortunately%2C%20only%20the%20cell%20contents%2C%20i.e.%20the%20text%2C%20are%20then%20removed%2C%20but%20not%20the%20lines%20themselves.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%20%3CSPAN%3E3)%20Filter%20table%20and%20transfer%20area%3C%2FSPAN%3E%3CBR%20%2F%3Econvert%20to%20table%3CSPAN%3E-%26gt%3B%20remove%20filters-%26gt%3B%20transfer%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20understanding%20and%20patience%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

How do get back to row 1 in my spreadsheet and then delete rows 60 to the max rows available in a spreadsheet.  Please help.

 

1 Reply
Highlighted

@debelljr 

What exactly (which lines) you want to delete (whether table or simply empty, etc.) I cannot see from the translation and your text.

Therefore w
ith your permission, if I can recommend. It can help us all if you upload an Excel file (without sensitive data).

Describe exactly what the problem is. Your description should be able to answer the following questions: Where did the problem occur (operating system, Office application)?
Which version is your application (office version e.g. 2016 or 2019 or 365 web or 365 pro, etc) and your operating system (e.g. Win10 (2004), Win 10 (1903), Mac, etc.)?
When is or does the problem always arise?
Does it only happen in this application (e.g. Excel) or only in this workbook, worksheet?

This means that an outsider can better understand your problem and offer you a better solution.

 

-----------------------------------

Here are some possible solutions, as far as I could see from your description.

Options to delete the lines:

Excel: Delete all empty lines and unnecessary lines from a list 1. Manually:
mark the lines on the left in the numbering and then press Remove (deletes the text) or with the right mouse button-> remove lines
this works very quickly with a small, limited number

2) Mark and filter columns
You can mark the columns and then click on the filter and then remove.
Unfortunately, only the cell contents, i.e. the text, are then removed, but not the lines themselves.

3) Filter table and transfer area
convert to table -> remove filters-> transfer

 

Thank you for your understanding and patience

 

 

Nikolino

I know I don't know anything (Socrates)