The decimal separator is a character that indicates that the numbers to the right of that character are less than one full unit. In some places in the world, this character is a period. However, in other parts of the world, that character is a comma. If you have spent your life using a period […]
Why Is Excel Only Showing Two Decimal Places?
Excel can be used for many purposes, including ones where you need to store numbers to a high degree of specificity. This often involves entering numerical values that contain a high number of decimal places. But you might notice that Excel is rounding these numbers are after only a couple of decimal places, and your […]
How to Enable Macros in Excel 2013
Macros in Microsoft Excel give you a way to automate tasks that could be time-consuming if performed manually. But macros can potentially be dangerous if someone wishes to use them that way, so Excel is very careful with allowing you to use them in your workbooks. Our tutorial below will show you how to add […]
How to Clear Data and Formatting from a Whole Spreadsheet in Excel Online
You have probably run into situations in the past where you needed to delete data from a couple of cells in your Excel spreadsheet. This can be as simple as selecting those cells with your mouse, then pressing the Delete key on your keyboard. But if your spreadsheet is very large and you want to […]
How to Change the Name of a Document in Excel Online
When you create a new spreadsheet in Microsoft Excel Online, the name of the spreadsheet is going to be something generic like “Book1,” If you are only working on a couple of files this may be fine, but it can become an organizational problem in the future when there are a lot of files that […]
How to Apply Currency Formatting in Excel Online
When you type numbers into a cell in Excel Online, that data is going to be formatted as a number by default. This means that there won’t be any decimal places unless you manually add them. This can create a problem when you are working with currency values, however, as the inconsistency with the amount […]
How to Change the Format of a Cell in Excel Online
One of the best parts about using Excel online is how many of the program’s features are available in that version. You can perform most basic Excel actions in the online version, and even many of the more advanced ones. One of the more common things that you might need to do in an Excel […]
How to Print Formulas in Excel Instead of Their Results
When you are working in Excel for school or work, one of the more important things that you can learn is how to use formulas. But, by default, any formula that you use will display the result of that formula, so anyone evaluating your work on the printed page won’t be able to tell if […]
How to Insert a Column in Excel 2013
Sometimes you may determine that the data that you have in your spreadsheet isn’t all of the data that you actually need. You might need to include another piece of information, and it would make more sense for that new data to be added in a column that is between two of your existing columns. […]
How to Change from Lowercase to Uppercase in Excel 2013
The case of the data that you type in Microsoft Excel is something that you probably don’t think about until it becomes a problem. Depending on when this problem is discovered, you may be facing the prospect of having to retype a lot of existing data to make it the correct case. Fortunately there are […]
- 1
- 2
- 3
- …
- 12
- Next Page »