Microsoft Excel is an often-used office tool in our work and life. With excel, we can collect, organize, store, and deal with our data and information efficiently. Apart from some of the basic functions in excel, there are several reasons to use Excel as it offers many other useful functions or operations that need you to pay attention to. Here are some tips to use Microsoft Excel for you.
How to Merge Cells in Excel
There are many methods that you can use to merge cells in Excel. Firstly, people often use the Home & Center in the home tab. When we use this method, what we should take into consideration is that this method does help merge cells, but it can not merge the text in these cells together. It only preserves the text from the leftmost cell, not from other cells.
The other method you can also take advantage of is here – you can use the CONCATENATE formula. For instance, if you want to combine the two cells in A1 and B1, you can enter the corresponding formula in cell C1: = CONCATENATE(A1, B1). The merit of this method is that you won’t lose the text in all of the cells.
How to Lock Cells in Excel
When we don’t want our data in excel to be edited or changed, there are two ways that we can make the most of. One is to lock the corresponding cells in Excel directly; while the other method is to use the tool Excel to PDF to convert Excel files to PDF files because PDF files can’t be edited and changed.
On the one hand, you can lock all cells in Excel by clicking “Protect Spreadsheet” to check it because all cells are locked by default. The operation is very easy. On the other hand, if you want to lock some specific cells, the corresponding operations are as follows. Unlock all cells firstly. Then, lock the cells that you want to lock, and click “Protect the sheet” finally. Only in this way can the operation will be valid.
How to Unhide Tabs in Excel
Sometimes, we need to unhide the tabs in excel to improve our work efficiency. The easiest way is to right-click any tab and click the option “unhide” directly.
Moreover, if you find all data in the whole column is missed, the whole column is likely hidden manually because users can hide one specific column by dragging the sheet line. So, just drag the lines if you want to unhide tabs in Excel.
How to Highlight Duplicates in Excel
Highlighting some duplicates in excel is of great importance when we make a presentation or improve our work efficiency. The steps to highlight duplicates in excel are as follows.
Select the duplicates to the range that you want to highlight firstly. Then you can click the conditional formatting on the home tab. The next step is to click Highlight Cells Rules and Duplicate Values then. Finally, just choose the setting style based on your requirements.
Ways to Create a Drop Down List in Excel
Sometimes, we need to make a drop-down list in excel to improve our work efficiency. One of its easiest methods is as follows. First, select one specific cell or a range of cells in which you want to add the drop-down list. Then, go to the tab interface and choose Data, Validation, and Settings one by one. The next step is to input the information or data according to your own needs.
As we can see from what I have mentioned above, Microsoft Excel has so many functions that make our work and life more convenient and efficient. If we have some excel files in the PDF format, we can also convert PDF to Excel to edit and add excel files. Whether you used Microsoft or not, you will find Microsoft Excel is an extremely helpful tool to master. In conclusion, it’s hoped that these tips can help you all.