The Microsoft Office application suite is currently quite popular in use not only in Vietnam but also in the world. Microsoft Office has many options, many useful tools to help users work effectively, but there are optimization settings, increase Office performance For this suite, not all users know it. Let’s take a look at common universal default settings in Office, then there will be specific customizations on Word, Excel and PowerPoint.
Set up to optimize, give away Microsoft Office performance
How to Optimize and increase Office 2016 performance
1. Change the universal default setting Office 2016
This section will introduce the settings available in almost all or most of the Office 2016 applications. These settings, users can perform on quite popular applications today such as Word, Excel or PowerPoint, and it will automatically be applied to the remaining applications.
Customize the Ribbon
Ribbon is the toolbar that appears above the application and this is where the shortcuts, commands to perform the most common tasks in Microsoft Office toolkit applications.
To customize and set up the Ribbon, users only need to open the Word, Excel or PowerPoint application, then go to the menu File -> select Opions –> select Customize Ribbon. On the left, the user will see all the commonly used commands available, and on the right will show the current configuration.
Users click on the left -> and click Add >> to move it to the right. Users can click on the checkmark + to expand the category and get more customization for the Ribbon.
Default file location
If you often save files / files in the same place, a location, then you should adjust the default file path to save this file. To change the location to save the file, go to File ->Option ->Save -> then search for suitable folder to store documents.
2. Change the default setting of Excel
Number of worksheets
Each time Excel opens, the user will see that there are only 3 blank worksheets by default when creating an Excel file. When users open a new Excel file, they see 3 blank worksheets, which means that Excel has many worksheets in one file. By default, 3 sheets are nice, do not burden users when opening Excel, and then you need to delete unnecessary and unrelated spreadsheets.
Because users are familiar with the multi-spreadsheet feature in Excel, so in new versions of Microsoft Office (including Office 2016), by default, Excel opens only a new workbook. However, users can completely change this quite easily. In Excel, go to the menu File ->Options. At the tab General, under When creating new workbooks -> you only need to enter a value you want in Include this many sheets -> and then select OK, got it is to be. Please note, the value to enter is not more than 255.
In Excel, if a character string exceeds the width of the column, it automatically extends to the next next right. To fix this, users can use the feature Wrap text to process, then the text will fit in one cell.
To enable this feature, open a new sheet -> on the tab Home On the Ribbon, in the Styles group -> Right-click thường -> select Modify -> select Format, then switch to the tab Alignment, you tick Wrap text -> then click OK, got it 2 times is okay.
The above operations only help to change the settings on the current worksheet, if users want to be automatically applied to all worksheets, you need to do it through using templates.
First, the user needs to know the Excel startup folder, you need to open the Excel file, click Alt + F11 to open VBA in Excel, then click next Ctrl + G, input ? application.StartupPath, then press Enter. And the directory path will show up below this command line.
Next, go to the menu File -> select Save As, then name the Excel file, in the menu Save as type -> you choose Excel Template. Next, you will browse the directory path from the previous steps and save the template (Excel file has been activated Wrap text) here. Finally, you can open and use this form already.
3. Customize some default PowerPoint settings
End with Black Slide
The slide show goes to the last page of PowerPoint, the last content you see is not the end slide you created but a black screen with text. End of slide show, click to exit. This message wants to inform the user that the presentation has ended, in case the user has created a separate slide to announce this, the black screen will appear to be redundant.
The black slide as mentioned is already configured and enabled by default, however, you can turn it off (applicable to all presentations) by going to File -> select Options -> click Advanced to the left. Next, you scroll down to the seat Slide Show -> and remove the tick End with black side -> finally click OK, got it to save changes is done.
How to view the file
Users open a PowerPoint file, this application shows you in the default mode, including everything stored in the file such as notes, table of contents, main content of the slide … In case you do not want to display show everything while you are showing you then go File -> select Options, click on Advanced on the left. Then scroll down to the section display, in the drop down menu Open all documents using this view -> select an appropriate view, then click OK, got it to save the selection.
4. Change some of Word’s default settings
Change the font
The standard Microsoft Word font used by default was Times New Roman, but now Calibri. If you want to change the font on the word for all Word files, so you don’t have to change it often every time you create a new file, do the following:
To enter Home on the Ribbon -> click the down arrow in the Font group. You will see a new window for users to select the desired default font, in addition to choosing the font style and size. When you like it, click Set As Default and choose All Documents based on the Normal template? -> then press OK, got it is to be.
Turn off the Paste option
Normally when you paste and paste content into Word, you will see the application automatically open a dialog box Paste Options for users to choose the format. However, you can hide this dialog box by pressing the Esc key, and in case you feel that this feature is no longer needed, it can be completely turned off.
To turn off, go to File -> select Options, then select Advanced on the left, next, drag down the section Cut, copy, and paste -> you unchecked in Show Paste Options button when content is pasted -> then, press OK, got it is off.
Above are a few settings for users Optimize, increase performance in Office 2016, help speed up and efficiency when you work on the Microsoft Office office suite.
There are quite a few other options to help improve the quality of working in Office 2016, but in the context of this article, we try to select, introduce and guide you to the most universal default settings, if If you have any questions or other useful experiences when working on this Microsoft Office 2016 application, please leave a comment or comment in the end of the article for discussion and Taimienphi.vn will add if the That share is useful for users. Thank you for watching the article!