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 … Read more
Microsoft Excel is full of useful tools that can help you get the information that you need from your source data. But if you have heard of or seen a pivot table before, then you might be curious about how to create a pivot table in Microsoft’s spreadsheet application. Learning how to make a pivot … Read more
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 … Read more
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 … Read more
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 … Read more
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 … Read more
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 … Read more
We have previously written about how to add a comment to a cell in Excel 2013, but what if you need to delete a comment after you add it, or there is an existing comment in a spreadsheet that you don’t need anymore? Fortunately you can delete a comment in Excel 2013 in a very … Read more
Information in the header of a spreadsheet can include things like page numbers, you name, or the name of a report. But if that information is no longer correct, then you may need to know how to delete a header in Excel 2013. It is a very common practice to re-use spreadsheets for new purposes. … Read more
Excel has a lot of helpful features for managing data, and many of them can save you a lot of manual work. For example, you can find out how to split full names into two different cells in Excel 2013 if you need separate cells for first and last names. Properly formatted data can make … Read more