How to Insert a Row or Column in an Excel Spreadsheet

Excel is one of the best computer programmes of its kind. It is currently developed and published by Microsoft and generally comes as a part of the Microsoft Office suite. Moreover, there are numerous formatting options in an Excel spreadsheet, making it easy to use for beginners. There are more than one way in which you can insert a row or column in an Excel spreadsheet. Here is the simplest method of all.

Things Required:

– Microsoft Excel installed in a computer

Instructions

  • 1

    Launch a new session of MS Excel. You will need to wait for a brief moment for the programme to completely load.

  • 2

    As soon as MS Excel loads completely, a new spreadsheet will be displayed. If you plan to insert a row or column in an old Excel spreadsheet, click the MS Office logo on the top left corner of MS Excel window followed by the option labelled ‘Open’ and then navigate to the desired file using the dialogue box captioned ‘Open’. Double click on the thumbnail image of the desired file to open it.

  • 3

    To the left side of the grid, you will see numbers starting from 1. Directly above the Excel grid, you will find English alphabets starts from the letter A. Number are used to refer to Excel rows such as Row 1, Row 2 and so on. On the other hand, alphabets are used to refer to Excel columns such as Column A, Column B, etc.

  • 4

    The first thing you need to do is to determine where you would want to add the row or column. For instance, you might want to add a row directly above or below Row 4. Similarly, you might want to add a column to the left or right of Column C.

  • 5

    For adding a row above a certain row, click on the Row number above which you want to add a row. Click the right mouse button and choose ‘Insert’ from the drop down menu which appears.

  • 6

    For adding a row below a certain row, click the Row number falling after the Row number below which you want to add a row. For instance, if you want to add a row below Row 4, you will need to click Row 5. Right click as before and then click ‘Insert’.

  • 7

    For adding a column to the left of a certain column, click the Column alphabet to the left of which you want to add a column. Click the right mouse button and choose ‘Insert’ from the drop down menu which appears.

  • 8

    For adding a column to the right of a certain column, click the Column alphabet falling after the column alphabet to the right of which you want to add a column. For instance, if you want to add a column to the right of Column C, you will need to click Column D. As before, right click and then choose ‘Insert’.

Leave a Reply

Your email address will not be published. Required fields are marked *


+ one = 10