Thursday, 3 November 2016

MS Excel : How to Change Default No. of Sheet, Font Size, Style & View

how to set default number of sheet in excel,how to set default font size,default font style,set default sheet view,change default setting for excel sheet,excel file,set default font size for all exce file,default setting for all excel file,open with default setting,change font size to all,font style,set number of sheet for excel workbook,auto default,change,set,change default sheet view,excel 2003,2010,2016,excel 2007,excel tip & tricks,change and setBy default Microsoft Excel workbook open with one sheet, default font size and font style, but not every one use same font size and font style or number of sheet, changing setting every time its not a good idea, so the point is how to set default number of sheet, font size, font style and sheet view in Excel, lets see how to do this.

1.       Open MS Excel click on “File” than click on “Options”
how to set default number of sheet in excel,how to set default font size,default font style,set default sheet view,change default setting for excel sheet,excel file,set default font size for all exce file,default setting for all excel file,open with default setting,change font size to all,font style,set number of sheet for excel workbook,auto default,change,set,change default sheet view,excel 2003,2010,2016,excel 2007,excel tip & tricks,change and set

2.     Select “General” and in When creating new workbooks section select your desire font style, font size, sheet view and insert sheet number of sheet and than “Ok”
how to set default number of sheet in excel,how to set default font size,default font style,set default sheet view,change default setting for excel sheet,excel file,set default font size for all exce file,default setting for all excel file,open with default setting,change font size to all,font style,set number of sheet for excel workbook,auto default,change,set,change default sheet view,excel 2003,2010,2016,excel 2007,excel tip & tricks,change and set

3.       From next Excel workbook will open as per your given setting.

Watch video tutorial.. Please like, share & subscribe 

1 comment:

Jhon Abraham said...

I have read your blog. It is really helpful to work with excel. Continue shares more about excel.
Regards,
Excel Advanced Training | MS excel Training in Chennai | Excel Macro Training in chennai

Popular Posts