Occasionally when you are entering data into a spreadsheet in Microsoft Excel, you may notice that a word is pre-filling the cell. If you are expecting this and want to incorporate it into the way you edit spreadsheets, then it can be a helpful tool. But if you find that is causing problems, then our … Read more
A printed Excel spreadsheet with more than one page can be difficult to read. Important information that identifies cell contents and gives context for values might not be on every page, so the reader might be going back and forth between pages, which can waste time and lead to mistakes. Our tutorial below will show … Read more
When you are applying formatting to some of the data in a spreadsheet, you might only stick to the more common options like bold, italic, and underline. But Microsoft Excel has a much larger selection of formatting choices that you can use to get the right point across. Our tutorial below will show you how … Read more
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 … Read more
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 … Read more
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 … Read more
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 … Read more
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 … Read more
Microsoft Excel includes a lot of tools that can help you quickly manage your data. Some of these are things that you might be using already, while others either require the use of formulas or lesser-known tools that are a little tougher to find. Our tutorial below for removing the beginning characters in an Excel … Read more
There is a pretty steep learning curve when you start to see all of the different things that you can do in Microsoft Excel. It’s an incredibly powerful application with a nearly infinite number of potential uses. But one of the more useful things that you can do is learn how to subtract in Excel. … Read more