Group adjacent sheets by clicking the first tab, holding Shift, and clicking the last tab;
Group non-adjacent sheets by holding Ctrl and clicking each tab;
Right-click any grouped worksheet tab and select Ungroup Sheets;
Make edits to grouped sheets to apply changes across all selected sheets.

Завдання

Click the tab of the first worksheet to group. Hold down the Shift key and click the tab of the last worksheet to group adjacent sheets.
Hold down the Ctrl key and click the tabs of Section 5 and 7 to group them.
Make changes to the grouped worksheets.
Right-click a grouped tab and select Ungroup Sheets to ungroup them.

Завдання

Click the tab of the first worksheet to group. Hold down the Shift key and click the tab of the last worksheet to group adjacent sheets.
Hold down the Ctrl key and click the tabs of Section 5 and 7 to group them.
Make changes to the grouped worksheets.
Right-click a grouped tab and select Ungroup Sheets to ungroup them.

Mark tasks as Completed

Все було зрозуміло?

Секція 7. Розділ 2

Choose your plan

Grouping and Ungrouping Worksheets

In this chapter, we take worksheet management to the next level by learning how to group and ungroup worksheets.

Grouping worksheets allows you to make changes to multiple sheets simultaneously, saving you a ton of time.

This technique is invaluable when dealing with large datasets or when you need consistency across your workbooks.

Group adjacent sheets by clicking the first tab, holding Shift, and clicking the last tab;
Group non-adjacent sheets by holding Ctrl and clicking each tab;
Right-click any grouped worksheet tab and select Ungroup Sheets;
Make edits to grouped sheets to apply changes across all selected sheets.

Завдання

Click the tab of the first worksheet to group. Hold down the Shift key and click the tab of the last worksheet to group adjacent sheets.
Hold down the Ctrl key and click the tabs of Section 5 and 7 to group them.
Make changes to the grouped worksheets.
Right-click a grouped tab and select Ungroup Sheets to ungroup them.

Завдання

Click the tab of the first worksheet to group. Hold down the Shift key and click the tab of the last worksheet to group adjacent sheets.
Hold down the Ctrl key and click the tabs of Section 5 and 7 to group them.
Make changes to the grouped worksheets.
Right-click a grouped tab and select Ungroup Sheets to ungroup them.

Mark tasks as Completed

Все було зрозуміло?

Секція 7. Розділ 2

In this chapter, we take worksheet management to the next level by learning how to group and ungroup worksheets.

Grouping worksheets allows you to make changes to multiple sheets simultaneously, saving you a ton of time.

This technique is invaluable when dealing with large datasets or when you need consistency across your workbooks.

Group adjacent sheets by clicking the first tab, holding Shift, and clicking the last tab;
Group non-adjacent sheets by holding Ctrl and clicking each tab;
Right-click any grouped worksheet tab and select Ungroup Sheets;
Make edits to grouped sheets to apply changes across all selected sheets.

Завдання

Click the tab of the first worksheet to group. Hold down the Shift key and click the tab of the last worksheet to group adjacent sheets.
Hold down the Ctrl key and click the tabs of Section 5 and 7 to group them.
Make changes to the grouped worksheets.
Right-click a grouped tab and select Ungroup Sheets to ungroup them.

Завдання

Click the tab of the first worksheet to group. Hold down the Shift key and click the tab of the last worksheet to group adjacent sheets.
Hold down the Ctrl key and click the tabs of Section 5 and 7 to group them.
Make changes to the grouped worksheets.
Right-click a grouped tab and select Ungroup Sheets to ungroup them.

Все було зрозуміло?

In this chapter, we take worksheet management to the next level by learning how to group and ungroup worksheets.

Grouping worksheets allows you to make changes to multiple sheets simultaneously, saving you a ton of time.

This technique is invaluable when dealing with large datasets or when you need consistency across your workbooks.

Group adjacent sheets by clicking the first tab, holding Shift, and clicking the last tab;
Group non-adjacent sheets by holding Ctrl and clicking each tab;
Right-click any grouped worksheet tab and select Ungroup Sheets;
Make edits to grouped sheets to apply changes across all selected sheets.

Завдання

Click the tab of the first worksheet to group. Hold down the Shift key and click the tab of the last worksheet to group adjacent sheets.
Hold down the Ctrl key and click the tabs of Section 5 and 7 to group them.
Make changes to the grouped worksheets.
Right-click a grouped tab and select Ungroup Sheets to ungroup them.

Секція 7. Розділ 2

Перейдіть на комп'ютер для реальної практикиПродовжуйте з того місця, де ви зупинились, використовуючи один з наведених нижче варіантів