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

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

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

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

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

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

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

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

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

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