Excel common problems and solutions: improve your Excel skills

Due to the complexity of Excel software and users face a variety of problems in daily use, we need to carefully study and understand the functions of Excel. The following is a list of common problems and solutions of Excel,word to pdf converter free download offline which I hope will help you!

Common problems and solutions

Why can't the heart and mind make peace?

90% of the reasons are alphanumeric.

1, Solution:

(1) If the number has a green triangle, select the region,pdf split and merge download online and then open the green triangle - convert to a number.

(2) If there is no green triangle, use the method of selective paste: copy the empty cell - selective paste - paste operation: Add

2, Excel how to fill in the null value of all the valid "0"

Location-Edition-Null Value-type 0 in the edit field, and then press ctrl enter to complete the input

3, How to use Excel to generate random numbers

Excel provides a RAND function, which can generate a specified range of random numbers: =rand()_(mr_)

=rand()_ (max-min)+min. For example, to generate a random number between 10 and 100.

=rand()_ 90+10

What if you want to generate random integers?

=int(rand()_90+10) can also be used = between (1100) rand

4, one-half how to type

First enter 0, then enter a space, and finally enter 1

5, Excel how to print discontinuous work area

Press the Ctrl key does not release, select the region, and then click the File menu in the print area - set the print area

6. Excel can not open how to do?

Excel file can not be opened, there are many reasons.

The file is corrupted. At this time you can only find some professional repair software.

 Load macro file, load macro file is to hide the information window.convert word to pdf with embedded excel files You can open it by loading macro file xla or xlam changed to the normal xls file and xlsx file system of the enterprise.

Open the file, you will not see the Excel interface. At this point, you can try to open the Excel file by using the open command in the toolbar. Then, by selecting Ignore other applications on the General tab of the Options window, you can open the Excel file as usual!

7. How to solve the problem of copying a table from the Internet and pasting it into excel will have a lot of small graphics?

Solution: CTRLG Position - Position Conditions - Object - Delete

8. Open multiple worksheets in Excel, prompted by "insufficient memory to display", how to do?

At this time, we first need to close all applications in the enterprise system programs, click on the desktop using the right mouse button, from the pop-up shortcut management menu, select the "Properties" option, in the open "Display Social Properties" dialog box, click on the "Settings" option "Settings" tab, set the "Color" drop-down list box to 256 colors, you can get to solve these problems.

If your computer is Windows XP, you can't set 256 colors in the color area, just create a shortcut for a piece of software, then right-click on the shortcut, find the compatible display settings and set it to 256 colors.

9. How can I make the workspace on the screen larger?

You can hide unused toolbars, maximize the Excel window, or choose the Full Screen Display command from the View menu.

10. How to quickly locate cells?

Method 1: Press the F5 key, the "Positioning" dialog box appears, in the reference column, enter the cell you want to jump to the address, a single city "OK" button system can be.

Method 2: Click the left side of the edit bar cell address box and enter the cell address.

11. How to quickly copy? Cell formatting?

To copy the formatting operation to another piece of data, use the formatting brush button. Select the cell containing the desired source format, click the Format Brush button on the toolbar, which changes the mouse to a brush shape, and then click the cell to be formatted to copy the format.

12. Excel determines whether the score passes. What should I do?

excel to determine whether the score study results information pass or not can be used IF for the study interval judgment.

= such as (a 1 > 60, "pass" , "fail")

13. Why don't you make the number bigger when copying from Excel sheet? How can I increase?

When copying a number, just press Ctrl and scroll down, the number will change.

14. We type "123456789" in an excel cell and then gradually reduce the column width, we will find that when the number can't be displayed completely, it will automatically become # # #. What happened?

This is the business because for we do not understand excel column width knowledge can lead to. When the number of cells in the technology can not be fully data display, it will be displayed in the "#" sign. Encountered this social problem, we students just need to excel column width (double-click on the right column margin is the fastest way) completely research display Chinese figures can be.

15. what if Excel 0 does not start?

Enter a "(single quotes) before you enter the number, then enter a number starting at 0.

Cell formatting is converted to text formatting. Select cell - press CTRL + 1 (number 1) - Number - text

16. Excel cell date how to automatically display the current date?

In the cell enter = TODAY (), the file system will automatically update the development time.

How to quickly enter the current date and time

Click the cell and press [Ctrl]+[;] to enter the current date;

Click the cell and press [ Ctrl ] + [ Shift ] + [ ; ] to enter the current time.

18. How to paste a table into another table every other column?

Solution to the teaching method: the use of selective can be pasted - skip the null: press ctrl not loose respectively by selecting the empty columns after inserting, and then a skip the null value of the paste!

Excel table of basic operation tutorials

Statistical scores

Sometimes you need to use the score to count the number of people, such as the number of 90 points, the number of 80 points and so on. Let's look at an exercise.

1, start Excel

1) Click "Start All Programs - Microsoft - Microsoft OfficeExcel2003" ;)

2) appear a blank window filled with a grid, which is a spreadsheet. The first grid looks thicker and is selected;

2, statistics score paragraph

1) input to carry out a 8 grades of the results table, including business serial number and grades, and enter 90-100, 80-89, 70-79, 60-69, 0-50 a few student segments ;)

2) select the "0-50" right cell, in the edit field press FX key to enter the formula, and then press FX key to enter the formula.

from low to high segments, counting the lowest score first;

3) in the list of functions that appear, select the middle of the "All", and then in the list below, select COUNTIF and click OK; 4) Next is COUNTIF.

4) Next is the COUNTIF function panel. Drag the mouse to select all the fractions. This is the range;

