The cursor will change to a bar with two arrows and you can double left-click to autofit. Select the rows or columns which you would like to autofit then move the cursor between the row headings or column headings. Thankfully, there are shortcuts to autofit the row height and column widths to your data! Autofit Row Height or Column Width with the MouseĪutofit can be done quickly using the mouse. You might also have data on multiple lines within a cell and this won’t show in the default row height.Īdjusting the rows and columns to the proper size manually would be a pain! Text of numbers in the cells might appear cut off because it’s too long to fit in the current column width.
![microsoft excel shortcut keys delete row microsoft excel shortcut keys delete row](https://cdn.wallstreetmojo.com/wp-content/uploads/2019/12/Add-Rows-in-Excel-Shortcut.png)
When your columns aren’t wide enough it will be hard to read your data. Autofit Column Width with a Keyboard Shortcut Then press Enter to confirm the deletion or press Esc to cancel. The Delete menu also includes accelerator keys so you can select your option from the keyboard. This will open the Delete menu where you can then choose to delete the Entire row or the Entire column. Select a range that includes the rows or columns which you want to delete then press Ctrl + – on your keyboard. You may need to quickly delete rows or columns from your data and this is also possible with a keyboard shortcut.ĭelete rows or columns based on the selected range.
![microsoft excel shortcut keys delete row microsoft excel shortcut keys delete row](https://i.ytimg.com/vi/08MFUgQNSYE/maxresdefault.jpg)
Delete a Row or Column with a Keyboard Shortcut Select a column to the left of the location where you want to insert new columns, hold the Shift key and left click and drag the fill handle. The exact same shortcut works for inserting columns as well. When you release the left click, the rows are inserted. The green border will indicate where the new rows will be placed as you click and drag. When you hold the Shift key this cursor will change into a double line and arrows icon. When you hover the mouse cursor over the fill handle it will turn into a small black plus.
![microsoft excel shortcut keys delete row microsoft excel shortcut keys delete row](https://miro.medium.com/max/2714/0*O38vCGEQs0VnAQub.png)
You will notice the fill handle is conveniently located on the left side of the selected range instead of the right side like usual. Select the entire row just above where you want to insert the new rows. Select a row or column then hold Shift and left click and drag the fill handle to insert rows or columns. There is a really handy mouse and keyboard shortcut combination that allows you to insert multiple rows or columns. Be aware which you are using and use the correct keyboard shortcut accordingly! Insert Rows or Columns with a Mouse & Keyboard Shortcut
#Microsoft excel shortcut keys delete row plus
Note: This keyboard shortcut can be confusing since there are two plus keys + you can use. You can press Enter to confirm the selection or Esc to cancel. Press c while inside the Insert menu to select the Entire column option.Press r while inside the Insert menu to select the Entire row option.These are indicated with the underlined letter in the options. You can use the accelerator keys to select your options. You don’t need to use your mouse inside the menu either. Whether you need to insert rows or columns, the keyboard shortcut is the same as it will open the Insert menu where you can choose what action you need. Only works with the + in the top row of numbers above the letter keys.Ĭhoose Entire row from the Insert menu to insert a new row, or choose Entire column to insert a new column. Opens the Insert menu to insert rows or columns based on the selected range.