Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

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

user-image
Question ajoutée par FITAH MOHAMED , Financial Manager , FUEL AND ENERGY CO for transportion petroleum materials
Date de publication: 2014/02/02
Atif Tanveer
par Atif Tanveer , Decision Support Specialist , Hamilton Health Science

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

leave the Ctrl key, do the formating you want

Anzar Hafeez
par Anzar Hafeez , Financial Controller , Al Wajeez Development Co. PJSC

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.

IBN Eljarah Mohamed Ali ABD ELGADIR
par IBN Eljarah Mohamed Ali ABD ELGADIR , Group Finance Director , Sigma Electric

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

Umar Nawaz
par Umar Nawaz , Internal Auditor , Matco Rice Processing (Pvt) Limited

Ctrl is the key :)

Mukkaram Siddique
par Mukkaram Siddique , Finance, Management & Stocks , Amazon Foods Saudi Arabia

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.

georgei assi
par georgei assi , مدير حسابات , المجموعة السورية

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

More Questions Like This