How to Change the Order of Items in the Excel 2013 Quick Access Toolbar

The Quick Access Toolbar in Excel 2013 gives you the ability to quickly perform some common commands that would otherwise require you to navigate through the File menu. These can include a number of different options, such as saving your file, printing, spell checking, or more. But if you find that location of some of […]

How to Delete All Comments from a Worksheet in Excel 2013

We have previously written about how to delete a comment in Excel 2013 when you have a specific comment in a spreadsheet that you no longer need. But what if your entire spreadsheet is full of comments that you don/t need? Deleting them individually can be time-consuming if there are a lot of comments, so […]

How to Concatenate Text in Excel 2013

This guide is going to show you how to use the concatenate Excel formula to combine data from cells in your spreadsheet. The steps for the formula are addressed briefly at the start of this article, then we go into more depth with pictures below. Click inside the cell where you wish to display the […]

How to Refresh Pivot Table Data in Excel 2013

Pivot tables in Excel 2013 are very helpful tools that let you quickly view the data from your spreadsheets in whatever way you need. Pivot tables can be easily manipulated and sorted without requiring you to edit or delete any of the important original data that is in your spreadsheet. But you might discover that […]

How to Double Underline in Excel 2013

Working with data is often more than simply using the right formula to perform your calculations. There are many different types of formatting that you can apply to the numbers or words in your Excel spreadsheet, and even very experienced Excel users are unlikely to encounter, much less use, all of these options. One of […]

Why Are My Column Labels Numbers Instead of Letters in Excel 2013?

When you refer to a cell in Microsoft Excel spreadsheets, such as with a subtraction formula, you are likely accustomed to doing so by indicating the column, then the row number. For example, the top-left cell in your spreadsheet would be cell A1. However, you might be using Excel and find that the columns are […]

How to Delete a Text Box in Excel 2013

If you have a text box in an Excel spreadsheet that you need to delete, then you might be wondering how that is possible. There is a Drawing Tools tab that appears at the top of the window when you are editing your text box, but there isn’t an option on that menu that lets […]

How to Remove a Vertical Page Break in Excel 2013

Manual page breaks in Excel 2013 provide you with the opportunity to let Excel know where it should start a new page when you print. Unfortunately those manual page breaks can become a problem if you are deleting or adding rows and columns to your spreadsheet. If you find that a vertical page break is […]

How to Select the Entire Spreadsheet in Excel 2013

Cell selection in Microsoft Excel can take a variety of forms, and you may already be familiar with selecting a single cell, or a row, column, or even a range of cells. But selecting and modifying small sections of your spreadsheet can be tedious when you have to make large changes, so you might be […]

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