Insert or delete cells, rows and columns

Use the Insert feature to insert blank cells to the left or above the active cells on a worksheet. You can also insert an entire column to the left of a selected column or an entire row above a selected row. Similarly, using the Delete feature, you can delete an entire row/column or just selected cells and shift other cells in the same row to the left/in the same column up to accommodate the new cells.

1. Convert a PDF file to Excel using Convert to Writable Excel, which opens an .xlsx file in Write mode.

2. Determine the cells, columns, or rows to be inserted or deleted and choose Home > Cells > Insert/Delete. Then do the following to insert/delete cells, rows or columns.

• • Insert Cells…. In the Insert dialog box, select Shift cells right to insert a blank cell to the left or Shift cells down to insert a blank cell above the active cells. Also, select Entire row to add an entire row above a selected row or select Entire column to add an entire column to the left of a selected column on the worksheet.

  • Insert Sheet Rows. Insert a new row on top of the selected rows or cells. Select either the row or a cell in the row above which you want to insert the new row. For example, to insert a row above row 10, click on a cell in row 10. Then, choose Insert > Insert Sheet Rows.

  • Insert Sheet Columns. Insert a new column on the left side of the selected columns or cells. Select either the column or a cell in the column to the right of where you want to insert the new column. For instance, to insert a new column to the left of column C, click a cell in column C. Then, choose Insert > Insert Sheet Columns.

  • Delete Cells…. In the Delete dialog box, select Shift cells left to delete a selected cell and shift other cells in the same row left, or select Shift cells up to delete a selected cell and shift other cells in the same column up. Also, select Entire row to delete an entire row or Entire column to delete an entire selected column on the worksheet.

  • Delete Sheet Rows. Delete the entire rows that include the cells you selected from the sheet.

  • Delete Sheet Columns. Delete the entire columns that include the cells you selected from the sheet.