How to insert or delete rows and columns in Microsoft Excel

140 Views

Thanks! Share it with your friends!

You disliked this video. Thanks for the feedback!

Published Mar 31, 2021

Insert and delete rows and columns to organize your worksheet better. Learn more at the Excel Help Center: https://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: https://aka.ms/SubscribeToM365

► Follow us on social:
LinkedIn: https://www.linkedin.com/showcase/microsoft-365/
Twitter: https://twitter.com/Microsoft365
Instagram: https://www.instagram.com/microsoft365/
Facebook: https://www.facebook.com/Microsoft365/

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

#Microsoft365 #MicrosoftExcel

Category: Software
Tags: microsoft 365, microsoft excel, excel tutorial

Be the first to comment

Sign in

Create your account

Add Video

How to insert or delete rows and columns in Microsoft Excel

Up Next