ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

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

user-image
تم إضافة السؤال من قبل FITAH MOHAMED , Financial Manager , FUEL AND ENERGY CO for transportion petroleum materials
تاريخ النشر: 2014/02/02
Atif Tanveer
من قبل 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
من قبل 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
من قبل 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
من قبل Umar Nawaz , Internal Auditor , Matco Rice Processing (Pvt) Limited

Ctrl is the key :)

Mukkaram Siddique
من قبل 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
من قبل 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

المزيد من الأسئلة المماثلة