标签:Excel
-
How to Calculate the Absolute Value with ABS Function in Excel
Calculating the absolute value is very common in Excel data processing. To fulfil the task quickly and accurately, you don’t need to do the operations by your own. Just make use of ABS function, you can get the absolute values of a batch of data in seconds. 1. Create a new column to output the […]
-
How to Batch Delete Blank Cells in Excel
What would you do if you find some unwanted blanks in Excel sheet? Deleting them one by one is obviously a waste of time. Is there any quick way to remove all the blank cells at once? Well, the Go To feature of Excel may help you. 1. First of all, select the whole sheet. […]
-
How to Customize the Page Margins in Microsoft Excel
Page margins decide the location and size of the Excel sheet in a printed paper. Just like in MS word, you can also customize the page margins in Excel to make it meet your needs, and thereby print a better document. 1. First, click File in the upper left corner. 2. Next, click Print in […]
-
How to Calculate the Data in the Same Cell with Excel Formula
Normally we use Excel formulas to calculate the data from different cells, but in some cases we may enter mulitple numbers with operational symbols in the same cell and want to calculate the result, can we still use formula to work it out? Look at this table, There are multiple numbers and operation symbols in […]
-
How to Calculate Running Total with Functions in Microsoft Excel
When processing data in Excel, there’s a chance that you need to do a running total for a series of numbers. If the data base is huge, it may not be the best idea to do the operation line after line, you can actually calculate the cumulative total with SUM function quickly. For Vertical Spreadsheet […]
-
How to Change the Type of an Existing Excel Chart
Excel is extremely powerful in processing data, and also enable you to simply convert a spreadsheet of plain text into a more visual chart. And if you’re not satisfied with the representation of an existing chart, you can modify it or even change the chart type any time you want. 1. There’re 2 approaches to […]
-
How to Quickly Divide Numbers in Excel Cells Using Formula
Division, like multiplication, is a common operation in mathematics. And in practical work, you also need to do division sometimes when processing data in Excel. To divide numbers quickly and correctly, the quickest way is undoubtedly using Excel formula. Here’s a simple guide. 1. Create a new column to output the calculation result. 2. Enter […]
-
How to AutoFill the Arithmetic Sequence in Microsoft Excel
Using AutoFill in Excel, you can quickly fill the same sequence or the sequence with a tolerance of 1 directly. But what if the tolerance of arithmetic sequence you need to fill is not 1? In fact, Excel enables you to customize the tolerance and fill the arithmetic sequence automatically. Let’s see how to do […]
-
How to Autofit the Column Width with the Content in Excel
Everyone who often use Excel should have encountered a situation that the entered text is so long that exceed the cell’s border. So how to autofit the column width to make it correspond with the length of characters? Here are 2 commonly used methods. Method 1: Wrap Text 1. Select the cells you want to […]
-
How to Copy and Paste Excel Table as a Picture
Sometimes you need to cite some data in an Excel spreadsheet, or display it to someone else, but don’t want the format to be messed up or the content to be tampered. In this case, you can try to copy or paste the table as a picture. It works a bit like screenshot, except that […]