MS Excel - Lesson 4: Working with lines, columns, sheets

In addition to the content of tables in Excel, operations with lines, columns and sheets in this program are also important. In this article, TipsMake.com will guide you to simple operation to add or remove lines, columns or sheets in Excel tables.

In addition to the content of tables in Excel, operations with lines, columns and sheets in this program are also important. In this article, TipsMake.com will guide you to simple operation to add or remove lines, columns or sheets in Excel tables.

1. Working with lines in Excel

If you want to add a line:

  1. With the insert line, the new line will be inserted above the current line.
  2. Method 1 : Place the cursor at the line to insert, go to Insert> Rows.
  3. Method 2 : Click the right mouse button to enter the name of the line to insert, select Insert

MS Excel - Lesson 4: Working with lines, columns, sheets Picture 1MS Excel - Lesson 4: Working with lines, columns, sheets Picture 1

  1. Method 3 : Right-click on the cell at the line to insert, select Insert > select Entire rows > Ok

MS Excel - Lesson 4: Working with lines, columns, sheets Picture 2MS Excel - Lesson 4: Working with lines, columns, sheets Picture 2

To delete the line:

  1. Place the cursor at the line to delete, go toEdit > Delete . > select Entire row > Ok.
  2. Right-click on the line name to delete, selectDelete

MS Excel - Lesson 4: Working with lines, columns, sheets Picture 3MS Excel - Lesson 4: Working with lines, columns, sheets Picture 3

If you want to hide or show the line:

Sometimes with spreadsheets that are too long you need to hide some unfamiliar lines that are easy to control, you do the following:

  1. Black out the lines to hide, go toFormat > Row > Hide or right-click and choose Hide:

MS Excel - Lesson 4: Working with lines, columns, sheets Picture 4MS Excel - Lesson 4: Working with lines, columns, sheets Picture 4

  1. When you need to review the hidden lines, blacken the two lines adjacent to the hidden area (if hiding lines 3 and 4, you must highlight lines 2 - 5) -> go toFormat > Row > Unhide. ( Another way is to right-click and choose Unhide):

MS Excel - Lesson 4: Working with lines, columns, sheets Picture 5MS Excel - Lesson 4: Working with lines, columns, sheets Picture 5

Line height:

If you want to change the height of the line, you can use the mouse pointer to enter the line separating the two line names and drag it or you can do the following:

  1. Go toFormat > Row > Height , type the height of the line> Ok, or right-click and select Row Height as shown below:

MS Excel - Lesson 4: Working with lines, columns, sheets Picture 6MS Excel - Lesson 4: Working with lines, columns, sheets Picture 6

  1. You can fix the height of the cell corresponding to the data in the cell by going to Format > Row > AutoFit or double-clicking on the line between two line names. With Excel 2010 and above, select the Home> Format> AutoFit Row Height tab as shown:

MS Excel - Lesson 4: Working with lines, columns, sheets Picture 7MS Excel - Lesson 4: Working with lines, columns, sheets Picture 7

2. Manipulate columns in Excel

To add a column:

With column insertion, the new column will be inserted to the left of the current column:

  1. Method 1 : Place the cursor at the column to insert, go to Insert > Columns.
  2. Method 2 : Click the right mouse button to enter the column name to insert, select Insert.

MS Excel - Lesson 4: Working with lines, columns, sheets Picture 8MS Excel - Lesson 4: Working with lines, columns, sheets Picture 8

  1. Method 3 : Right-click the cell in the column to insert, select Insert > tick Entire columns > Ok.

To delete a column:

Place the cursor at the column to delete, go to Edit > Delete . > select Entire column > Ok.

Right-click on the column name to delete, select Delete.

MS Excel - Lesson 4: Working with lines, columns, sheets Picture 9MS Excel - Lesson 4: Working with lines, columns, sheets Picture 9

To hide, show the column:

Sometimes with spreadsheets that are too wide you need to hide some unnecessary columns for easy control, you do the following:

  1. Black out the columns to hide, go to Format > Column > Hide
  2. When you need to review the hidden columns, you blacken the two columns adjacent to the hidden area (if hiding columns C, D and E, you must highlight the column BF) -> go to Format > Column > Unhide.

