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 […]
How to Set Column Width and Row Height in Inches Using Page Layout View in Excel 2013
It’s rare that the default column widths and row heights in your Excel spreadsheet will be the right size for all of your data. You may already know how to resize the columns or rows manually, or you may know how to use AutoFit to resize them automatically. But if you have ever tried to […]
How to Change a Tab Name in Excel 2016
Excel worksheets can have a lot of tabs. You may be used to seeing some spreadsheets with a handful of sheets, especially since some Excel versions include 3 sheets by default, but it is common for some users to have dozens of sheets. When you are working with a large, multi-worksheet Excel workbook, properly naming […]