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 …
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 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 …
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 easily if you copy and paste information from other locations, or …
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 …
How to Create a Pivot Table in Excel 2013
Microsoft Excel is full of useful tools that can help you get the information that you need from your source data. But if you have …
How to Convert MM to Inches in Excel 2013
Converting units of measurement is a necessary evil for a lot of people in a wide variety of fields. Fortunately if you want to convert …
How to Find an Average in Excel 2013
Microsoft Excel includes a number of different ways that you can calculate totals or values based on your cell data. But if you need to …
How to Stop Showing a Dollar Sign in Excel 2013
Formatting data properly in Excel can solve a lot of problems that you might have with your formulas, or with readers understanding your data. But …
How to Delete a Comment in Excel 2013
We have previously written about how to add a comment to a cell in Excel 2013, but what if you need to delete a comment …
How to Delete a Header in Excel 2013
Information in the header of a spreadsheet can include things like page numbers, you name, or the name of a report. But if that information …
How to Split Full Names Into Two Cells in Excel 2013
Excel has a lot of helpful features for managing data, and many of them can save you a lot of manual work. For example, you …
How to Print Each Worksheet of an Excel 2013 Workbook on One Page
When you have an Excel workbook with a lot of individual worksheets, you might need to print all of those sheets at once, and you …
How to Make a Table in Excel 2013
While the layout of a spreadsheet in Microsoft Excel is reminiscent of a table by default, Excel actually has a tool to make tables from …
How Do You Name Columns in Excel 2013?
Adding a row of headings to the top of your spreadsheet is an effective way to describe the data in your cells. This is especially …
How to Insert an Arrow in Excel 2013
If you want to subtract in Excel, there’s a formula that can help you do it. The same goes for other common mathematical operations, as …
How to Calculate Age from a Birthdate in Excel 2013
Excel has a lot of tools that can help you calculate values based on data that you’ve entered. You’ve probably had to add up values …
How to Display Numbers Without a Comma in Excel 2013
Are some of the numbers in your spreadsheet currently formatted to display commas as a 1000 separator? This is an option in Excel, and it …
Can I Name a Worksheet Something Other Than Sheet1, Sheet2, etc in Excel 2013
Excel files are often referred to a spreadsheets, but they are actually files called workbooks, and they can contain multiple spreadsheets within them. These spreadsheets …
How to Add Row Numbering in Excel 2013
Numbering your rows in Excel is helpful when you need to reference a particular cell either to another person or as part of a formula. …
How to Change the Page Order in Excel 2013
It’s very common for an Excel spreadsheet to be too large to fit on one page. Additional cells are then pushed to another page, and …
How to Hide Multiple Worksheets in Excel 2013
The ability to hide worksheets in an Excel workbook can be very helpful when you need to share a spreadsheet with someone else, but there …
How to Change the Order of Items in the Excel 2013 Quick Access Toolbar
The Quick Access Toolbar in Excel 2013 gives you the ability to quickly perform some common commands that would otherwise require you to navigate through …
How to Delete All Comments from a Worksheet in Excel 2013
We have previously written about how to delete a comment in Excel 2013 when you have a specific comment in a spreadsheet that you no …
How to Concatenate Text in Excel 2013
Retyping data is always a hassle in spreadsheets. It’s also prone to errors, so you might be looking for a better way to combine data …
How to Refresh a Pivot Table in Excel 2013
Entering all of the data into your spreadsheet and using it to create a pivot table in Excel is a great way to manage your …
Why Are My Column Labels Numbers Instead of Letters in Excel 2013?
If your Microsoft Excel application has column numbers instead of letters, then you may be wondering not only how that happened, but how you can …
How to Delete a Text Box in Excel 2013
If you have a text box in an Excel spreadsheet that you need to delete, then you might be wondering how that is possible. There …
How to Select Entire Spreadsheet in Excel 2013 (An Easy 2 Step Guide)
Occasionally you might need to make a change that affects all of the cells in a spreadsheet. But if you’ve ever tried to manually select …
How to Expand Cells Horizontally in Excel 2013
While the standard Excel cell width can hold several characters’ worth of data before things start to become hidden, you will probably need to know …
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 …
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 …
How to Add Leading Zeroes to Numbers in Excel 2013
If you are working with numbers that might include zeroes at the start of those numbers, then you might be running into a problem. Excel …
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 …
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 …
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 …
How to Change Tracking Numbers from Scientific Notation in Excel 2013
If you are working with a lot of shipping data in a Microsoft Excel spreadsheet, then you will likely need to store information about tracking …
Why Is Excel Still Printing Lines When I Have Already Turned Off Gridlines?
Excel spreadsheets can be difficult to read when you print them without any kind of lines to separate data in cells. On paper this can …
How to Stop Excel from Removing the Second Decimal Place If It’s a Zero
Excel 2013 has a wide range of formatting choices that can be applied to cells in a worksheet. But some of the default formatting choices …
How to Resize a Picture in Excel 2013
Many of the pictures that you have on your computer, whether they are screenshots or pictures from a digital camera, are probably rather large. This …
How to Reset a Picture to Its Original Size in Excel 2013
A picture that you insert into a spreadsheet in Excel 2013 is unlikely to be the right size or in the right format that you …
How to See Which Files Excel 2013 Will Open By Default
Microsoft Excel is the common choice when you need to select a program to open .xls or .xlsx files. In fact, it probably obtained those …
How to Show Two Decimal Places in Excel 2013
A spreadsheet can look a little messy and be difficult to read when it has inconsistent formatting. But often, this inconsistency is simply due to …
Why Aren’t My Arrow Keys Working in Excel 2013?
Rather than using your mouse to click between the different cells of your spreadsheet in Excel 2013, you may have found that the arrow keys …
How to Turn Off Background Error Checking in Excel 2013
Excel 2013 is constantly scanning for errors in your workbook. This occurs in the background and is the reason that you often see a small …
How to Hide Gridlines in Excel 2013
Gridlines in Excel 2013 offer an effective way to visually separate your data into distinct cells. These gridlines can appear on the screen when you …
How to Set Excel Column Width in Inches
If you’ve ever tried to adjust the width of your columns for printing then you have probably found it to be a little frustrating. This …
How to Multiply in Excel 2013
If you are trying to figure out how to multiply in Excel 2013, then you might be struggling to find the formula or option to …
How to Disable AutoRecover for a Specific Workbook in Excel 2013
The AutoRecover feature in Microsoft Excel 2013 can help to save your work in the event that your computer shuts down unexpectedly before you have …
What is the Difference Between “Clear Hyperlinks” and Remove Hyperlinks in Excel 2013?
Excel 2013 has a habit of turning text that looks like a Web page address or file location into a link. This is helpful if …
Why Isn’t My Sum Updating in Excel 2013 Anymore?
A sum that is not updating automatically in Excel 2013 can be frustrating and, depending upon the importance of the information that it affects, potentially …
How to Cross Out in Excel 2013
Microsoft Excel has a lot of formatting options that let you do things like convert text to numbers in Excel. But you may be looking …
How to Alphabetize in Excel 2013
Excel 2013 provides numerous utilities that allow you to organize, store, and interact with your data. Perhaps one of the most helpful and most commonly …
How to Print an Excel Spreadsheet on A4 Paper
In a perfect world, you wouldn’t need to make any changes to your Excel files before you print them. But whether you need to know …
How to Put a Bulleted or Numbered List in Excel Cell
Microsoft Excel’s default layout of cells in rows and columns is a great place to start when you’re organizing data. But you might be wondering …