delete the password, then click the ok button

How to Remove a Password in Excel 2013

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

Click Insert, then PivotTable

How to Create a Pivot Table in Excel 2013

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

click the autofit column width option

How to AutoFit All Columns in Excel 2013

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

formula bar showing average

How to Find an Average in Excel 2013

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

how to expand all rows in excel 2013

How to Expand All Rows in Excel 2013

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

how to delete a comment in excel 2013

How to Delete a Comment in Excel 2013

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

click the header and footer button

How to Delete a Header in Excel 2013

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