Communiquez avec les autres et partagez vos connaissances professionnelles

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

Suivre

How can limit the gird according to our necessity from a large Excel Sheet of Excel work book?

In a excel sheet we can use a lot of grid consist of column and row. We can get a lot of grid by moving scroll bar but if we want to limit the movement of scroll bar to work with certain number of column and row then what I have to do?

user-image
Question ajoutée par Tafazzal Hossain Jewel , Administritive Assistant , Alpha Media Group, LLC USA
Date de publication: 2013/12/26
Rajesh K
par Rajesh K , ISP Manager , CENPAC NET INC

Hide unnecccessary coloumns and filter with useful criteria

Zaheer Soomro
par Zaheer Soomro , Assistant Manager (purchase) , United Construction Company

By Filtering you can do that 

 

Zahid Chandio
par Zahid Chandio , Finance Controller , Americana

Use Pivot Table in its very useful in managing bulky data.

Trainer Dalia Abd El-Latif
par Trainer Dalia Abd El-Latif , موظفة شئون إدارية , إدارة سوهاج الاجتماعية جمعية تنمية المجتمع ببرخيل - البلينا المشهرة برقم 155لسنة 1670

page Layout-

print titles -

sheet-

 (print area)-

Rana Amin
par Rana Amin , GATE OFFICER , Sadaqat Limited

Firstly we select the number of coloum and row who requaired me and then select set print area 

Pivot table is good method

Data filters

Hide unnecessary or confidential information with "column hide" and then protect sheet

krushnasinh chavda
par krushnasinh chavda , General Accountant , Pixel Digital Systems LLC - UAE

Go to view and click on page break preview.

More Questions Like This

Avez-vous besoin d'aide pour créer un CV ayant les mots-clés recherchés par les employeurs?