标签：Excel
-
How to Use SUM Function in Excel
Comparing to input a huge amount of data into a table and try hard to calculate the total amount by yourself or with a calculator, Excel itself can do a better and quicker job to calculate the summation automatically. It’s called SUM function. 1. To make use of it, select the cell you want to […]
-
How to Hide and Protect the Formulas You Used in Excel
As the work requires, you may send your Excel spreadsheet to other people at times. It means they can not only view the data, but also click any cell to check the formula it contains, or even modify it without your permission. To keep that from happening, you can try these steps to hide and […]
-
How to Calculate Summation in Same or Separate Sequence in Excel
If you need to calculate summation of numbers, let Excel do it for you. It might be easy when it’s in same sequence but a little bit difficult in separate sequence. So let’s take a look at the tip you can complete it in a simple way. In Same Sequence 1. Drag to select numbers […]
-
How to Convert Case Quickly in Excel
If you work with a lot of text-based data in the spreadsheets, it might be annoying because Excel does not include a convert case tool for editing text with small letters or capital letters. So, what’s the solution to a problem like this?Here we might help you out with this tutorial though. 1. Enter all […]
-
How to Set the Default Font and Size in Excel
You may want to set the default font and size once for all, because it can help to make your workbooks more readable when they are printed. If you are one of those users, who desire to change the default font and size, and select one that better suits your needs, then this post will […]
-
How to Insert a Checkbox in Microsoft Excel
When making a form in Excel, a box with tick, which is also known as checkbox or tickbox, can be very practical. Let’s see how to insert it in a spreadsheet. 1. Click the cell you want to insert a checkbox, then switch to Insert tab and click Symbol in Symbols section. 2. In Symbols […]
-
How to Create a Horizontal Bullet List in Excel
Excel comes with a variety of formatting and layout tools to enable you to get work file looking their best and to put across ideas effectively. In the case of bulleted lists, the icon in the SmartArt section lets you define the bullet style and created nested lists. Here I’d like to give a simple […]
-
How to Insert Multiple Rows or Columns in Excel Spreadsheet
If you want to insert more than one row or column at a time in Excel, the method is much like the way you add single row or column to your sheet. 1. To insert more than one rows, you can select multiple rows of cells below the place where you want to insert rows. […]
-
How to Insert Comments to Specific Cells in Microsoft Excel
The way to insert comments to Excel cells is not much different from adding comments to Word document. You can also inform others your thoughts about specific cells in this way. Let’s see the detailed steps. 1. Click the cell you want to add a comment. Then switch to Review tab and click New Comment. […]
-
How to Set Decimal Places in Microsoft Excel
Numbers are displayed with no decimals by default in Excel, but some data need to be set decimal places as the work requirements. So how can we achieve it? The method is simple to follow: 1. Select the data which you want to set decimal places. 2. Go to Home tab, find Number group and […]
