Posted On 30 Nov 2021
1. Create many rows or columns
As you work with your data, you may need to add extra rows and columns. It can be quite laborious to do this one by one. Fortunately, there is always a simpler option.
In a spreadsheet, highlight the same number of extant rows or columns that you wish to add. Then pick “Insert” from the right-click menu.
If you want to add three more rows; for example, highlight three rows and then click insert.
2. Remove any data points or sets that are duplicates
Duplicate information is more common in larger data sets. Getting rid of duplicates comes in helpful in circumstances like these.
To get rid of duplicates, choose the row or column you wish to get clean up. Then pick “Remove Duplicates” from the Data tab (which is under the Tools subheader in the older version of Excel). A pop-up will appear requesting you to confirm which data you wish to use. Simply choose “Remove Duplicates,” and you’re done.
3. Change the order of the rows and columns
You may elect to turn rows into columns (or vice versa). Copying and pasting each individual header would take a long time, but the transpose tool allows you to effortlessly transfer your row data into columns or the other way around.
To begin, choose the column you wish to transpose into rows and highlight it. Select “Copy” from the context menu when you right-click it. Then, in your spreadsheet, choose the cells where you want your first row or column to start. Select “Paste Special” from the context menu after right-clicking on the cell. You’ll notice a module emerge, with a transpose option at the bottom. Select OK after checking that item. Your column has been converted to a row or vice versa.
4. Use the & symbol to join cells together
Data is subdivided in database table to make it as precise as feasible. Instead of a column containing a person’s entire name, a database can have the data separated into two columns: a first name and a last name. It might also divide a person’s location by city, state, and zip code. Using the “&” character in your function in Excel, you may merge cells with diverse data into one cell.
5. Include checkboxes in your design
You might use checkboxes in a column if you’re using an Excel sheet to manage client data and want to supervise something that isn’t measurable.
If you’re using an Excel sheet to handle your sales prospects and want to keep track of whether you phoned them in the previous quarter, you could create a “Called this quarter?” column and check off the columns in it once you’ve called each customer.
In your spreadsheet, choose a cell to which checkboxes should be added. Then select DEVELOPER from the drop-down menu. Then click the checkbox or selection circle marked in the figure below under FORM CONTROLS.
