{"id":18743,"date":"2013-05-08T15:57:40","date_gmt":"2013-05-08T10:27:40","guid":{"rendered":"http:\/\/vskills.in\/certification\/tutorial\/?p=18743"},"modified":"2024-04-12T14:24:19","modified_gmt":"2024-04-12T08:54:19","slug":"insert-delete-and-move-cells","status":"publish","type":"page","link":"https:\/\/www.vskills.in\/certification\/tutorial\/insert-delete-and-move-cells\/","title":{"rendered":"Insert, Delete, and Move Cells"},"content":{"rendered":"

Insert, Delete, and Move Cells<\/strong><\/h4>\n

insert new cells, rows, columns, and sheets, and just as easily delete them. If you have formulas that refer to specific cells, Excel updates formulas by adjusting\u00a0cell reference\u00a0to the shifted cells to reflect their new locations.<\/p>\n

On the\u00a0Home<\/strong>\u00a0tab, in the\u00a0Cells<\/strong>\u00a0group, click the arrow next to\u00a0Insert, and then click\u00a0Insert<\/strong> Cells.<\/p>\n

\"15\"<\/a><\/p>\n

Inserting cells<\/strong><\/p>\n

You can insert cells one at a time, in ranges, or in entire rows or columns. This is done by clicking on the
\nInsert button on the home tab of the ribbon. By default if you have a single cell selected, pressing the
\ninsert button will insert a single cell and move the existing cells down the column.<\/p>\n

Inserting a single cell or a range of cells<\/strong><\/p>\n