How to make a table in Microsoft Excel

Creating a table in Microsoft Excel is one of the basic techniques that must be mastered if you work with Excel. Working on school assignments, coursework or work that requires Excel to complete the application, you must know the basic techniques How to make a table in Microsoft Excel. Actually very simple and easy to create a table in Microsoft Excel, but for us who have not been using Microsoft Excel may not know how to create the table.

How to create a table in Microsoft Excel

Steps to create a table in Microsoft Excel is as follows:

1. Open the Microsoft Excel application
2. Select the cells that you want to give the table
3. Select the table button in the menu bar (home). To select a table with different thickness and appearance select more border.
4. Finish

Add and Delete Columns and Rows in Excel

Add and Delete Columns and Rows in Excel - Sometimes we need additional rows and columns in an excel worksheet that we use. Likewise, when certain emerging desire to remove some of the columns and rows in Excel. And it turns out how to add and delete columns and rows in Excel is very easy, even without reading the article even this fact you may already be. Only by using the click of a mouse on your computer.

Adding Rows and Columns

ADD ROW

1. To insert a row into the spreadsheet with the mouse pointer, right click on the header row below where you want the new row is added.
2. Select "Insert"
3. The new line will be inserted at the top of the line that you choose.
4. To add more than one new row, select more than one line in the header row.
5. On the header row, pull the number of lines to be added to the spreadsheet.
6. Right-click on the selected row.
7. Select Insert from the menu.
8. The new line will be inserted at the top of the first line that you select.

ADD COLUMN

1. To add a column to the spreadsheet with the mouse pointer, right click on the column header where you want the new column is added.
2. Select "Insert"
3. The new column will be inserted to the left of the selected column.
4. To add more than one new column, we select more than one column in the column header.
5. In the column header, drag select the number of columns you want to add to the spreadsheet.
6. Right-click on the selected column.
7. Select "Insert"
8. The new column will be inserted to the left of the selected column.

Deleting Rows and Columns

Before you remove, it is important to note that any data that is located in the deleted row or column, will be deleted as well. If you make a mistake, use the Undo from the Edit menu to get your data back or by pressing Ctrl + Z.

1. To delete a row from a spreadsheet, right-click on the row header row you want to delete and then select "Delete"
2. To remove a few rows of the spreadsheet In the header row, select the row you want to delete. Right-click on the selected row, and then select Delete.
3. To delete a column of the spreadsheet, right click on the column you want to delete. Select Delete.
4. To remove some of the columns of a spreadsheet, In the column header, select the column you want to delete. Right-click on the selected column. Select Delete.

What changes occur

When you add or delete columns or rows, the cell references in functions and formulas will usually update automatically. For example, if you have a cell reference in the formula A11 and then add a line at the top of this, the formula will change the reference from A11 to A12 to reflect the fact that the line 11 is driven down into 12 rows after a new row is added.

How to Change Column Width and Row Height in Excel

How to Change Column Width and Row Height in Excel? In Microsoft Excel Spreadsheets worksheet, you can change the column width or height of rows in the worksheet to improve the readability and appearance of data. For example, if a worksheet contains a lot of numbers, you can expand the column to make the worksheet more tidy. You should always extend a column that contains cells with text or number entry (shown) is cut off in an Excel worksheet.
Based on the standard font Calibri size 11, the default column width is 8.43 and the standard line height is 15. If you change the font type and size standard, Excel also can change the column width or height alone standard line.

Adjust the column width

Follow the steps below to adjust the column width (change column widths in excel):

1. Select the column whose width you want to change. Select multiple columns if you want more than one column to be changed.
2. Click the letters column. If you want to set one column, click a cell in the column. For example, column A or column B, and so on.
3. To manually change the column width, position the mouse pointer on the boundary between one column to another column until it turns into a double-sided arrow. For example, to change the width of column A, then click on the line that constitutes the border with column B. Pull up the width of the column you want.
4. To change the column width automatically and with regular size, click on the column (eg: click column A).
5. Then right click and select "Column Width".
6. Fill in the numbers that would be the width of the column.

Change the row height

To change the height of one or more lines, follow these steps:

1. Select the row that you want to adjust the height.
2. To select an entire row, click on the row number on the left. If you want to set up one row, click the cell in the row.
3. To manually change the row height, position the mouse pointer on the lower boundary line of the title until it turns into a double-sided arrow. Pull until the row is the height you want.
4. To change the line width automatically and with regular size, click on the line (eg: click column A).
5. Then right click and select "Row Height".
6. Fill in the numbers that would be the line width.