Save Rs 499. Go Ad-Free with CAclubindia Pro for 2 Full Years. Subscribe Now!

Setting in EXCEL

1073 views 3 replies

Nidhi Jain

987 Points Posted on 23 June 2011

Hai ,

when we prepare any document in excel, I set this document through VIEW-PAGE BREAK PREVIEW everything is ok But when i take print it shows very little FONT and when i increase the font size in system my whole earlier setting spoiled.

can anyone tell me how to make setting in excel after preperation of Document???????

Replies (3)

Jaideep

Service

1373 Points Posted on 23 June 2011

If u set whole sheet in one page excel will automatically reduce the font size, what you can do is, go to print preview and set page by no of pages and set it for more than two pages as per the size od the data...

Regards

ROSHAN PAUL JOSEPH

CA Final student

311 Points Posted on 23 June 2011

look for

Excel ---> Print Preview--> page set-up-->page--> scaling-->adjust to: 100%

Data entry

sales

24 Points Posted on 02 July 2011

One thing You go to excel sheet and open file menu then after check print page set up and check print perview and check your size then after click print finally send Print your printer.

Thank you

Data Entry India

Outsource Data Entry