Excel video tutorial set 25

The twenty-fifth set of computer videos excel

In the Windows 10 operating system, select the [Start] | [Microsoft Office] | [Microsoft Excel2010] command in order to start Excel2010. After startup, the Excel 2010 window will appear on the screen, including the following parts: 1. Title bar: Displays the name of Excel2010 and the name of the currently open workbook. 2. Quick Access Toolbar: Located below the title bar, you can quickly access commonly used commands and functions. 3. File menu: A green menu on the left below the title bar, through which you can save, open, close and other operations on the workbook. 4. Ribbon area: The ribbon area below the title bar, including commonly used function tabs, such as [Start], [Insert], [Page Layout], etc. Click a tab to expand the corresponding function panel. 5. Status bar: Located at the bottom of the Excel window, it is used to display the data status of the currently selected cell or cell range, such as sum, average, etc. 6. Control menu: Located in the upper right corner of the window, you can minimize, maximize the window, or close Excel by clicking the menu button. In addition to the basic Windows window components, Excel also has some special screen components, such as worksheet area, formula bar, name box, etc., which all provide convenient data processing and operation functions in the Excel window.

The worksheet is located below the name box and content box. The column labels are above, the row numbers are on the left, the vertical scroll bar is on the right, and the horizontal scroll bar is below. Each Excel file is called a workbook and contains multiple worksheets. A worksheet is a spreadsheet consisting of 1,048,576 rows and 16,384 columns, which can store various types of information, such as text, values, formulas, charts, and sounds.

The intersection of rows and columns in the worksheet forms a cell. The cell is the basic unit for storing information in the worksheet and is the smallest operation object for Excel data processing. In the Excel 2010 worksheet, there are a total of 17179869184 cells.

The cell surrounded by a thick black frame is the currently active cell, that is, the cell currently undergoing data input and editing. At any time, there is only one active cell. Only when the cell is activated can data input and modification operations be performed on it.

Just like coordinate values, row numbers and column labels identify the location of cells in the worksheet and constitute the cell address. As shown in the picture on the right, the active cell is A1, which means that this cell is in the first row of column A in the worksheet. The address C5 indicates that this cell is in the fifth row of column C in the worksheet.

In Excel 2010, a worksheet can have up to 1,048,576 rows and 16,384 columns.

The name box is located on the left side below the ribbon and is used to display the active cell address or the name of the selected cell, cell range, or object.

The content box is located on the right side of the name box and is used to display the data, formulas and functions in the active cell. The name box and content box form the edit bar.

The worksheet label is located at the lower left of the worksheet and is used to display the identification name of the worksheet. The background color of the currently opened worksheet tab is white, while the background color of non-current worksheet tabs is gray.

On the left side of the worksheet label, there are four label scroll buttons, which are used to scroll the worksheet labels. They are to scroll to the first worksheet label, to scroll to the previous worksheet label, and to scroll to the next worksheet label. and scroll to the last worksheet tab.

I hope I can help you clear up your doubts.

How to make a table video

Word table tutorial: making a table

There are 3 ways to create tables in Word.

1. Insert from the toolbar shortcut button.

Click the "Insert Table" button on the "Common" toolbar, and then drag the mouse to select the required number of table rows and columns to create a regular table. As shown below:

2. Insert from the menu.

1. Click "Table - Insert - Table" in the menu bar, as shown below:

2. The "Insert Table" window appears. In the "Table Size" option area, specify the number of columns and rows required for the table. You can enter the numbers directly or click the arrow next to it to enter, for example, 5 columns and 4 rows. Click the "OK" button. As shown below: l

3. Get a table with 5 columns and 4 rows, as shown below:

3. Manual drawing.

The above methods are used to create regular tables, that is, equidistant between rows and rows and columns. But many times, we need to make some irregular tables. In this case, we can use the method of drawing tables to complete the work.

1. Click "Table - Draw Table" in the menu bar, as shown below:

2. The "Table and Border" floating toolbar appears, and the mouse arrow automatically changes to the shape of a pen, as shown below:

2. Press the left button of the mouse where you want to insert the table and drag it to the lower right. Release the mouse at the appropriate position to get a table box.

3. Click the "Draw Table" button in the upper right corner of the "Table and Border" toolbar. The mouse arrow changes to the shape of a pen. You can drag the mouse to draw straight lines on the drawn table frame at will. , including horizontal lines, vertical lines, and diagonal lines. As shown below:

4. If you want to clear the unnecessary border lines in the table, click the "Erase" button on the "Table and Border" toolbar. At this time, the mouse pointer will change into an eraser shape, and move it to the desired position. At the erased border line, hold down the left mouse button and drag the mouse along the border line to erase the border line. As shown below

Word table tutorial: Select, move, copy, and delete tables (cells, rows, columns)

1. Select the cell content. Drag the mouse to select the contents of the cell. Double-click the mouse within a cell to select the entire contents of the cell.

2. Select multiple cells. Drag the mouse to select, as shown below:

3. Select columns. Move the mouse to the top of the column, the mouse arrow changes to a downward arrow, and click to select the entire column, as shown below. At this time, hold down the Ctrl key on the keyboard and click to select non-consecutive columns. At this time, drag the mouse to select multiple consecutive columns.

4. Select the entire row. Move the mouse to the left of the row, the mouse arrow changes to a right arrow, and click to select the entire column, as shown below. At this time, hold down the Ctrl key on the keyboard and click to select multiple non-consecutive lines. At this time, drag the mouse to select multiple consecutive lines.

5. Select the entire table. When you move the mouse inside the table or click on the table line, a cross arrow with a box will appear in the upper left corner of the table, as shown below:

At this time, move the mouse to the cross arrow with a box, and a cross arrow will appear on the mouse arrow. Click to select the entire table, as shown below:

6. Move, copy, delete. When a cross arrow with a box appears in the upper left corner of the table, move the mouse over it and right-click. A right-click menu will appear, and you can cut, copy, and paste the table, as shown below. It should be noted that when we select the entire table, pressing the delete key on the keyboard does not delete the table. It only deletes the contents of the table. You must select Cut to delete the table together

Word table tutorial: Adjust the row height and column width of the table

1. Adjust the row height. Point your mouse pointer over the lower edge of the row whose width you want to change until the pointer changes to a double-headed arrow shape, and then drag the edge down until you get the width you want. As shown below:

2. Point the mouse pointer to the right line of the column whose width you want to change until the pointer changes to a double-headed arrow shape, and then drag the edge to the right until you get the desired width. As shown below:

3. Average height of each row. If multiple rows need to have the same height, please select these rows, then right-click in the selection area, the right-click menu will appear, click and select "Evenly distribute rows", as shown below:

4. If you need multiple columns to have the same width, please select these columns, then right-click in the selection area, the right-click menu will appear, click and select "Evenly distribute each column", as shown below:

Word table tutorial: setting text direction

1. Right-click the mouse in the cell where the text direction needs to be changed, and the right-click menu will appear and click "Text Direction", as shown below:

2. The "Text Direction - Table Cell" window appears. It turns out to be horizontal text from left to right, as shown below:

3. Select the required text direction, as shown below, select the vertical text direction from top to bottom. You can see the effect from the preview area on the right, and then click "OK".

The above is the detailed content of Excel video tutorial set 25. For more information, please follow other related articles on the PHP Chinese website!