how to count the number of characters in a cell in Excel 2013

How to Count Characters in Excel 2013

If you’ve ever tried to count the number of digits or letters in a cell, then you have probably discovered that it’s kind of difficult. When you need to do that multiple times, it can seem like an insurmountable task. Luckily Excel has a formula that you can use to count the number of characters… Continue Reading How to Count Characters in Excel 2013

how to enable macros in excel

How to Enable Macros in Excel for Office 365

Microsoft Excel has a number of features that can really speed up the way you work with your data. One of these features involves something called “macros” that can be a game-changer for a lot of Exccel users. If you are having trouble using some of these macros, however, then our tutorial below will show… Continue Reading How to Enable Macros in Excel for Office 365

how to calculate percentage in excel 2013

How to Use a Percentage Formula in Excel

Microsoft Excel has a lot of different ways that you can compare data. Many of these options exist as formulas, and it’s likely that you have used a formula in the past to add the values in a column or subtract one cell’s data from another. But there are a lot of other useful ways… Continue Reading How to Use a Percentage Formula in Excel

click the autofit column width option

How to AutoFit All Columns in Excel 2013 (An Easy 4 Step Guide)

It’s really easy for your column widths and row heights to be sized incorrectly. You might drag a row or column divider by accident, or you might have a lot more data in a column than it can handle by default. Luckily you can learn how to AutoFit all columns in Excel 2013 and quickly… Continue Reading How to AutoFit All Columns in Excel 2013 (An Easy 4 Step Guide)

press ctrl + the semi colon

How to Add the Current Date to a Cell in Excel 2010

There are a lot of tools in Microsoft Excel that serve very specific purposes. many people won’t use a lot of these, but they can be very helpful for the people that do need them. One such item involves a way to add the current date to a cell, and all it takes is a… Continue Reading How to Add the Current Date to a Cell in Excel 2010

how to create bullet lists in excel 2010

How to Insert Bullet List Items in Excel 2010

While much of the data that you add to a Microsoft Excel spreadsheet might only take up one line, situations might exist where you want to put a list of items in a cell instead. Our tutorial below will show you a way to add bullets inside a cell so that you can create a… Continue Reading How to Insert Bullet List Items in Excel 2010

insert a row in excel 2013

Inserting and Deleting Rows in Excel 2013

When you are adding data to a spreadsheet in Microsoft Excel, it’s pretty common to either add some data that you wind up not needing or to forget about something and need to add it at a later time. Fortunately, there are options in Excel that allow you to insert or delete entire rows from… Continue Reading Inserting and Deleting Rows in Excel 2013

how to stop excel 2010 from changing numbers to dates

Why Does Excel Keep Changing My Numbers to Dates?

Occasionally you might enter data into one of your cells in Excel, only to find that Excel has converted that number to a date. This can be frustrating, and you almost certainly asked “why does Excel keep changing my numbers to dates? Luckily this is something that you can fix by changing the formatting of… Continue Reading Why Does Excel Keep Changing My Numbers to Dates?

click the list option

How to Create a Drop-Down List in Excel 2010

A spreadsheet with a lot of typos can be tough to work with, so reducing those types of errors is important. A dropdown list is an effective way to manage this. Our tutorial below will show you how to add one to your Excel spreadsheet. Creating a drop down list in Excel 2010 is something… Continue Reading How to Create a Drop-Down List in Excel 2010

how to remove all hyperlinks in Excel 2013

How to Break All Links in Excel 2013

Does your spreadsheet have a lot of links in it? This can happen pretty easy if you copy and paste information from other locations, or if your data includes Web pages or file addresses, as Excel likes to turn those into links automatically. Luckily you can break Excel links with an option found on the… Continue Reading How to Break All Links in Excel 2013