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

Please take the opportunity to connect and share this video with your friends and family if you find it useful.