How can format many sheets at the same time in excel 2007 ?

Press Ctrl key, with mouse select all sheet tabs you want to format

leave the Ctrl key, do the formating you want

Select the multiple tabs (hold down ctrl) you want to have the same format in your excel sheet to highlight it as white tabs. Then enter the format you want in the first sheet. it will copy automatically to the other selected sheets.

You can use Ctrl to select different sheets or shift to select sequential sheets . Then do your format save and ungroup sheets.

Ctrl is the key :)

You need to select the sheets first and then the editing in current sheet will be done in all sheets.

 

It depends what kind of selection you need, with 'Shift' and 'Ctrl' buttons you can do.

Pressure on ctrl + clicking continue And determine Alhitat be coordinated Then we Alhitat one specific format and will apply the same format to the other Alhitat