Have you created a spreadsheet that contains formulas? And was everything looking how you would expect, with your formula results in their cells, but now you are seeing the formulas instead? This happens because of a setting that may have been changed inadvertently which causes Excel to display the formulas themselves, rather than their results. […]
How to Set the Height or Width of a Picture in Inches in Excel 2013
Adding pictures to a spreadsheet can be important if you are sending a list of products to a potential customer and want them to see those products, or if you are creating a personal inventory and want a record of what the items in those inventory look like. Excel makes it easy for you to […]
What Does Transpose Do in Excel?
There are a number of different ways that you can paste information that you have copied in Excel. You can paste data without any formatting, you can paste without borders, and you can even paste formulas that will update based on the cell you paste them into. But one of the other options you may […]
How to Center a Worksheet Horizontally and Vertically in Excel 2010
Have you ever printed a spreadsheet in Excel and it was aligned at the left side of the sheet? In some cases this is perfectly fine, but in other situations this could look bad or unprofessional. Fortunately Excel 2010 has a number of different ways that you can customize the appearance of your printed spreadsheets, […]
How to Wrap Text in Excel 2013
Often when you type a lot of text into a cell in Microsoft Excel 2013, all of that text isn’t going to fit into the cell. Excel will typically opt to keep the cell the same size, meaning that some of that text isn’t going to be visible. But if you need others reading the […]
How to Add a Signature Line in Excel 2013
Adding a line for signatures to a Microsoft Excel document can be accomplished a couple of different ways. The first option that many will use is to simply add a bunch of underscores to a cell, but this can have some unexpected results, as the underscores will move if someone types on them. Another option […]
How to Change Excel’s Decimal Separators to Commas
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 […]