On the drawing is a table consisting of 3 lines x 4 columns.
u After clicking and releasing the mouse, you will get a new table. However, in the same way, you can only create up to 4 lines x 5 columns
Method 2:
Go to Table> Insert> Table .
The Insert Table dialog box appears:
Table size: Table size:
Number of Columns: Enter the column number
Number of rows: Enter the line number
AutoFit behavior: Auto-scaling
Fixed column width: Set fixed column size
AutoFit to contents: Automatically shrink content
AutoFit to window: Automatically shrinks according to the window screen.
AutoFormat: Select the type of table format available.
Remember dimensions for new tables: Remember the sizes for new tables.
Select the OK button.
4. Add columns & lines
Method 1: Use a pen
Go to Table> Draw Table (Or click on the icon on Standard bar)
Move the brush to the table and drag the line in the table directly into the position where you want to insert the column (line).
Method 2:
Place the cursor in the table. Go to Table> Insert
- Columns to the left: Add the left column - Columns to the right: Add the right column - Rows Above: Add the above line - Rows Below: Add the bottom line - Cells .> Insert entire column: Insert columns for the whole table - Cells .> Insert entire row: Insert lines for the whole table.
5. Delete cells, rows, columns, tables
Go to Table> Delete
Tabe: Delete the table
Columns: Delete column
Rows: Delete line
Cells .: Delete the cell of choice
Shift cells left: Delete the cell to the left
Shift cells up: Delete the box below
Delete entire row: Delete the entire row
Delete entire column: Delete the entire column.
6. Select (black out) in the table
You can use a combination of Shift and arrow keys, Page Up, Page Down, Home, End to highlight in the table. It can also be used in a way:
1. Go to Table> Select
Table: Black out the table (Or use the shortcut key Alt + number 5 with Num Lock lamp off)
Column: Column
Row: Line
Cell: Oh
7. Enter the cell
Black out the cells you want to enter horizontally or vertically.
Go to Table> Merge Cells
8. Split the cell
Go to Table> Split Cells .
The Split Cells dialog box appears
Number of columns: Enter the number of columns to divide
Number of rows: Enter the number of lines to divide
Merge cells before split: Enter the cells before dividing.
Select the OK button to agree to divide the cell.
9. Table style format available
Go to Table> Table AutoFormat .
The Table AutoFormat dialog box appears
Category: Select is All table styles
Table styles: Select the available table formats of MS Word
Apply special formats to: Apply special format to:
Heading rows: Headline of the table
First column: The first column of the table
Last row: The last row of the table
Last column: The last column of the table
New button . : Create your own new table format.
Name: Format type name
Style base on: Basic format type
Apply formatting to: Apply the following formats for:
Whole table: Full table
Header row: Headline row
Last row: The last line
Left column: Left column
Right column: Right column
Odd row stripes: Borders for odd lines
Even row stripes: Borders for even lines
Odd column stripes: Borders for individual columns
Even column stripes: Borders for even columns
R Add to template: Add a new template
Select the OK button to complete adding a new format.
Modify button . Modify the selected style. The features use the same new addition to the table format
Delete button: Delete the table format type
The screen appears: Do you want to delete the Table Style1 format? Let you make sure you want to delete.
Default . button: Set the default format for the following tables:
This document only: Only applicable to the current file
All documents based on the Normal.dot template? For all other files with Normal.dot format
Select Apply> Close button.
10. Set automatic table scaling mode
Go to Table> AutoFit
AutoFit to Contents: Automatically shrinks by content.
AutoFit to Window: Automatically scale according to the Window screen.
Fixed Column Width: Fixed the width of the column. In this case, you just use the mouse to drag the vertical line along your alignment.
Distribute Rows Evenly: Divide the height of the equal lines.
Distribute Columns Evenly: Divide the width of the columns equally.
11. Convert data from tables into text (Remove tables but still keep enough content in the table)
Go to Table> Convert> Table to Text .
The Convert Table To Text dialog box appears:
Separate text with: Select the type of separation between paragraphs of text:
Paragraph marks: In paragraph form
Tabs: By distance is 1tab = 1.27cm
Commas: Comma
Other: Other characters
Select the OK button to complete.
12. Convert data from text form to table
Select (black out) the paragraphs you want to include in the table:
Go to Table> Convert> Text to Table .
The Convert Text To Table dialog box appears:
Number of columns: Enter the column number
Number of rows: This line number entry is not entered, but because MS Word adjusts to the number of columns you enter above.
AutoFit behavior: Auto-scaling
Fixed column width: Set fixed column size
AutoFit to contents: Automatically shrink content
AutoFit to window: Automatically shrinks according to the window screen.
Separate text with: Select the type of separation between paragraphs of text:
Paragraph marks: In paragraph form
Tabs: By distance is 1tab = 1.27cm
Commas: Comma
Other: Other characters
Select the OK button to complete.
13. Sort data in tables
Black out the whole board. Here you should black out the entire table because after sorting by one or more columns, the values of the other columns are also sorted. If you only black out one column, the data is sorted only by that column, so your data in the whole table will be misleading.
Go to Table> Sort .
The Sort dialog box appears.
Sort by:
Please select the first column name you want to sort (On the image is the Month column)
Type: Type of format of column (field) sorted (Text, Number, Date .)
Ascending: Sorting up gradually
Descending: Sort descending
The parts Then by: Sort by the next column (the features are still the same as Sort by).
Có danh sách có:
Header row: Headline row.
No header row: Sorting is not except the subject line.
Select the OK button to complete the arrangement.
14. Some functions apply to MS Word tables
Let the cursor position in the cell you want to calculate (For example, calculate the sum of the column, leave it in the last row of the column).
Go to Table> Formula .
A Formula dialog box appears.
Formula: Display function, calculation formula. Starting each function or formula must start at the sign '=' (SUM (ABOVE): The province of the above values). You must fill in the correct formula for each function.
Number format: Digital format formats.
Paste Function: Basic functions:
ABS: Absolute treatment
AND: Function and
AVERAGE: Calculate average
COUNT: Count
IF: Conditional function
INT: The function divides the integer part
MAX: Largest function
MIN: The smallest function
MOD: The function divides the remainder
NOT: Negative function
OR: Function or
ROUND: Function rounded
SUM: Sums
Select the OK button to complete the calculation. If the formula is wrong, the result will show the command line! Syntax Error Results The calculation function of the above worksheet is:
15. View table format properties
Go to Table> Properties:
The Table Properties dialog box appears: Table Card: Table information
excel is a powerful tool for data analysis and automation after processing large data sets. you can spend considerable time analyzing tons of data using vlookup, index-match, sumif...
in this section, you are ready to create a table for the new database. in chapter 2, you used the table wizard to create tables easily. this not only shows that creating a table manually is difficult; but it is a sure way to understand the table.
the relationship between tables is the data link between tables. by defining table relationships, you can drag records from related tables based on relational fields.
in the process of creating tables on word, sometimes you need to delete some table lines to meet needs or make the table easier to see. so how can i delete the table line and keep the content in word?
in this lesson, you will learn how to create and rearrange fields in tables, how to ensure data is formatted correctly and consistently by setting validation rules, character limits, and data types in the school
how to create a table in word will help you easily list and summarize data in documents. this is one of the basic word skills that everyone needs to know, so you should master how to create word tables to start getting acquainted with this software.
the query allows to retrieve information from one or more tables based on the search conditions you defined. in this lesson, you will learn how to create queries on a simple table and query on multiple tables in access 2016.
after inserting tables into excel, users can format the borders and background colors for the table according to the different interfaces that excel provides.
for better data management in excel, creating tables for excel data is essential. you can easily search, calculate, manage and analyze data ... but the way to create tables is very simple, so you can quickly create tables in the