How to Add Row Numbering in Excel 2013

Numbering your rows in Excel is helpful when you need to reference a particular cell either to another person, or as part of a formula. So when the labels that typically identify your rows aren’t present, it can make your work a little more difficult. Or perhaps you need to include an additional column in […]

How to Change the Page Order in Excel 2013

It’s very common for an Excel spreadsheet to be too large to fit on one page. Additional cells are then pushed to another page and, depending upon how your data is organized, you might need to manually shuffle the printed sheets so that they are in the order which is most helpful to the reader. […]

How to Hide Multiple Worksheets in Excel 2013

The ability to hide worksheets in an Excel workbook can be very helpful when you need to share a spreadsheet with someone else, but there is data on that sheet that shouldn’t be edited. Simply place that data on a separate worksheet tab, reference it with a formula, then hide the tab to make it […]

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

Microsoft Excel 2013 has a number of tools and features that can help you to increase your productivity, or minimize the amount of time that you need to spend doing data entry. One way in particular that you can take advantage of Excel’s formulas is with the CONCATENATE function. This allows you to combine data […]

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

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 the formatting options that I see very little of is underlining other than the standard single-underlining […]

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

When you refer to a cell in Microsoft Excel spreadsheets, 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 labeled with numbers instead of letters. […]

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