The author's message
Ten thousand Zhang tall buildings rise from the ground , Learn anything , We should lay a good foundation first , Only the basic knowledge is solid , Will be able to understand , Put this to use ！ Otherwise it's just a castle in the air , A mirage ！ Maybe you learned a lot before Excel Tips , But when you're at work , When there is a problem , And I'm at a loss , The reason why you are confused is that ： You haven't laid a good foundation , He who knows it knows not why , You always want to be opportunistic , Spend some unjust money to apply for some so-called crash course , As the saying goes ： More haste, less speed. ！ Ice three feet , Not a day's cold ,Excel It's very powerful , To master it , In the workplace , Not in a day ！ From today on, the Mavericks will lead you from Excel The basic part starts slowly , Step by step , Slowly but surely !
One 、 know Excel Work interface
We are learning Excel2007 When , First of all, understand Excel2007 The composition of the work window , As shown in the figure , At least you have to understand some related nouns , such as ： The title bar , status bar 、 What are tabs, etc , Where is it ？ How to show and hide ？ You have to understand this ？ Otherwise, when I refer to these professional terms later , You don't understand, eh ！
The function area consists of " Start "," Insert "," The page layout " And so on , Each tab contains groups of , The dialog box launcher is shown on the right side of some group names , Click it to launch the reorganization settings dialog box .
Two 、 Customize the Quick Access Toolbar
There are many ways to customize the Quick Access Toolbar , ad locum , I'll just talk about one of the most common ！
step ： Click the inverted triangle next to the Quick Access Toolbar , In the pop-up drop-down list, select " Other commands " Add the command on the left to the right , Then determine ！
OK, Is it simple , If you want to use a command function frequently in the future , Add it directly to the Quick Access Toolbar , You don't have to look for them one by one ！
3、 ... and 、 How to hide and display tab and ribbon settings
Sometimes when we edit spreadsheets , It needs to look simple , beautiful , You don't need a lot of toolbars , If it's a novice , See these heads are big , Okay , Today, I will tell you how to hide the ribbon tab
step ： Click the inverted triangle next to the Quick Access Toolbar , In the pop-up drop-down list, select " Minimize the ribbon " Check
At this point, the function area is hidden , Does it look simple and beautiful ？ Hee hee ….
Four 、 Introduction to the edit bar
The edit bar is divided into name boxes , Edit button area , Editing area , Press the inverted triangle in the upper right corner to expand the edit bar
5、 ... and 、 Selection of cells and ranges of cells
1、 The cell address consists of column and row labels , for example , Cell C8 refer to C Column number 1 8 Cell of row
2、 Consecutive cells can be used " The colon " Are identified , for example ："A3：D5" Represents a cell A3 To cells D5 A continuous area of
3、 Discontinuous cells can be used " comma " Are identified , for example ："A2,C8" Express A2 and C8 Two cells
4、 Cells in other worksheets ： When referring to cells in other worksheets , You need to add the name of the sheet before the cell name . for example ,"Sheet2!B6" Express "Sheet2" Cells in the worksheet B6
explain ： Cell name or reference in " Edit bar " Of " Name box " Inside
5、 Select a contiguous range of cells
Method 1 ： Use the mouse to drag from the start cell to the end cell
Method 2 ： Select the starting cell , Hold down Shift Key and click on the last cell
Method 3 ： Enter the address in the name box , For example, the input "A3：D5" Then press enter , Indicates the selected cell A3 To cells D5 A continuous area of , As shown in the figure below ！
6、 Select a discontinuous range of cells
Method 1 ： Select a cell , Hold down Ctrl Key while clicking on other cells .
Method 2 ： stay " Name box " Enter the address , For example, the input "A3：B4","D8,F6" Post press Enter key , You can choose A3 To B4 A continuous range of cells and D8 and F6 Two cells .
7、 Select rows or columns
Method 1 ： Click on the line number ( Column mark ), You can select the line ( Column ); Drag the line number ( Column mark ), You can select consecutive Multiple lines ( Multiple columns ); First of all 1 That's ok ( Column ), Hold down Shift Key while clicking on the last line ( Column ) Line number ( Column mark ), Multiple consecutive lines can be selected ( Multiple columns ), Hold down Ctrl Key while clicking on other lines ( Column mark ), Multiple lines with discontinuities can be selected ( Multiple columns ).
Method 2 ： stay " Name box " The reference address of the input line in the , For two line numbers ":" separate , For example, the input "6：6 It means to select the first 6 That's ok , Input "2：8", It means to select the first 2 Go to the first place 8 That's ok ; stay " Name box " Of the input column in the Refer to the address , Use... Between two column labels ":" separate , For example, the input "B:B", Indicated selection B Column , Input "B:F", Indicated selection B List to F Column （ As shown in the figure below ）
8、 Select all cells
Click... In the upper left corner " Future generations " Button , You can select all cells in the current sheet ; Select the data area Any cell of , Press shortcut key Ctrl+A, You can select the entire data area : If you select any cell outside the data range and press the shortcut key Ctrl+A, You can select all the cells in the sheet .
Okay , of Excel Let's call it a day , It will be updated regularly in the future Excel Basic course , Slowly but surely , Make progress with you ！ If in the process of learning , Meet the unclear place , Pay attention to my job number, which is the headline number “ Calf Excel” reply “88” Two words , For the former 200 We provide free Q & a guidance service and send workplace templates 3000 set , Covering daily finance 、 Personnel matters 、 Administration 、 Sales and so on , While helping others , And I've improved myself ！