Categories：Excel Tips
-
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 […]
-
How to Lock Inserted Pictures to Excel Cells
When you use Excel to make a products list or personnel information table, inserting pictures can make it more informative. But if the inserted pictures can’t be locked to the cells, they’ll stay the same even when you make changes to the cells, which is quite frustrating. So, can we just lock the images to […]
-
How to Merge Multiple Tables from Different Excel Sheets
Sometimes you may have the need to create a comprehensive Excel document whose data comes from different files or even files edited by different people. It’s feasible to copy & paste the data manually if it isn’t too much. Otherwise you can try the Consolidate feature to let Excel do most of the work and […]
-
How to Reduce the File Size of Images in Microsoft Excel
A worksheet will become slow and heavy if there are too many images in the Excel file. We usually collaborate by sending files via email and a large one that weighs 50 MB can be hard to share with your colleagues. There are a few methods to reduce the file size of a worksheet, here […]
