Quick Start of Table Making (How to Adjust Lines in Quick Start of Table Making)

Tools/raw materials:

LenovoG700、Windows 10、Excel202 1 .

1, enter table data.

Enter the excel software interface, select a blank cell, enter your table data in the cell, and then click the Start tab at the top.

2. Set the font color

Set your font color, and then set your favorite style in the table style on the right.

3. Click the Save button.

After setting, click the Save button in the upper left corner, set the file name and save path, and click Save.

A quick introduction to making simple tables

You can operate as follows:

The necessary steps to make interface tables in Excel are to set a uniform background color, the gradient is more beautiful than the general monochrome, the font format should be coordinated with the background color, and text should be added below the icon to keep the whole table color in the same color system.

Step 1: Fill the table with light gray.

The necessary step to make an interface table in excel is to set a uniform background color.

Step 2: Set the white fill color of the line where the icon is located, then insert the text box to set the gradient color, enter the text, and set the font as Chinese color text.

Gradient looks better than ordinary monochrome, and the font format should be coordinated with the background color.

Step 3: Add icons by copying, pasting or inserting, determine the position of the first and last icons, and then use the top alignment and horizontal distribution in the picture tool to align the pictures.

Step 4: Add text below the icon. Insert text box-enter and set font-delete border line. Finally, use the third step method to align the text.

Step 5: Set the development tool-Insert-Frame-to 3D format.

Step 6: Add a dark blue painting axis on it.

Keep the color of the whole table in the same color system. The axis above can be gradually changed, and the light color in the middle can make the characters more stereoscopic.

Step 7: Set the hyperlinks and descriptive text displayed when the cursor hovers.

Right-click-hyperlink-location of this document-select the table, click "screen prompt" and enter the prompt text.

So far, the interface has been completed.

A quick introduction to table making

1. First, open Excel and select the table area to be made.

2. Then select "Apply Table Format".

3. Choose a basic background color that you like and conforms to the shape you want to do.

4. Enter a title. You can choose to center, bold font size or choose another font.

5. Right-click in the lower left corner to modify the basic contents such as the color and name of the label.

fundamental function

Start: Set the basic format, font size, color, symbols, etc. On the table.

"Insert": insert various pictures, icons, headers, footers, etc.

Page layout: adjust the size, format, theme, etc. Newspaper.

Formula: Perform some basic formula operations on the data in the table.

Data: Filter, sort and delete copies of existing data.

Review: Annotate tables, protect cells, etc.

"view":

"Design": Mainly design some styles of tables.

12 Basic skills necessary for Excel Office

In practical office, we often have to deal with tabular data. If your Excel worksheet skills are not in place, others will have to work overtime after work. The following are my basic skills for 12 Excel office. Welcome to read and share.

catalogue

Basic skills necessary for Excel office

Commonly used Excel shortcut keys

How to automatically increment Excel serial number?

12 Basic skills necessary for Excel Office

1. How to locate cells quickly?

Method 1: Press F5 to open the Location dialog box, enter the address of the cell to jump to in the reference column, and click OK.

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

2. Special functions of "Ctrl+"

Generally speaking, when dealing with a table with a lot of data in the worksheet, you can select a cell in the table and then press Ctrl+ to select the whole table. Ctrl+ The selected area is determined as follows: The largest area with data cells radiates to the surroundings according to the selected cells.

3. How to quickly enter the same number in different cells?

Select a cell range, enter a value, and then press Ctrl+Ener to enter the same value once in the selected cell range.

4. How to make the workspace on the screen bigger?

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

5. How to use the pop-up menu?

The shortcut menu contains some commonly used commands in operation, which can greatly improve the operation efficiency. Select an area first, then click the right mouse button to pop up a pop-up menu, and select different commands according to the operation needs.

6. How to prevent Excel from opening too many files automatically?

When Excel is started, it will automatically open all files in the Xlstart directory. When there are too many files in this directory, it is not only time-consuming but also error-prone to load too many files in Excel. The solution is to delete files that should not be in the Xlstart directory. In addition, it is also necessary to prevent Excel from opening files in the alternate startup directory: select the tool option Normal and delete all the contents in the column of the alternate startup directory.

7. How to report in a quick format?

In order to make a beautiful report, it is necessary to format it. A shortcut is to automatically apply the default table style of Excel. The method is: select the operation area, select the AutoFormat command from the format menu, select a format style you are satisfied with in the format list box, and press the OK button. It should be noted that under the format list box, there are six "Apply Format Type" options, including numbers, border lines and fonts. If the "x" in front of the item does not appear, it will not be used when applying the table style.

8. How to slash the table?

Generally, we are used to drawing diagonal lines on tables, but the worksheet itself does not provide this function. In fact, we can use the drawing tool: click the "Draw" button and select "Line", and the mouse will become a cross. Move it to the starting position where you want to add a diagonal, hold down the left mouse button and drag it to the ending position, then release the mouse and the diagonal will be drawn. In addition, you can easily add text above and below the diagonal by using the Text Box button, but there is a border around the text. To cancel it, you can select the text box, bring up the pop-up menu, select Object Format and Pattern, and select Borderless.

