Saturday, December 10, 2022
HomeTechnologyThe best keyboard shortcuts for rows and columns in Microsoft Excel

The best keyboard shortcuts for rows and columns in Microsoft Excel


Logos of the Microsoft Office component Excel on a heap. Copy space. Web banner format.
Picture: Andreas Prott/Adobe Inventory

Everybody desires to work effectively so studying methods to do small duties faster is at all times a win. All the Workplace apps provide built-in keyboard shortcuts that cut back duties to a mere keyboard shortcut. A keyboard shortcut is a mixture of key presses. Most of them start with the Shift or Ctrl key and some use each. You press and maintain down the primary key, normally Shift or Ctrl, after which press the following key(s).

SEE: Google Workspace vs. Microsoft 365: A side-by-side analysis w/checklist (TechRepublic Premium)

On this tutorial, I’ll present you many fast and simple keyboard shortcuts for performing frequent duties with rows and columns in Microsoft Excel. They’re simple to implement and if you happen to use a few of them usually, they keys are simple to memorize.

I’m utilizing Microsoft 365 Desktop on a Home windows 10 64-bit system, however you should use earlier variations of Excel. Excel for the online helps commonest keyboard shortcuts.

Prime 11 Excel row and column keyboard shortcuts

Methods to choose the present row in Excel

My favourite method to choose a row is to click on the header cell to the far left, however that’s not at all times essentially the most environment friendly approach, particularly if you happen to’re a number of screens away from the header cell. If you happen to’ve chosen a cell or a variety of cells within the row you need to choose, the keyboard shortcut Shift + Spacebar selects your entire row or rows.

By header cell, I imply the column of numbers to the left of column A, as proven in Determine A.

Determine A

You can click the header cell to select an entire row, but Shift + Spacebar might be quicker. 
You’ll be able to click on the header cell to pick out a complete row, however Shift + Spacebar is likely to be faster.

This keyboard shortcut additionally works to pick out a number of rows. As an illustration, if you happen to’ve chosen C4:C12, urgent Shift + Spacebar will choose rows 4 via 12. The choice have to be contiguous.

Methods to choose the present column in Excel

Just like choosing a row, you possibly can choose a complete column by clicking the column’s header cell. When that cell isn’t out there otherwise you choose to work from the keyboard, press Ctrl + Spacebar to pick out the present column. If the choice includes a number of columns, Ctrl + Spacebar selects all the contiguous columns.

Methods to delete the present row in Excel

You’ll be able to shortly delete the content material from a row or a choice of rows by choosing these rows and clicking Delete. This doesn’t delete the row(s) although. The great distance round this activity is to pick out the row(s), right-click the choice and select Delete from the ensuing submenu. If you happen to’ve chosen a block of contiguous rows, Excel will delete all of them.

A keyboard shortcut can be out there: Ctrl + -. This shortcut works with a number of rows and even non-contiguous alternatives.

Methods to delete the present column in Excel

If you choose a complete column and click on Delete, Excel deletes the content material, however not the column, just like deleting the present row. To delete the present column(s), right-click the present cell or choice and select Delete from the ensuing submenu. Watch out when working with contiguous columns: Excel will delete all of them.

The keyboard shortcut for this deleting activity can be Ctrl + -. This shortcut works with a number of rows however solely contiguous alternatives.

Methods to insert a row in Excel

Inserting a row is easy from the keyboard. Proper-click the chosen row(s) and select Insert from the ensuing submenu. It doesn’t matter which methodology you employ to pick out the row(s). Not like urgent the Delete key to delete content material, the Insert key on the keyboard does nothing.

The keyboard shortcut for this activity is Ctrl + Shift + +. This additionally works with a number of rows, contiguous and non-contiguous. If you choose contiguous rows, Excel will insert the identical variety of clean rows as the choice. The brand new rows will likely be above the chosen row.

Methods to insert a column in Excel

To insert a column, choose that column, right-click that choice after which select Insert from the ensuing submenu. If you choose contiguous columns, Excel will insert the identical variety of clean columns as the choice. Excel will insert new columns to the left of the chosen columns.

The keyboard shortcut for this activity can be Ctrl + Shift + +. This works with a number of rows however not non-contiguous alternatives. If you choose contiguous columns, Excel will insert the identical variety of clean columns as the choice. The brand new columns will likely be to the left of the chosen column.

Methods to apply AutoFit to a row in Excel

The one factor higher than a keyboard shortcut is a straightforward double-click. When you possibly can’t learn the content material in a row as a result of the row top isn’t satisfactory, you possibly can shortly change that property to accommodate the content material. Merely hover over the row’s header cell after which double-click the border. Doing so will improve the row’s top property to accommodate the content material. This shortcut additionally works with contiguous and non-contiguous alternatives.

Methods to apply AutoFit to a column in Excel

As you’re in all probability studying, if you are able to do it to a row, you are able to do it to a column. To use AutoFit to extend a column’s width, choose the column and double-click both of the header cell’s borders. This shortcut additionally works with contiguous and non-contiguous column alternatives.

Methods to disguise a row in Excel

Many of the shortcuts to this point require you to pick out your entire row or column. This one doesn’t. To cover a row or a choice of contiguous or non-contiguous rows, press Ctrl + 9. That’s it.

Methods to disguise a column in Excel

The keyboard shortcut to cover a column, a contiguous choice of columns, or a non-contiguous choice is Ctrl + 0. That’s a numeric zero, not an uppercase O.

Methods to unhide rows and columns in Excel

Unhiding a row requires a bit extra work than hiding them, since you should choose a cell within the rows adjoining to the hidden rows. As an illustration, if you happen to disguise rows 4, 5 and 6, you should choose a cell in each rows 3 and seven. When you’ve carried out so, press Shift + Ctrl + 9 to unhide the rows.

To unhide columns, choose a cell on the left and proper of the hidden columns. Then, press Shift + Ctrl + 0.

To unhide all columns and rows within the sheet, click on the sheet selector on the intersection of the row and column header cells. Doing so will choose your entire sheet. Then, press Shift + Ctrl + 9 and Shift + Ctrl + 0 to unhide every part.


- Advertisement -
- Advertisement -
RELATED ARTICLES
- Advertisement -

Most Popular