1-step shortcut to delete entire row in excel 2016

0 votes

I want to fast remove rows from a CSV that has a few thousand entries.

Control + - gave me the following menu when I tried it:

enter image description here

Although it may seem insignificant, I'd really prefer this shortcut to just skip the menu and immediately erase the entire row because I'll be erasing a lot of rows. Is there a different shortcut that deletes the complete row, or a different technique to make this shortcut erase the entire row by default?

Oct 22, 2022 in Others by Kithuzzz
• 38,000 points
575 views

1 answer to this question.

0 votes
Highlight the whole row by clicking on the row number to the left and hit Ctrl -
answered Oct 22, 2022 by narikkadan
• 63,600 points

Related Questions In Others

0 votes
0 answers

Shortcut to insert row in excel

What is the Excel shortcut for inserting ...READ MORE

Sep 7, 2023 in Others by anonymous
• 990 points
344 views
0 votes
0 answers

What is the shortcut key to delete sheet in Excel?

Could someone tell me what is the ...READ MORE

Sep 8, 2023 in Others by Satyawrat
• 460 points
368 views
0 votes
1 answer

Excel-VBA - How to identify Target range (more than 1 cell) is deleted in a Worksheet_Change function?

You misunderstand the purpose of the function ...READ MORE

answered Sep 23, 2022 in Others by narikkadan
• 63,600 points
3,720 views
0 votes
1 answer

How to print an Excel Sheet using VBA with Nitro PDF Creator in Excel 2016

you can use the built-in excel facilities ...READ MORE

answered Sep 24, 2022 in Others by narikkadan
• 63,600 points
1,347 views
0 votes
2 answers

How to copy a formula horizontally within a table using Excel VBA?

Hi so basically, create an adjacent column ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,690 points
1,053 views
0 votes
1 answer

INDEX formula in Excel, Top 10, repeats previous value

Try this formula in cell W4: =IF(V3=V4,INDEX(INDIRECT("I"&MATCH(W3,I:I,0)+1&":I26"),MATCH(V4,INDIRECT("R"&MATCH(W3,I:I,0)+1&":R26"),0)),INDEX($I$2:$I$26,MATCH(V4,$R$2:$R$26,0))) The calculation ...READ MORE

answered Oct 8, 2022 in Others by narikkadan
• 63,600 points
995 views
0 votes
1 answer

How to "Print" Excel Sheet on Custom Page Size like Din A1?

Try turning the pdf file into an ...READ MORE

answered Oct 11, 2022 in Others by narikkadan
• 63,600 points
2,201 views
0 votes
1 answer

ISBLANK returns False for empty cells having Formulas

ISBLANK will return TRUE only when a ...READ MORE

answered Nov 8, 2022 in Others by gaurav
• 23,260 points
1,552 views
0 votes
1 answer

Shortcut to Apply a Formula to an Entire Column in Excel

Try double-clicking on the bottom right hand ...READ MORE

answered Oct 29, 2022 in Others by narikkadan
• 63,600 points
483 views
0 votes
1 answer

How to access entire row by cell address or value in excel?

You may accomplish all of this by ...READ MORE

answered Dec 28, 2022 in Others by narikkadan
• 63,600 points
1,392 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP