To delete a row or a column in Excel, use hot keys CTRL+MINUS having preliminary highlighted them. You only have to highlight the rows correspondingly by row numbers. You only need to select a tool in the appropriate menu. Row deleting is performed in the similar way. The shortcut menu can also be used for deleting if you highlight headings A1 and D1 instead of cells. Highlight the nonadjacent range of cells A1 D1 and select «HOME»-«Delete»-«Delete Sheet Rows». Therefore, you have to practice.īy way of illustration, let’s delete from our pricelist the numbering of goods line items and the unit column simultaneously.

When working with Excel you need to delete rows and columns as often as to insert them. New rows are always added above the highlighted rows. To add a row or a column in Excel use hot keys CTRL+SHIFT+PLUS having highlighted the appropriate row or column. You need to highlight headings of rows 1 and 3, right-click on one of the highlighted rows and select «Insert» option. The picture shows how to insert a blank row between other rows in Excel. Now once again use the tool «HOME»-«Insert»-«Insert Sheet Columns». You know from the previous tutorials how to highlight nonadjacent ranges. Highlight the nonadjacent range of two cells A1,A4 (note that character “,” is used instead of character “:” – it means that two nonadjacent ranges should be highlighted to make sure, type A1 A4 in the name field and press Enter). To this end, let’s insert two new rows simultaneously. Now let’s add a heading and a new goods line item «All for the garden» to the pricelist. How to insert a row between rows in Excel? The order of inserted also depends on the order of highlighting. There appear as many new columns as many old ones have been highlighted. Columns are always added to the left side. Then use the same tool on the «Insert»-«Insert Sheet Columns» main tab.Īlternatively, highlight two headings of columns C and D, right-click and select «Insert» option. To add simultaneously, highlight the two-cell range (C1:D1). The pricelist still lacks two columns: quantity and units (items, kilograms, liters, packs).

Simultaneous insertion of several columns Now you can type the numbers of pricelist line items. Select the column, and press the hotkey combination CTRL+SHIFT+PLUS.Select «Insert» option on the shortcut menu. Then go to tab «HOME», tool section «Cells» and click «Insert», in the popup menu select «Insert Sheet Columns» option. To insert a column between other columns for filling in pricelist items numbering you can use one of the two ways: How to insert a column between other columns?Īssuming you have a pricelist lacking line item numbering:

Insert column excel shortcut