How to Display Numbers Without a Comma in Excel 2013

Are some of the numbers in your spreadsheet currently formatted to display commas as a 1000 separator? This is an option in Excel, and it is one that you don’t need to use if you don’t want it. Our tutorial below will show you how to change the formatting option for cells that are formatted […]

Can I Name a Worksheet Something Other Than Sheet1, Sheet2, etc in Excel 2013

Excel files are often referred to a spreadsheets, but they are actually files called workbooks, and they can contain multiple spreadsheets within them. These spreadsheets are called “worksheets” and can be navigated by clicking a tab at the bottom of the spreadsheet. You might already be familiar with worksheets, and have maybe even figured out […]

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