How To Add Additional Rows Above Or Below In Microsoft Excel

How to insert rows and columns in Excel 

1. Open a blank Excel workbook.
2. Enter data, or choose an existing workbook with data already pre-filled. Here we’re going to use a listed of alphabetized names. If we forget one, we can quickly add the space we need to add the name without moving anything else around.
3. Right-click the cell you’d like to add blank space above or below and select Insert 1 row above. In the previous version, just select Insert.
4. Choose Entire row.
5. Click OK. 

Microsoft Excel Tips

Previous TipNext Tip

Use VLOOKUP in ExcelBack Up Files Automatically in ExcelRemove Duplicate Data in ExcelCreate a Waterfall Chart in ExcelLock Cells in ExcelFreeze Rows and Columns in ExcelBuild a Forecast Chart in ExcelCreate a Funnel Chart in ExcelMake a Treemap in ExcelConvert Excel Sheets to Google SheetsOpen Google Sheets in ExcelCombine Data from Different CellsMerge Cells to Span Multiple ColumnsUse AutoFill for Repetitive DataCopy and Paste Repetitive Data the Easy WayUse Text to ColumnsDraw Diagonal Line in a CellCreate a New Shortcut MenuTranspose Columns Using Paste Special