How to insert a row or a column in an Excel spreadsheet?

Who I am
Mart铆 Micolau
@martimicolau
Author and references


If you need to insert data into an Excel table, sometimes it makes sense to add an entire row or column. In this tutorial, we will teach you how to perform such a maneuver!

Insert a row or column in an Excel worksheet

  1. Select a cell that is placed on the row or column to add.


  2. Right-click on it and click Insert.

  3. On the dialog box, you have several insertion options:

    • Shift cells right

    • Shift cells down

    • Whole line

    • Whole column


  4. Select the insert option you want, then click the button OK to perform the desired insertion.


40 ">This tutorial is brought to you by the trainer Jean-Philippe Parein
Find his course Learn and Master PowerPoint Complete Guide
in full on Udemy.
add a comment of How to insert a row or a column in an Excel spreadsheet?
Comment sent successfully! We will review it in the next few hours.