When working in Excel, you need to master the manipulation of data tables and this article will tell you 4 operations to edit Excel spreadsheets.
In Excel, there are many great features that not everyone knows about. The manipulation of editing spreadsheets seems to be very simple but extremely important for those who often work on Excel. This article will guide you through 4 operations to edit spreadsheets in Excel. We invite you to follow us.
1. Insert rows and columns in Excel table
At the first Excel interface, you need to select the column you want to insert. For example, the column you want to insert is in front of the selected column, right-click and select Insert. Next, click on the item Entire column to proceed with the column insertion.
After pressing Ok you get new column on the left side next to the selected column.
To insert 1 row after 1 selected row the user clicks on the row and also selects Insert. Then you press to select the item Entire row to insert an extra line in front of the selected line.
Press Ok to complete. And the user gets 1 new line above the previously selected line as shown below:
2. Delete rows and columns in Excel table
Deleting columns and rows in an Excel table is as easy as adding columns and rows. You just need to select a value cell in the row or column you want to delete, then right-click and select Delete. Depends on the purpose you choose Entire column to delete the column or Entire row to delete rows.
After pressing Ok then the column or row you want to delete will disappear.
The merging of cells is very simple because there is already a separate entry in the Excel table Merge & Center. You need to highlight the cells you want to merge and then click on the Merge & Center item. Then on the screen there will be a number of options for you to proceed to merge cells. In this example we click on Merge & Center at the top. This section will help you align the text to the center after merging.3. Merge cells in Excel table
Then 2 cells in the table have been merged into 1 cell as shown below.
4. Center text alignment in Excel cells
Text alignment is used a lot and is necessary in Excel. Because while entering data, the text may shift to the left or right. To fix this, you can use 1 of 2 ways that we introduce below.
Method 1: Use Alignment in the toolbar
To do this, highlight the data you want to edit, then look at the item Alignment on the toolbar. Then click on the icon Middle Align as shown below. This helps you center the text in the data cell.
As a result, the text is aligned in the center as shown below.
Method 2: Use Format Cells
When using this method, you need to highlight the text position adjustment area and then right-click and select Format Cells.
Immediately will display the Format Cells dialog box and you select the Alignment tab. At 2 Horizontal item and Vertical users find and select Center. Then press OK and the result is the text in the middle of the data cell.
Above are 4 basic operations to edit Excel spreadsheets that you should know. Hopefully this article will bring useful information to readers when working with Excel spreadsheets. Wishing you success!
According to Accounting