Categories: Excel Tips
-
2 Methods to Close All the Active Excel Workbooks at Once
There are many ways to close an Excel window after finishing editing. But if you opened too many workbooks out of work needs, saving and closing them one by one becomes an annoying task, especially when you finish a whole-day-long work and just want to go home as soon as possible. In this case, it’ll […]
-
How to Insert Curly Braces in Microsoft Word and Excel
To satisfy certain requirements, you may need to insert some curly braces into Word document or Excel spreadsheet. But in addition to regular curly braces, sometimes the curly braces with customized size that can contain several lines of text are also needed. In this post, I’ll introduce 4 commonly used methods to insert both regular […]
-
How to Split Text from One Cell into Multiple Cells in Excel
Sometimes you copy some texts to Excel with the intention of splitting them into multiple columns, but it turns out that all the texts were put into the same column. To rearrange them manually is a heavy work. So how could you split the content into two or more cells in Excel without cutting and […]
-
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 […]
