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.
0 Comments
Leave a Reply. |