Excel 2007

excel2007 is the 2007 version of excel office software, which is an older version. Office 2007 office software includes applications such as Word, Excel, PowerPoint and Outlook. Friends can choose to purchase it once and then use the software on a single PC. If you need to use the excel2007 version of office software, you can choose to download it for free at Huajun Software Park.The Excel 2007 installation package will be downloaded through the Microsoft official authorized product Office Assistant (software size: 4.62MB), please feel free to use it.

Excel2007 function introduction

Open the workbook

In Excel 2007, you can open files created with Microsoft Office Excel 2007, Microsoft Office Excel 2003, Excel for Windows (version 95 and later), and Microsoft Excel for the Macintosh (version 2.2 and later).

View worksheet

You can scroll through various parts of the worksheet and switch to other worksheets. You can also zoom the view and minimize the ribbon.

Print worksheet

You can specify the worksheet data to print and set print options for printing the data just like in Excel.

excel2007 installation tutorial

​ ​ 1. First, you need to find the download address on this page and select any address to download the excel2007 software package to your local. After downloading, double-click and unzip the excel2007 installation program in the package to run. as follows:

​ ​ 2. After running and installing excel2007, if the interface asking you to enter the product key appears, please search for the relevant documents in the downloaded software package to obtain the key and enter the relevant information in the following interface.

3. The effect of entering the excel2007 key is as follows:

​​ 4. Continue the installation and enter the excel2007 installation agreement interface. Please understand the agreement and agree to it in this interface.

5. After agreeing to the agreement, enter the excel2007 installation path setting interface. Please select the option that suits you for installation. The editor recommends that you select [Custom] to set installation options. For example, the installation location can be set to a disk other than the C drive.

​​ 6. After setting the excel2007 installation path, enter the file storage location setting interface and follow the instructions in the picture.

​​ 7. The excel2007 installation information has been set and you have entered the installation progress bar interface. Please wait patiently for the installation to be completed.

8. Finally, click [Close] after the excel2007 installation is completed. If you need to, you can choose [Go to Office Online].

excel2007 tutorial

​​​Change the default number of worksheets in excel 2007

Normally, when we open the default configuration of excel2007 software, it will automatically help us create a new workbook containing 3 blank worksheets. If you feel that it is not necessary to generate so many worksheets, please set it up according to the editor.

​ ​ 1. Run and open excel2007, select [General] or follow the prompts in the picture to find the excel2007 function button in the upper left corner to open it.

​ ​ 2. Select [excel2007 options] in the drop-down interface opened by excel2007 and enter.

3. Please select the [Common] option and set the number of included worksheets to "1" (any number you want)

4. Then save and close.

excel2007 frequently asked questions

​​​How to set password protection in excel 2007?

​ ​ 1. First, please run and open the excel2007 document that needs to be encrypted, and then select the button in the upper left corner indicated in the picture to open and select [Save As].

​​ 2. In the pop-up Save As interface, select [Tools] at the location indicated in the picture to open the selection drop-down.

3. Then select [General Options]

​​ 4. In the pop-up excel2007 general options interface, set the password for opening permissions or modify the permissions password you need.

5. [Open permission password]: If you set this permission, you will enter the password twice and confirm it the next time you open the encrypted document.

​ ​ 6. [Modify permission password]: If you don’t want to prevent others from browsing, you can choose not to set [Open permission password], just [Modify permission password].

​ 7. The following is a screenshot of the document effect when the editor opens [Modify Permission Password]. You only need to enter the set password.

​​ 8. [Read-only] and [Backup] options, friends can directly check and confirm if necessary.

Screenshot of the effect of opening a read-only document:

The effect of checking the backup option is as follows:

      How to delete records in excel 2007?

Want to delete some recently opened document record information? Please follow the steps below to delete it!

​​ 2. Select the button in the upper left corner indicated in the picture to open it, and select [excel options]

3. Please select [Advanced] in the pop-up excel2007 option interface, then scroll down to find "Display" - "Show this number of recently used documents", and then set it to "0" (0 means none, if you want to display Just enter more than one corresponding number)

​​ 5. The editor sets the open document history record of excel2007 to zero. The effect is as follows:

excel2007 frequently asked questions

Date and time issues:

If you are using the 1900 date system, the date and time must be positive values. Subtracting a later date or time value from an earlier date or time value results in an error. The solution is to ensure that the formula for the date and time operation is correct, or to change the format of the cell to a non-date and time type to display the value.

excel2007 update log

​ ​ ​Fix bugs

​​Update some functions