Introduction to excel - understanding the working interface of Excel
Old face of empty city 2020-11-26 12:48:13

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 !

Excel Basic introduction — know Excel Work interface


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 !

Excel Basic introduction — know Excel Work interface


Excel Basic introduction — know Excel Work interface


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

Excel Basic introduction — know Excel Work interface


Excel Basic introduction — know Excel Work interface


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

Excel Basic introduction — know Excel Work interface


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

Excel Basic introduction — know Excel Work interface


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

Excel Basic introduction — know Excel Work interface


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

Excel Basic introduction — know Excel Work interface


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 !

Excel Basic introduction — know Excel Work interface


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 .

Excel Basic introduction — know Excel Work interface


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 )

Excel Basic introduction — know Excel Work interface


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 .

Excel Basic introduction — know Excel Work interface


Excel Basic introduction — know Excel Work interface


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 !

版权声明
本文为[Old face of empty city]所创,转载请带上原文链接,感谢
https://fheadline.com/2020/11/20201126124645777f.html
相似文章

2021-08-09