Grupe radnih listova

Napomena:  Želimo da vam što pre pružimo najnoviji sadržaj pomoći čim na vašem jeziku. Ova stranica je prevedena automatski i može da sadrži gramatičke greške ili netačnosti. Naš cilj je da ovaj sadržaj bude koristan. Možete li nam na dnu ove stranice saopštiti da li su vam informacije bile od koristi? Ovo je članak na engleskom jeziku za brzu referencu.

You can quickly perform tasks on multiple worksheets at the same time by grouping worksheets together. If you group a set of worksheets, any changes you make on one worksheet are made in all the other worksheets in the group in the exact same location on the worksheets. If you want to create, for example, standard tables or calculations on a large number of worksheets, grouping can save you a lot of time. This works best if the worksheets already have identical data structures.

U ovom članku

Group selected worksheets

In the example below, a workbook has multiple worksheets for different cities. All the worksheets have identical structures showing sales of coffee drinks.

Primer radnog lista

To perform the same tasks for a particular set of worksheets, follow the steps below.

  1. Press and hold down the Ctrl key, and click the worksheet tabs you want to group.

    Kliknuto je na kartice „Pariz“ i „Berlin“.

    Savet: If you want to group consecutive worksheets, click the first worksheet tab in the range, press and hold the Shift key, and click the last worksheet tab in the range.

  2. Now, suppose you want to add the same formula to cell B7 on both the “Paris” and “London” worksheets. When grouped, the change will happen on both worksheets when either worksheet is modified. For example, a formula change to the Paris worksheet is automatically made to the London worksheet:

    Formula u radnom listu „Pariz“. Formula je takođe u radnom listu „London“.

    Napomena: When you group worksheets, the name of the workbook changes to include [Group].

    Top of Page

Savet: Korisnici vole savete. Kad god možete da date neki dobar savet, navedite ga.

Ungroup selected worksheets

If you don’t want to apply specific tasks to a particular set of worksheets, ungroup selected worksheets

  1. Press and hold the Ctrl key, and click the worksheet tabs you want to ungroup.

Top of Page

Group all worksheets

You can easily group all the worksheets in a workbook.

  1. Right-click any worksheet tab.

  2. Click Select All Sheets.

    U priručnom meniju izabrana je stavka „Izaberi sve listove“. Svi radni listovi su izabrani.

    Napomena: When you group all worksheets, browsing through the worksheets ungroups them. You can browse through the grouped worksheets without ungrouping them if you don’t select all worksheets.

    U priručnom meniju je izabrana stavka „Razgrupiši listove“.

Top of Page

Ungroup all worksheets

When you’ve made all the changes, you can ungroup the worksheets.

  1. Right-click any worksheet tab in the group.

  2. Click Ungroup Sheets.

    Savet: To ungroup all worksheets, you can also click any worksheet tab outside the group.

Top of Page

Takođe pogledajte

Ručni unos podataka u ćelije na radnom listu

Razvijte Office veštine
Istražite obuku
Prvi nabavite nove funkcije
Pridružite se Office Insider korisnicima

Da li su vam ove informacije koristile?

Hvala vam na povratnim informacijama!

Hvala za povratne informacije! Zvuči da će biti od pomoći ako vas povežemo sa našim agentima Office podrške.

×