When dealing with large data sets, there are several ways you can delete individual rows as well as thousands.

Here we are going to demonstrate several ways this can be done.

Wouldnt it be better if you could spend a little less time navigating, formatting, and entering formulas for the data.

Wouldnt it be better if you could spend a little less time navigating, formatting, and entering formulas for the data Hence weve put together a list of keyboard shortcuts for Microsoft Excel.

I founded my own digital agency, Startup Cafe Digital, in 2015 where I help SMBs leverage social media, SEO, and content marketing to grow their traffic and generate qualified leads for their business.

The goal was simple: to arm other solopreneurs with all the right information and tools they needed to launch a successful online business.

If you purchase a product or service through one of these affiliate links, Ill receive a commission at no additional cost to you.

In most cases, youll find in-depth reviews, tutorials, and how-to guides of these tools on my blog to help you make informed decisions.

Excel Delete Row Shortcut How To Hide Rows

But i found you by searching how to hide rows and columns with short keys.

However, they are the starting point for performing a lot of other actions where you first need to select the entire row or column.

This includes tasks like deleting rows, grouping columns, etc.

Press ShiftSpace a second time and it will select the entire row in the worksheet.

Pressing the keyboard shortcut a second time will include the column header of the Table in the selection.

Pressing CtrlSpace a third time will select the entire column in the worksheet.

If you are using a laptop keyboard you can press CtrlShift (equal sign).

For me it is easier to first select the entire row or column, then press Ctrl or Ctrl-.

You could also use the keyboard shortcut AltHDC to delete columns and AltHDR to delete rows.

AutoFit means that the width of the column will be adjusted to fit the contents of the cell.

To accomplish this you can use the AutoFit Column Width button.

So the column width will be adjusted to fit the contents of A4, as shown in the results below.

It doesnt work exactly the same as column width, and will only adjust the row height to the tallest cell in the entire row.

Excel Delete Row Shortcut Mac Version Does

The Mac version does not use the Alt key sequence which I believe is a limitation of the Mac OS.

You can also modify a Windows setting to prevent the conflict with this shortcut.

See the comment from Pablo Baez on Oct 5, 2015 below for further instructions.

You can hover over any of the items in the menu and the keyboard shortcut will display in the screentip (see screenshot below).

I first select cell B2:B5, cells that surround or cover the hidden rows, then press CtrlShift( to unhide the rows.

This is the same as pressing the Clear Outline button on the Ungroup menu of the Data tab on the Ribbon.

This is a Windows shortcut that orientates the entire screen to the right.

What are some of your favorites Please leave a comment below.

Thanks.

Excel For Mac Delete Row Shortcut