Why Can’t I Double Click a Cell to Edit It in Excel 2013?

You can edit cells in Excel 2013 by selecting a cell and clicking inside the formula bar at the top of the window, or you can double-click a cell and edit the data directly in the cell. But you might find that double-clicking a cell to edit the data is no longer working, and that […]

How to Wrap Text for Every Cell in a Spreadsheet in Excel 2013

You may have already found the option to wrap text in Excel 2013, but you might have noticed that it will only apply to the cell that is currently selected. This is not something that can only be done to one cell at a time, however. You can wrap text for multiple cells at once […]

How to Turn Off Screen Tips in Excel 2013

Excel 2013 can provide you with additional information about some of the buttons and features in the program when you hover over them. These pop-up descriptions are called ScreenTips, and they can either be simple, where they only display the name of the object, or they can be enhanced, where they display a description as […]

How to Add Leading Zeroes to Numbers in Excel 2013

Excel has a habit of removing zeroes if they are the first digits in numbers. In some cases that isn’t an issue, but in the case of certain types of data, like zip codes, you might need to find a way to add leading zeroes in Excel so that the numbers are correct. Fortunately you […]

How to Return All Worksheets in an Excel Workbook Back to Normal View

Excel 2013 has a few different view options that you can select from to help you format your spreadsheet properly. The view setting is an independent trait of each worksheet in a workbook, so it is entirely possible for you to have a single Excel workbook that contains multiple different view settings. Fortunately there is […]

How to Calculate the Number of Workdays Between Two Dates in Excel 2013

One way that you can use Excel 2013 is to keep track of ongoing projects, or important dates that occur either in your personal life or at work. If you need to know how many days fall between two dates, such as the beginning and end of a project, then you might be having difficulty […]

How to Change or Edit an Existing Header in Excel 2013

The header section of an Excel spreadsheet is a great place to add a page number, or include important information that can help to identify the printed sheet. But if you have a worksheet that you update periodically, you might find that the information currently contained within the header is no longer accurate, and that […]

How to Combine Three Columns Into One in Excel 2013

Excel 2013 makes it possible for you to automatically generate and combine data that you have already entered into your spreadsheet. One way that you can do this is the CONCATENATE formula, which allows you to combine three columns into one in Excel. This is a powerful Excel tool to know, as it can help […]

How to Count the Number of Characters in a Cell in Excel 2013

Excel 2013 has a lot of formulas that can help you to analyze your data. Often these formulas allow you to perform mathematical operations on your cells, and formulas make it easy to update those operations if you happen to change the data in one of those cells. Occasionally, however, you might need to use […]

How to Change Tracking Numbers from Scientific Notation in Excel 2013

Many large businesses will ship dozens, if not hundreds or thousands of packages in a day. Almost all of the customers receiving those packages will want a way to track their shipments, so you may find yourself in possession of an Excel file with a lot of tracking numbers. But Excel has an annoying habit […]