A default spreadsheet in Microsoft Excel 2013 is going to display rows and columns of cells that are separated via a sequence of lines. These are called gridlines, and are useful for making data easier to read. But these gridlines aren’t going to print if you don’t change the default settings, which can leave you […]

Sometimes when you are editing an Excel file you are working with sensitive information. Since anyone with access to your computer or the Excel spreadsheet would be able to view that information, it can be helpful to apply an Excel password to the file. But it may be necessary to later learn how to remove […]

Converting units of measurement is a necessary evil for a lot of people in a wide variety of fields. Fortunately if you want to convert millimeters to inches in Excel 2013 then you have a way to do so in the application with the use of a formula that we will discuss below. Learning how […]

While Microsoft Excel will usually adjust your column width and row height based on the widest cell contained within that column, you may still need to adjust your rows and columns to more appropriate sizes. Fortunately you can use autofit in Excel if you want to quickly change your column width or row height to […]

Microsoft Excel includes a number of different ways that you can calculate totals or values based on your cell data. But if you need to know how to find an average in Excel 2013 then you may be struggling to locate the average function in Excel 2013. You may know how to calculate an average […]

Many of the formatting changes that you can use in Excel are visible on one of the tabs in the navigational ribbon. Occasionally there tools with have options that specifically apply to an entire worksheet, but many only apply to the current selection. So if you need to know how to expand all of oyur […]

Formatting data properly in Excel can solve a lot of problems that you might have with your formulas, or with readers understanding your data. But you may be wondering how to remove a dollar sign in Excel if you don’t want it included next to your data. Properly applied cell formatting in Microsoft Excel can […]