Microsoft Excel Microsoft launched the Independent in Microsoft office A to work in an office Software. Excel 2016 as Microsoft One of its Office series office software, its best field is batch data processing. The software is generally based on form Running in the form, it also contains many rich functions. It is a software that is simple to use, but can find hidden secrets after in-depth understanding. Huajun Software Park provides free full version download of Excel 2016! The Microsoft Excel 2016 installation package will be downloaded through the Office Assistant (software size: 4.62MB), an official Microsoft licensed product. Please rest assured that you can use it.
Similar software
Version Description
Software address
Green version
see
Green version
see
Green version
see
Green version
see
Green version
see
Excel 2016 Tips
How to filter duplicates in Excel data ？
1. Double click to open the Excel file you want to process. After opening it, select the data area you want to process, click Start, and then select Conditional Format. In the pop-up drop-down menu, click Highlight Cell Rules, and then select the Duplicate Value option.
2. Then, in the repeating option box, confirm that the repeating value is highlighted in the Excel default format, and then you can select the color by yourself. After that, click the [OK] button.
3. Click OK, and the repeated Excel cells will be displayed in pink
4. Select the title row of the Excel data table, click Start in the menu bar, and then select Sort and Filter. In the pop-up drop-down menu, select Filter. If there is no header row, please insert a row at the front and select an empty row as the filter row.
5. In the data column to be filtered, click the downward triangle, select Filter by Color in the filter box that appears, and select Pink.
How can Excel easily wrap lines in cells?
Method 1:
Find the new line cell, double-click the cell, make sure the mouse cursor is in the cell, and press ALT+Enter to start the new line.
Method 2:
1. Find any blank cell, right-click and click Set Cell Format in the pop-up options.
2. Then in the pop-up setting page of cell format setting, click the alignment tab above, check "Auto Wrap" in the text control options, and then click OK. Other options can be modified on your own. I will not introduce them in the editor.
3. Then we enter text in this blank cell, and the line will automatically wrap.
If you need more ways to use Excel, please follow the WeChat official account of "Little Doctor of Office Software" to get more skills in using Excel.
Features of Excel 2016:
1、 New TellMe function
Now it can be quickly retrieved through the "TellMe" function Excel Function button, users do not have to go to the tab one by one to find the specific location of a command. For example, when we enter a table, the drop-down menu will display such operable commands as Add Table, Table Attribute, Table Style, and of course, it will also provide help to view the "Table".
2、 More OFFICE topics
The theme of Excel 2016 is no longer the dull grey white in Excel 2013. There are more theme colors for us to choose.
3、 Built in PowerQuery
PowerQuery has been built into Excel 2016. Power Query can create a new query drop-down menu. In addition online There are three main functions: query, display query, and recent source.
4、 New forecasting function
In the Data tab, the prediction function is added, and several prediction functions are also added.
5、 Improve the function of pivot table
PivotTable field list now supports search Yes, if there are many data source fields, it will be easier to find some fields.
Excel 2016 installation method
1. Download the Excel 2016 installation package from Huajun Software Park. Since Excel is one of the Office series office software, we need to install Office before we can use it. We first run the downloaded Office Assistant.
2. Here, users need to purchase an Office activation code. After obtaining the activation code and entering it, Office will start to install, and then wait for the installation of Office 2016 to complete. If an error is reported in the middle of the process, it may be that the office software before the computer is not uninstalled completely, so it needs to be uninstalled first and then reinstalled.
Excel2016 shortcut key
Ctrl+W closes the page under the current program, and Alt+F4 closes the Excel program directly.
Ctrl+F5 Restores the size of the selected workbook window.
F6 Switches to the next pane in the worksheet that is split (Split command on the Window menu).
Shift+F6 switches to the previous pane in the split worksheet.
Ctrl+F6 Switch to the next workbook window when multiple workbook windows are opened.
Ctrl+Shift+F6 or Ctrl+W switch to the previous workbook window.
Ctrl+F9 Minimizes the workbook window to an icon.
Ctrl+F10 Restores the selected workbook window.
F6 Move from the other panes of the program window to the task pane. You may need to press F6 several times.
(Note: If pressing F6 does not display the desired task pane, press Alt to activate the menu bar, and then press Ctrl+Tab to move to the task pane.)
Ctrl+Tab Move to the task pane when a menu or toolbar is active. You may need to press Ctrl+Tab more than once.
Tab or Shift+Tab Select the previous or next option from the task pane when it is active
Differences between Excel 2016 and Excel 2013:
1. Excel 2016 has a text box "Please tell me what you want to do?" This text box is a search engine in the functional area. Enter the function you want to find in this text box, and it will be very convenient for you to find it.
2. Several graphics have been added to Excel 2016.
3. The VBE object model loaded by Excel 2016 has been updated and does not need to be installed
The above is the summary of Huajun Xiaobian. If you like Excel 2013, Huajun Software Park also provides downloads!!
To download Excel 2013, please click ： http://www.onlinedown.net/soft/588069.htm
Excel 2016 FAQs
What if the data is lost or the file is damaged?
Regular backup: save the workbook to a different location regularly to prevent data loss.
Use the auto save function: Enable the auto save function of Excel to reduce data loss caused by unexpected software shutdown.
Check file compatibility: Make sure the file extension is compatible with the Excel version.
Use the file repair tool: If the file is damaged, you can try to use Excel's Open and Repair function or a third-party file repair tool to restore the data.
Excel 2016 Update Log:
1. The theme colors are color and medium gray.
2. The touch mode of Excel 2016 has larger font spacing, which is more convenient for direct operation with fingers.
3. The Clippy assistant returns. On the ribbon, there is a text box displaying Tell me what you want to do. It is the Tell Me search bar.
4. In the Excel 2016 file menu, the interfaces of Open and Save As have been improved.
5. Excel 2016 integrates sharing functions with OneDrive, greatly simplifying file sharing.
6. Save workbook in OneDrivefor On Business or SharePoint, you can view the complete list of changes made to the workbook in the History interface of the File menu, and access the previous version.
7. Add ink formulas in Excel 2016, and users can manually write mathematical formulas in the editing area with their fingers or touch pens.
8. In Excel 2016, tree chart, sunrise chart, histogram, arrangement chart, box chart and waterfall chart are added.
9. 3D maps are built in Excel 2016, so users can easily insert 3D maps and play them synchronously with two digit maps. At the same time, the Power Map plug-in improves this function.
Recommended by the Chinese military editor:
Microsoft Excel 2016 is one of the Office series office software. Friends who often use computers to work will be familiar with it. Tables are tools that are often needed in work. Those who need them should download them quickly. We also provide you with other Office software, such as: office2016, Microsoft Office Word 2016, PowerPoint Viewer 2007
Tips 1: 1. Microsoft has stopped maintaining this version of Office software and no longer provides genuine maintenance;
2. In order to provide users with a better experience of using genuine software, the download version is: Office 365/Office 2016;
3. The use of pirated software has legal risks, so it is recommended to use genuine software.
