How to Enlarge a Cell Horizontally in Excel 2013

You will eventually need to know how to enlarge a cell horizontally in Excel when you enter data into a cell and find that all of the data is not visible. Excel 2013 has a default cell width, and it is possible to enter enough data into that cell so that it can’t all be […]

How to Save a Spreadsheet as a One Page PDF in Excel 2013

Saving an Excel spreadsheet as a PDF is a solution that I often use when I have data that I want to share with other people, but I want to avoid giving them the option to easily edit that data. Unfortunately the PDF version of an Excel worksheet suffers from the same issues that a […]

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