5) Then, in the second row, click on Conditional, switch to English, type in less than and 60, and click OK: < 60 so you can calculate the number of people below 60; 6) Check the box "COUNTIF" and click OK.

6) select the "60-69" paragraph next to the cell, click on the edit bar in the fx, ready to enter the formula;

7) in the out of the function for the panel, but also select the COUNTIF function, and then point "OK" button.

Drag this shape, you can select all the scores in the second line of the conditions entered less than 70, and then click "OK": < 70

8) back to the form window, in the edit box, click on the formula behind, and then enter a minus sign, click on the number of points just counted 0-59, and then click on the right side of the green check mark to confirm.

Because 70 points in addition to 60 points, including 50 points below, minus 50 points left is more than 60 points ;.

(Learn computer basics, introductory computer knowledge, please go to http:u002Fu002Fcomputerknowledge.com)

(9) also in our selection of 70-79 right cell, select the COUNTIF function, enter the data in the conditions less than 80

Click "OK", back to the editorial column, and then click the mouse, subtract just calculated 50 paragraphs and 60 paragraphs; and

10) Similarly, the number of 80 paragraphs, subtract the two ends, leaving the center, to find the required score paragraph;

For scores 90-100, enter > = 90 (greater than or equal to 90) in the conditions

Save the file to your own folder with the filename "score band";

In this section, you have learned how to count fractions in Excel, if you have successfully completed the student exercise, please continue with the next lesson in the learning environment.

Excel how to merge cells

Today a netizen asked the author on QQ a question about cell merging in excel, but I can't find how to merge. In response to this problem, the author today to describe in detail "how to merge cells in excel" methods and steps, I hope that those who are just not familiar with excel software to help friends.

excel tips

Tip 1: first look

In order to enable users to browse a large amount of data in the worksheet, Microsoft Office Excel 2007 in each worksheet to support up to 1,000,000 rows and 16,000 columns. In other words, the capacity of a single worksheet in Excel is 1048576 rows times 16384 columns. Compared to the 2003 version of Excel, Excel offers a 1500% and 6300% increase in the number of available rows and columns, respectively, a significant increase in capacity. In addition, Excel 2007 supports up to 16,000,000 colors.

And we can now, in the same social workbook to use an unlimited number of different types of formatting, and no longer just limited to 4,000 kinds; each cell of the cell through the number of references to the literature from 8,000 growth affects the number of their own arbitrary enterprise, the only limit students should be the test of computer system memory. In order to carry out the improvement of Excel's performance, Microsoft will memory resource management from the 2003 version of Excel in 1GB memory to 2GB, a full double. Since Excel 2007 supports dual processors and multi-threaded control chip set, users will also contain a large number of formulas need to be included in a large company worksheets to experience a better and faster computing processing speed.

Tip 2 flexible to Excel documents to add headers and footers

Regular users of Excel may know that in the past to add headers and footers to Excel documents has never been an easy thing to set up layers of dialog boxes to complete the task. But now Excel can be fully previewed in the page view to add headers and footers to Excel documents, the process is simple and intuitive. The operation is as follows: 1.

1. In Excel's functional areas, click the "Insert" tab.

2. In the "Text" group, click the "Header and Footer" button.

3. In the "Ribbon" will continue to appear "Header and Footer Tools" contextual information related to the data tab, in which the "Design" tab provides us with the country needs The "Design" tab provides all the commands we need to develop a very intuitive way to genetically edit the headers and footers of Excel documents.

Excel spreadsheets can be very simple!

Tip 3 Beautify the table as soon as possible.

In the latest Excel worksheets, users can focus all of their attention on entering important data without having to spend any effort on table formatting and operational appearance, thus reducing the amount of labor. Let Excel help you to beautify the form as fast as possible. The steps are as follows.

1. Navigate to any cell containing data.

2. In the "Start" tab of the "Style" group, select the design of a "form data format to apply a". 3.

3. pop-up "Format Table" dialog box, specify the source of the table data.

4. Click OK button, it will automatically add the title of the table text color, the title cell fill color, as well as the fill color of the intervening rows, and will also be converted into a list of form areas, to get a list of many features, such as automatic filtering and so on.

Tip 4 automatically apply the appropriate formatting and automatic creation of calculated columns

When you need to add a new column to an existing table, Excel can automatically apply the existing formatting without resetting it. In addition, you can quickly create calculated columns in Office Excel sheets. Calculated columns use a formula that applies to each row, which automatically expands to include other rows, so the formula can be expanded to those rows immediately. You only need to enter the formula once, without having to use the Fill or Copy commands. The steps are as follows.

1. When you want to add a new column, simply enter a new field name on the right side of the Excel form, press 【Enter】 key will be realized automatically can add a column and automatic mode set appropriate use of formatting.

2. Navigate to the "E3" cell, and enter the formula used to calculate the total. Press [Enter] key, the formula will be automatically filled to the end of the list, all the total amount will be calculated, and will automatically create a calculated column.

If the table is very long, you don't have to drag it down like you used to, and you can never find the end. It's much easier to use.

Tip 5 quickly carry out the deletion of reused data

Even with the help of Excel to deal with a large amount of data, it is inevitable that errors will be encountered, look at the time of data entry is often repeated. Although we double-checked over and over again, but sometimes it is really difficult to find such an error. This time there is a greater need to use Excel, then this problem can be easily solved.

1. Select we need to check and remove the duplicate student cell through the region, and click the "Ribbon" in the "Data" tab. 2.

2. In the "Data Tools" group, click "Delete Copy" button.

3. At this point, open the "Remove Duplicates" dialog box, select the need to check the duplicate value of the column.

Four. After the installation is complete, click the OK button, Excel will recheck the selected columns and prompt the results.