How to insert or delete rows and columns in Microsoft Excel
219 981
193.5
Microsoft Office616 тыс
Следующее
Популярные
161 день – 6 7402:30
161 день – 5 1982:12Опубликовано 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
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
Свежие видео
2 дня – 64 8346:38
2 дня – 771:05
5 дней – 3 6080:22
6 дней – 71 83121:37
Случайные видео
292 дня – 4 3742:01:21
22.11.22 – 11 2521:14
01.11.22 – 2 84615:32
10.09.22 – 114 2939:57
16.08.22 – 4 0290:44
16 часов – 9120:42
10 часов – 2060:34
23 мин – 31:17
1 день – 2 8660:59
2 дня – 1321:22
6 дней – 7 0020:17
