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 […]
How to Change Page Order in Excel 2013
When you print a large spreadsheet in Microsoft Excel 2013, the default behavior is for the data to print down, then over. This means that the columns that are further to the right will print after the bottom row of the leftmost column. Unfortunately your spreadsheet may have been designed in such a way that […]
How to Print the Top Row on Every Page in Excel 2016
This guide is going to show you how to set row 1 to print on every page. We list the steps at the beginning of the article, but you can continue reading after to see the steps with pictures. Open the spreadsheet in Excel. Select the Page Layout tab at the top of the window. […]