How to insert or delete rows and columns in Microsoft Excel

Опубликовано 25 февраля 2021, 16:00

Insert and delete rows and columns to organize your worksheet better. Learn more at the Excel Help Center: msft.it/6001pA3ET

To insert a single row: Right-click the whole row above which you want to insert the new row, and then select Insert Rows.

To insert multiple rows: Select the same number of rows above which you want to add new ones. Right-click the selection, and then select Insert Rows.

To insert a single column: Right-click the whole column to the right of where you want to add the new column, and then select Insert Columns.

To insert multiple columns: Select the same number of columns to the right of where you want to add new ones. Right-click the selection, and then select Insert Columns.

If you don’t need any of the existing cells, rows, or columns, here’s how to delete them: Select the cells, rows, or columns that you want to delete. Right-click, and then select the appropriate delete option, for example, Delete Cells & Shift Up, Delete Cells & Shift Left, Delete Rows, or Delete Columns.

When you delete rows or columns, other rows or columns automatically shift up or to the left.

► Subscribe to Microsoft 365 on YouTube here: aka.ms/SubscribeToM365

► Follow us on social:
LinkedIn: linkedin.com/showcase/microsof...
Twitter: twitter.com/Microsoft365
Instagram: instagram.com/microsoft365
Facebook: facebook.com/Microsoft365

► For more about Microsoft 365, visit msft.it/6006Tc8Z4

#Microsoft365 #MicrosoftExcel