How to Disable AutoComplete for Cell Values in Excel 2013
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 …
Microsoft Excel 2013
How-to guides and tutorials about topics related to the Microsoft Excel 2013 application and ways that you can edit spreadsheets.
How to Print the First Column on Every Page in Excel 2013
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 …
How to Double Underline in Excel 2013
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, …
How to Use the Character Count Excel 2013 Tool
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. …
How to Calculate Percentage 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 …
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 …
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 …
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 …
How to Remove First Character in Excel 2013 Cell
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 …
How to Subtract in Excel 2013 with a Formula (An Easy 4 Step Guide)
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 …
How to Change Font Color in Excel 2013
The focus of a spreadsheet is often on the data in your cells as you are editing it. But once you have all of the …
How to Combine Three Columns Into One in Excel
It’s often a good idea to separate as much information as possible in Microsoft Excel. Depending on what you are going to be using that …
How to Freeze Multiple Rows in Excel 2013
The option to freeze rows in Microsoft Excel is one that you might not use for a while but can be very helpful once you …
How to Rename a Worksheet Tab in Excel 2013
Do you find that you need to click on a couple of different worksheet tabs before you find the right one? This is a pretty …
How to Wrap Text for Every Cell in a Spreadsheet in Excel 2013
Occasionally some of the text in some of your Microsoft Excel cells won’t be visible. This happens when there are more characters in the cell …
How to Switch a Row to a Column in Excel 2013
While you might have a good idea of the layout of the data that you are adding to a spreadsheet, changes in the scope of …
How to Change Cell Font in Excel 2013
Is the font that is currently applied to some of the cells in your spreadsheet difficult to read? Or maybe it just doesn’t look good …
How Do I Make My Font Smaller or Larger by Default in Microsoft Excel?
Is the font in your spreadsheets difficult ot read because it’s so small? Or are you having trouble seeing all of your data because the …
Why Isn’t Excel 2013 Showing the Files That I Want to Open?
Are you trying to open a file that you know is compatible with Excel, but it’s not showing in File Explorer? When you click Open …
How to Insert a Page Break in Excel 2013
Have you been trying to get your spreadsheet to print correctly? If so, then you may have discovered that it is surprisingly difficult. Whether the …
How to Print Part of a Worksheet in Excel 2013
It’s really easy to make a mistake when you are trying to print an Excel spreadsheet. But even if you have gone through and made …
How to Use the AutoFit Excel Shortcut for Columns and Rows
Adjusting the height of rows or the width of columns in Microsoft Excel is a common activity. But if it’s something that you do a …
How to Display a “0” Instead of #N/A When Using VLOOKUP in Excel 2013
The VLOOKUP formula in Microsoft Excel is one of the most efficient ways to find data in spreadsheets. Along with the concatenate formula, I have …
How to Make All Columns the Same Width in Excel 2013
Microsoft Excel has several tools that can help you format the size of cells. Our article on how to autofit all columns in Excel provides …
How to See Formatting in Excel 2013
Microsoft Excel spreadsheets can have a lot of different types of formatting. Usually, Excel will be able to determine the appropriate formatting type based on …
How to Save a Spreadsheet as a One Page PDF in Excel 2013
Turning a file into a single page PDF is a great way to make something that can be easily printed or shared. But Microsoft Excel …
How to Insert a Row in Excel 2013 (A Quick 4 Step Guide)
It’s really easy to miss some information when you are doing a lot of data entry in Microsoft Excel. Sometimes you can just add that …
How to Freeze a Row in Excel (A Quick 4 Step Guide)
When you need to use the Microsoft Excel lock row utility, it’s often because you have a lot of data and it’s tough to remember …
How to Change the Number of Displayed Decimal Places in Excel 2013
Microsoft Excel 2013 provides a lot of ways for you to change the formatting of your data. There are ways to convert text to numbers …
How to Make a Blank Excel Sheet Printable
If you’ve ever tried to print a page of Excel cells that didn’t have any information in them, then you probably know that it can …
How to Fit to One Page in Excel 2013 (3 Different Options)
Getting a spreadsheet to correctly fill a single page can be quite the task in Microsoft Excel. If you’ve ever tried to drag around columns …
How to Make a Christmas List Spreadsheet in Excel
While elements of Christmas shopping have gotten easier with online shopping, it can still be tough to keep track of spending and purchases. One way …
How to Expand All Rows in Excel 2013
While the standard structure of a spreadsheet is ideal for storing small bits of data in each cell, you may eventually need to store long …
How to Add Same Header to All Sheets in Excel 2013
When you want to make the same change to multiple cells in a Microsoft Excel worksheet, then you can usually do so by selecting all …
How to Calculate Median in Excel 2013
Learning how to calculate a median in Excel 2013 is similar to learning how to perform most other mathematical functions within the program, such as …
How to Use Print View – Excel 2013
Working with data in Microsoft Excel can have an extra element of difficulty when printing is involved. Often it can make things a bit easier …
How to Add a Text Box Outline in Excel 2013
Occasionally you will need to display content in a spreadsheet in a location other than a cell. Creating a text box can be a good …
How to Remove a Vertical Page Break in Excel 2013
As you enter information into a spreadsheet in Microsoft Excel you may not be paying attention to how that data will be displayed if you …
How to Remove Last Digit in Excel 2013
The Microsoft Office spreadsheet application, Microsoft Excel, offers a lot of ways that you can manipulate the values within the cells of your spreadsheets. For …
How to Add the Filename to the Header in Excel 2013
While you may already be familiar with specific formatting requirements that you need for school or work when working in Microsoft Word, it’s also possible …
How to Change Font in Excel 2013 for a Whole Worksheet
When you are trying to change the appearance of text or data in Excel then you need to select the cell that you wish to …
How to Insert a New Worksheet in Excel 2013
Taking advantage of the ability to have multiple sheet tabs in Microsoft Excel is a great way to keep similar types of data organized. For …
How to Remove Text Box Border in Excel 2013
While much of the data that you add to a spreadsheet in Microsoft Excel will probably go inside the cells, you may find that you …
How to Make a Pie Chart in Excel 2013
Placing your data into cells in Excel provides you with ways that you can compare and interact with your data. Typically this will involve various …
How to Change Ruler from Inches to Centimeters in Excel 2013
Since Microsoft Excel spreadsheets often rely on the precision of data that is entered into cells, it’s helpful to be using the unit of measurement …
How to Move a Column in Excel 2013
If you’ve ever re-typed a lot of data in an Excel spreadsheet then it’s probably something that you don’t want to do again. So if …
How to Add Borders in Excel 2013
Excel spreadsheets show a pattern of lines on the screen that represent the perimeters of the cells. These are called gridlines, and they make it …
How to Print More Than One Worksheet on a Page in Excel 2013
A Microsoft Excel workbook can frequently include a number of different tabs called worksheets. Each worksheet in your Excel file might include important information that …
How to Print Excel with Lines
A default spreadsheet in Microsoft Excel 2013 is going to display rows and columns of cells that are separated via a sequence of lines. These …
How to Remove a Password in Excel 2013
Sometimes when you are editing an Excel file you are working with sensitive information. Since anyone with access to your computer or the Excel spreadsheet …