How to Remove a Password from an Excel 2010 Spreadsheet

Locking a worksheet in Excel can be a useful tool depending on how that worksheet is being shared. But someone viewing a locked spreadsheet might need to edit it, so it’s helpful to know how to remove a password in Excel 2010. Microsoft Excel files are often shared between students and colleagues who are attempting […]

How to Center Worksheet Horizontally and Vertically in Excel 2010

Printing in Microsoft Excel can be a frustrating endeavor. The default settings are often not ideal, which can leave you wondering how to do things like how to center a worksheet horizontally or vertically on the page in Excel 2010. By default, Microsoft Excel 2010 will print your spreadsheet based upon how you have configured […]

How to Subtract in Excel 2013 with a Formula

Microsoft Excel can do more than just store and sort data. You can also compare data and use mathematical functions. This means it’s possible to learn how to subtract in Excel 2013. Learning how to subtract in Excel 2013 with a formula will provide you with the gateway into the world of Excel formulas. There […]

How to Print Each Worksheet of an Excel 2013 Workbook on One Page

When you have an Excel workbook with a lot of individual worksheets, you might need to print all of those sheets at once, and you may want them each to fit on one page. Microsoft Excel is a great program for managing your data, but it can be a frustrating application when you need to […]

How to Create a Drop-Down List in Excel 2010

Creating a drop down list in Excel 2010 is something that seems like it should be fairly simple, as its a helpful item to have, and there are a lot of uses for it. But if you’ve ever tried to make a dropdown in Excel, then you may have found that it’s a little more […]

How to Lock a Cell in Excel 2010

Sometimes the data that you type into a spreadsheet is something important that shouldn’t be changed by anyone. Use these steps to lock a cell in Excel 2010. Open your spreadsheet in Excel. Select the cells that you DON’T want to lock. Right-click on a selected cell and choose the Format Cells option. Choose the […]

How to Convert MM to Inches in Excel 2013

Converting units of measurement is a necessary evil for a lot of people in a wide variety of fields. Use these steps to convert millimeters to inches in Excel 2013. Open your spreadsheet. Click inside the cell where you want to display inches. Type the formula =CONVERT(XX, “mm”, “in”) but replace “XX” with the cell […]

How to Hide Sheet Tabs in Excel 2010

Microsoft Excel separates its worksheets via a tab system that you can find at the bottom of the window. Use these steps to hide sheet tabs in Excel 2010. Open your Excel file. Click File at the top-left. Select Options at the bottom-left. Choose the Advanced tab. Click the box to the left of Show […]

How to Clear the Print Area in Excel 2010

Print areas in Microsoft Excel are a good solution when you need to print some of the data in a file, but not all of it. But occasionally a print area has been set and is no longer correct. Use these steps to clear a print area in Excel 2010. Open your Excel file. Select […]

How to Hide Columns in Excel 2010

Sometimes you will have data in a spreadsheet that you don’t need to display, but you don’t want to delete. Use these steps to hide columns in Excel 2010. Open the spreadsheet with the columns to hide. Select the column heading of the column to hide. Right-click the selected column and choose Hide. Our article […]