You don’t even need to remember them specially. There’re some formulas can help you processing data quickly and also easy to use.
To deal with a huge amount of data in Excel worksheets, you don’t need to do all the calculations by yourself or with a calculator. Let Excel Do the Repeated Calculations for You
On the contrary, if you want to apply an action to multiple discontinuous cells or even cells in different spreadsheets, you can make use of to redo your last action.
In fact, you can simply undo your last action or multiple actions before by pressing. If you don’t know exactly what the spreadsheet looks like a second before, how can you recover it to the correct version? There are always some faulty operations when dealing with complicated tables and sophisticated data in Excel. Thus the change will be applied to all the sheets in the workbook. Then click the small down-arrow beside Within Sheet and choose Workbook instead. Input the text you want to find and the text you want to replace with. Press in any of the sheets to open Find and Replace window. Instead of adjust each sheet separately, you can use a You must often create multiple sheets in an Excel file to process different but related data, and sometimes you may need to replace a specific word or value in all the sheets to ensure their correctness and consistency. Replace Specific Content in All the Worksheets You can try another quick way to split data using Flash Fill. Then specify the Destination to output the data. To split the content from one cell to multiple cells, or from one column to multiple columns, you can select the cells you want to split, and try using Text to Columns in Data tab.Īnd if there are no symbols like commas or tabs separating each field, choose Fixed width to continue and create break lines by yourself. Or, you can also use this formula: =CONCATENATE(A2,B2). If you want to add a space between the contents of A2 and B2, just enter: =A2&“ ”&B2. To merge multiple cells and keep all the contents of them, there are 2 functions you can try:Ĭreate a new column and Enter the formula: =A2&B2 to merge the contents in A2 and B2. But if you use it to merge 2 cells with different texts, the merged cell will only keep the upper-left value and discards other values. You may already know there’s a merge button in the Home tab of Excel. It’s also common to merge multiple cells or split the content in one cell. Merge and Split Cells in ExcelĪ spreadsheet can’t be done without any adjustments and modifications. The number of rows inserted will be equal to the number of rows you selected. You can drag the mouse to select multiple rows (or columns) at first, then right-click the selected area and click Insert in the menu.
HOW TO USE MICROSOFT EXCEL FOR BEGINNERS HOW TO
You probably know how to add a new row or new column in Excel spreadsheet, but if you need to insert multiple rows or columns, repeating this operation can’t be the best idea. YouĬan see the basic elements of its user interface below. This tutorial is based on Microsoft Excel 2019. I’m sure you can benefit from these tips. If you are one of those office workers who want to do better in processing data, and using less time. In this post I collected some useful tips about Excel features and functions as a reference. So, how to use Microsoft Excel smartly to boost the working efficiency? Only in this way they can save the time to do more constructive work and improve themselves. For an office worker, it’s very important to grasp some commonly used Excel skills to process the data in a spreadsheet.