How to Save as a CSV File in Excel 2013

Excel 2013 is compatible with a variety of different file formats, and you can even choose the default format in which Excel 2013 files are saved. The file type can also be selected on a file-by-file basis, which is helpful when you have contacts that require their data in a particular format. One popular format […]

How to Change the First Page Number in Excel 2010

It is helpful to add page numbers to your Excel 2010 worksheet if there are a lot of pages, or if you think it is likely that the pages might become separated. But if your worksheet is part of a larger printed document, then it could be confusing to the reader if the page numbers […]

How to Print Titles in Excel 2013

Printing an Excel spreadsheet can be difficult when the data that you have is not ideally suited for a piece of paper. It can be helpful to copy the top row to every page in Excel 2013 when your document is going to span multiple pages, but the method in that article can be a little […]

How to See Print Layout in Excel 2013

There are a few easy ways to force your Excel 2013 spreadsheet to fit on one page, which can help to solve many of the print problems that you might be having with your worksheets. But many Excel jobs don’t fit into the same set of criteria, or only some of your spreadsheet might be […]

How to Copy a Worksheet in Excel 2013

Last updated: March 26, 2019 I’ve created many Excel workbooks that contain multiple copies of the same worksheet. Whether the workbook is for a weekly or monthly report where each worksheet is a slightly modified version of the same template, or a worksheet from one book might be effectively used in another, it can save […]

How to Shrink Text to Make it Fit in a Cell in Excel 2013

Data that is entered into the cell of an Excel 2013 worksheet can often be larger than the cell itself. You have probably learned how to resize rows and columns to make them larger or smaller, but you may encounter a situation where you are unable to adjust cell sizes. In this case, the best […]

Keyboard Shortcuts to AutoFit Columns and Rows in Excel 2013

Excel can be a lot easier to use once you get comfortable using keyboard shortcuts to perform common actions. Copying and pasting, for example, is one action that can be made much quicker by using a keyboard instead of a mouse. But there are keyboard shortcuts for many more Excel functions, including the AutoFit Column […]

Three Ways to Fit to One Page in Excel 2013

Excel spreadsheets typically don’t print the way that you want them to. Occasionally you will get lucky and the number of rows or columns in your spreadsheet will match up perfectly with the dimensions of your printed page, but more often than not, you will have one column or one row that adds another page, […]

How to Count the Number of Blank Cells in a Range in Excel 2013

When entering data into a spreadsheet in Microsoft Excel 2013, it is not uncommon to have blank spaces that are missing data. On small spreadsheets, or in small ranges of cells, it can be easy to manually count the missing spaces. Unfortunately it is much more difficult as the spreadsheet gets larger, and it can […]

How to Determine the Day of the Week from a Numerical Date in Excel 2013

Excel 2013 has a lot of helpful tools and tricks that you can use to find information about data contained in a worksheet. One of these tricks involves the use of a formula to help you determine the day of the week for a numerical date in one of your cells. Our tutorial below will […]