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 […]

How to Rotate Text Vertically in Excel 2010

Text that you enter into a cell in Microsoft Excel is going to go from left to right or right to left based on your keyboard settings. Use these steps to rotate text vertically in Microsoft Excel 2010. Open your spreadsheet in Excel Use your mouse to select the cell(s) to modify. Select Home at […]

How to Open CSV Files with Excel by Default

There a variety of different document types that you may have on your computer, including ones with a .csv file type. These are often files that are best understood in spreadsheet format, but they might not be opening in a spreadsheet application. Use these steps to open .csv files with Microsoft Excel by default. Select […]

How Do You Fill a Cell With Color in Excel?

If you’re wondering how to fill a cell with color in Excel, then it’s probably because you are trying to make your data easier to understand visually. Use these steps to fill a cell with color in Excel. Open your spreadsheet in Excel. Select the cell or cells to color. Click the Home tab at […]

How to Display The Top Row on Every Page in Excel 2010

Repeating the top row on every page when you print in Excel is a great way to make the data easier to read. Use these steps to display the top row on every page in Excel 2010. Select the Page Layout tab. Click the Page Setup button. Choose the Sheet tab. Click inside the Rows […]

How to Make Columns the Same Size in Excel for Office 365

When you create a new spreadsheet in Microsoft Excel, all of the rows and columns will be the same size by default. But as you add data to your spreadsheet and make changes to its layout, it’s likely that you will wind up with columns of different sizes. This can happen because Excel can expand […]