9. How to define your own function?

Users can define functions in Excel. Switch to VisualBasic module, or insert a new module table, type the custom function VBA program in the blank program window that appears, press enter to confirm and complete the writing, and Excel will automatically check its correctness. Later, in the same workbook, you can use custom functions in the worksheet like Exed internal functions, such as:

function

Ifa60Thenim =' failed'

ElseZm= "Pass"

EndIf

End function

10. How can I prevent the colors and shading in the cell from being printed?

For those protected cells, you can also set colors and shading, so that users can see at a glance that those cells cannot be modified after protection, which can increase the intuitive feeling of data input. But it brings a problem, that is, when printing in black and white, the visibility of the table will be greatly reduced if color and shading are printed. Solution: Select File Page Setup Worksheet, and select the option of printing cells in monochrome in the print column. After that, the printed form will still look the same.

1 1. What if I forget the password for worksheet protection?

What can I do if I want to use a protected worksheet but forget my password? Yes Select the worksheet, select Edit, Copy and Paste, and copy it into a new workbook, which can go beyond the worksheet protection. Of course, I remind you that it is best not to steal other people's worksheets in this way.

12. How to reduce repetitive work?

When we actually apply Excel, we often encounter repeated applications of some operations. In order to reduce repetitive work, we can define some commonly used operations as macros. The method is as follows: Select the macro command in the Tools menu, record a new macro, and press the stop key after recording. You can also use VBA programming to define macros.

Commonly used excel shortcut keys

1.Ctrl+ number keys

Press CTRL+ 1- to pop up the cell format dialog box.

Press CTRL+2- to remove bold formatting from cells.

Press CTRL+3- Cancel formatting skew in cells.

Press CTRL+4- Unformats the underline in the cell.

2.Ctrl+ letter key

Press ctrl+a- to select the entire worksheet.

Press CTRL+B- to cancel the bold formatting in the cell.

Press ctrl+c- to copy the selected cell.

Press ctrl+f- to pop up the find and replace dialog box.

Press ctrl+g- to pop up the positioning dialog box.

Press ctrl+n- to create a new blank worksheet.

Press ctrl+p- to pop up the print dialog box.

Press CTRL+W- to close the selected workbook window.

Press ctrl+x- to cut the selected cell.

3.Ctrl+shift+ Letter Keys

Press ctrl+shift+o- to select all cells containing comments.

Press ctrl+shift+p- to directly open the font tab in the cell format dialog box.

Press Ctrl+Shift+U- Toggle the formula bar back in the expanded and collapsed state.

4.Ctrl+shift+ punctuation

Press Ctrl+shift+ colon-enter the current time in the selected cell.

Press Ctrl+shift+ quotation marks-copy the value in the cell above the current cell into the current cell.

Press Ctrl+shift+ plus sign-the Insert Cell dialog box pops up.

5.Ctrl+shift+ Special Symbol

Press CTRL+SHIFT+#- Displays cell values in year, month and day formats.

Press CTRL+SHIFT+$- to display cell values with two decimal places in currency format.

Press CTRL+SHIFT+%- to display the cell values in a format with a percent sign.

Press Ctrl+Shift+@- to display cell values in time format.

How to automatically increment excel serial number?

Open the excel table and enter the first number.

Move the mouse to the lower right corner of the cell.

Then the mouse pulls down.

You can fill in the numbers automatically and increase them automatically.

12 article on the essential basic skills of Excel office;

★20 useful Excel office software practical skills

★ Practical skills of ★Excel office software

★ Basic knowledge about Excel

★excel2003 collaborative office method

★ Ten Skills for Quickly Improving Excel Efficiency

★ The simplest table making methods and skills

★ The most commonly used Excel function formula daquan

★ Introduction to ★excel2007

★ Common excel office functions

var _ HMT = _ HMT | |[]； { varhm = document.createElementhm.src =vars = document . getelementsbytagname[0]； s . parent node . insert before； });

Excel table making tutorial

So how does excel make tables? Here is an introduction to the operation process of excel in making tables.

1. First, open the excel file in the computer, use the mouse to select the required number of columns and rows in the table, click the right mouse button, and click "Cell Format".

2. Click "Border", select "Outer Border" and "Inner Border" in "Preset", and click OK.

3. Then use the mouse to select the title bar of the table, click the right mouse button, click Align, select the merged cell, and then click OK.

4. Then use the mouse to select all rows and columns of the table, click the right mouse button, click Alignment, set both horizontal alignment and vertical alignment to "Center", and click OK.

5. Finally, enter all the contents of the form to be made, and click Save in the upper left corner to finish making the form.

Beginners learn how to make tables with computers.

Making tables with Excel.

In the Excel table, we can click the vertical line in the middle of the upper letter and the horizontal line in the middle of the left number to adjust the length and width of the cell.

2. After entering two numbers in the first two series cells in turn, select the number circle and drop it down to automatically fill in the number sequence.

3. You can box multiple pieces of data to be copied in the Excel table, and press CTRL+C and CTRL+V to copy in batches in the table.

4. Click Find in the search and selection in the upper right corner to find data quickly and accurately in Excel.