MS Excel - Lesson 4: Working with lines, columns, sheets Picture 10MS Excel - Lesson 4: Working with lines, columns, sheets Picture 10

Adjust the width of the column:

If you want to change the width of the column, you can use the mouse pointer to enter the line separating the two column names and dragging, or you can do the following:

Go to Format > Column > Width . , type width> Ok:

MS Excel - Lesson 4: Working with lines, columns, sheets Picture 11MS Excel - Lesson 4: Working with lines, columns, sheets Picture 11

You can fix the width of the column corresponding to the data in the column by going to Format > Column > AutoFit Selection or double-clicking the divider between the two column names. From Excel 2010 and above, go to Home> Format> AutoFit Column Width tab as shown below:

MS Excel - Lesson 4: Working with lines, columns, sheets Picture 12MS Excel - Lesson 4: Working with lines, columns, sheets Picture 12

3. Working with cells:

To insert a cell:

Place the cursor in the cell to be added, go to Insert > Cells . or right-click the cell to add select Insert

MS Excel - Lesson 4: Working with lines, columns, sheets Picture 13MS Excel - Lesson 4: Working with lines, columns, sheets Picture 13

  1. Shift right cells : inserting cells and pushing data to the right

MS Excel - Lesson 4: Working with lines, columns, sheets Picture 14MS Excel - Lesson 4: Working with lines, columns, sheets Picture 14

  1. Shift cells : Insert cell and data will be pushed down

MS Excel - Lesson 4: Working with lines, columns, sheets Picture 15MS Excel - Lesson 4: Working with lines, columns, sheets Picture 15

To remove cells:

Place the cursor in the cell to be deleted, go to Edit > Delete . or right-click the box to delete Delete .

MS Excel - Lesson 4: Working with lines, columns, sheets Picture 16MS Excel - Lesson 4: Working with lines, columns, sheets Picture 16

  1. Shift cells left : Delete a cell and the data will be left to the left

MS Excel - Lesson 4: Working with lines, columns, sheets Picture 17MS Excel - Lesson 4: Working with lines, columns, sheets Picture 17

  1. Shift cells up : delete cells and drag data from the bottom up

MS Excel - Lesson 4: Working with lines, columns, sheets Picture 18MS Excel - Lesson 4: Working with lines, columns, sheets Picture 18

4. Manipulating Sheet (Worksheet):

If you want to add a new sheet:

  1. The new Worksheet will be added to the left of the current Sheet.
  2. Method 1 : Go to Insert > Worksheet.
  3. Method 2 : Right-click the sheet name, select Insert . > select Worksheet > Ok:

MS Excel - Lesson 4: Working with lines, columns, sheets Picture 19MS Excel - Lesson 4: Working with lines, columns, sheets Picture 19

So what if you want to add a sheet as a copy from another sheet?

In essence, this work is that you create a new sheet whose contents are exactly the same as the existing sheet, manipulating the following:

  1. Right-click on the sheet name you want to copy and choose Move or Copy .

MS Excel - Lesson 4: Working with lines, columns, sheets Picture 20MS Excel - Lesson 4: Working with lines, columns, sheets Picture 20

  1. To book : is the file name containing the original Sheet.
  2. Before sheet : is the new Sheet location in the previous sheet (in this example, either Sheet1 or Sheet2 or Sheet3 or last placed.
  3. Create a copy : Is it possible to create a copy, if you do not select this option, the work you do only has the effect of moving the Sheet.

To move and rename Sheet:

  1. You can follow the above method to move the sheet or simply use the mouse to drag a certain sheet to the required location.
  2. If you want to rename a sheet, double-click the sheet name or right-click the sheet name to change it to Rename.

To delete the sheet:

Note that when you delete a sheet, you cannot redo it, so before deleting the sheet you must be sure.

  1. Method 1: Double-click on the sheet to delete, select Delete.
  2. Method 2 : Select the Sheet to delete, go to Edit > Delete Sheet

So with the content of this article, if you read each item carefully, it is only a matter of practice to completely master the spreadsheet. You can use the previous exercise to do some basic operations with your spreadsheet.

Good luck!

4 ★ | 2 Vote