Please support us!

Copying to Multiple Sheets

You can select multiple sheets to apply commands and calculate across them.

Odabir visestrukih ploca

The sheet tab of the current sheet is always visible in white in front of the other sheet tabs. The other sheet tabs are gray when they are not selected. By clicking other sheet tabs while pressing you can select multiple sheets.

You can use Shift++Page Up or Page Down to select multiple sheets using the keyboard.

Note Icon

An information bar warns you that some hidden sheets are selected in addition to the visible ones. You can deselect these hidden sheets with the button provided.


Vracanje selekcije

To undo the selection of a sheet, click its sheet tab again while pressing the key. The sheet that is currently visible cannot be removed from the selection.

Deselect all

Racunanje kroz visestruke ploce

Možete se pozvati na raspon tabela u formuli tako što ćete specifirati prvu i zadnju tabelu raspona, naprimjer =SUM(Tabela1.A1:Tabela3.A1) sumira sve A1 ćelije u tabelama od Tabela1 do Tabela3.