How to Stop Printing Left-Aligned Pages in Excel 2013
An Excel 2013 spreadsheet that uses the default print settings will often be difficult for readers. It might also be off-centered, depending upon the number of …
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 Insert a Comment in Excel 2013
Sometimes a cell in an Excel worksheet requires a bit of explanation. But it may not be feasible to include that explanation in the cell …
Excel 2013 Formulas Not Working
It can be frustrating, even problematic, when your Excel formulas are not working. We use formulas in our Excel spreadsheets to automatically calculate values for …
How to Enable Formula AutoComplete in Excel 2013
Are you familiar with a lot of the formulas in Excel, but you don’t remember the exact parameters that you need to use? Microsoft Excel …
Why is My Spreadsheet Printing So Small in Excel 2013?
I have found that spreadsheets I receive from other people often have some formatting that is already applied. One big one is the print area, …
How to Use a Different Header for the First Page in Excel 2013
Headers and footers in an Excel spreadsheet offer a simple way to put repeating information at the top of every printed page of your spreadsheet. …
How to Turn Text Sideways in Excel
Text that you enter into the cells of an Excel 2013 spreadsheet is typically oriented from left to right. But there may be situations where …
How to Enable the Fill Handle in Excel 2013
Manually entering a series of numbers into an Excel row or column can be tedious. It’s easy to start typing too quickly and enter an …
How to Skip the Start Screen When Opening Excel 2013
While everyone that uses Microsoft Excel has their own tendencies and preferences, it is common among many of these users to choose a blank workbook …
How to Use the Excel Fit on One Page Printing Option
Microsoft Excel’s Print menu includes a lot of ways that you can format your spreadsheet for printing. However, some of these options are kind of …
How to Show Missing Worksheet Tabs in Excel 2013
Excel workbooks with multiple worksheets are a great way to coordinate data that might not necessarily belong on the same worksheet, but that is relevant …
Excel 2013 – Set Print Area
Excel spreadsheets rarely print how you want them to, and properly configuring a spreadsheet for the physical page is often cited as one of the …
How to Hide Multiple Rows in Excel 2013
Microsoft Excel gives you a lot of ways to store and edit the data in a worksheet. In fact, there are so many different options …
How to Insert a Picture in the Footer in Excel 2013
Repeating information at the top of each printed page of an Excel spreadsheet is helpful when you wish to include a report name or some …
How to Zoom in Excel 2013
Many Excel 2013 users will find that they need to adjust their print settings so that their spreadsheets fit better on a printed page. We …
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 …
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 …
How to Copy a Worksheet in Excel 2013
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 …
How to Shrink Text to Make it Fit in a Cell in Excel 2013
Microsoft Excel has a variety of different view settings that you can customize to change the appearance of your data. Including among these options is …
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, …
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 …
How to Hide Comments and Indicators in Excel 2013
Comments in Microsoft Excel 2013 allow you to identify a problem or question that you have about data in a cell without affecting the data …
How to Combine Two Text Columns in Excel 2013
There are many ways to store data in Excel spreadsheets, and one common choice is placing each piece of data in a separate column. This …
How to Enable AutoComplete in Excel 2013
Excel 2013 has an AutoComplete option that can be turned on or off depending on individual user preference. So if you use Excel 2013 on …
How to Prevent a Picture from Printing in Excel 2013
There are many reasons why you might insert a picture into an Excel 2013 worksheet, but you may find that the picture is problematic when …
How to Set a 50 Percent Print Scale in Excel 2013
Excel spreadsheets that span multiple pages can be difficult to read on the printed page. Fortunately, Excel has several tools that you can use to …
How to Remove Leading Spaces in Excel 2013
You might discover that you need to know how to remove leading spaces in Excel when you have data that is difficult to work with …
How to Only Display the Year for a Date in Excel 2013
There are a lot of different options when it comes to formatting a date in Excel, and the variety of reasons that you might be …
How to Remove Gridlines in Excel 2013
One of the most common changes made to Excel spreadsheets that are going to be printed is the addition of gridlines. We have discussed how …
How to Only Have One Worksheet by Default in Excel 2013
Most workbooks in Microsoft Excel 2013 will include three worksheets by default. Using multiple worksheets within an Excel workbook is helpful when you have a …
How to View a List of Worksheets in Excel 2013
Using multiple worksheets within an Excel 2013 workbook is common when you have a lot of data that you want to keep in the same …
How to Remove Cell Indentation in Excel 2013
It’s helpful to know how to remove indent in Excel when you encounter a spreadsheet where many of the cells have an unwanted space at …
How to Unhide a Worksheet in Excel 2013
It’s common to hide a worksheet in Excel 2013 if it contains information that should not be edited, if the data on the sheet isn’t …
How to Remove the Quickbooks Tab in Excel 2013
The navigation within the Microsoft Excel 2013 program is centered around a series of tabs at the top of the window. Each of these tabs …
How to Change the Starting Page Number in Excel 2013
The default behavior for page numbering in Excel 2013 is to number the first page of the spreadsheet as “1”, then continue increasing that number …
What is the Height of a Row in Excel 2013?
While you may have already figured out how to change the height of a row or the width of a column by dragging their borders, …
Why Can’t I See My Worksheet Tabs in Excel 2013?
Microsoft Excel files are workbooks that can contain individual worksheets within them. You can learn more about the difference between workbooks and worksheets here. You …
How to Put Excel Column A on Right Side
There are some things that you take for granted in applications like Microsoft Excel that you use all the time. One of those things is …
How to Rotate Text in Excel 2013
Occasionally you might need to do something a little unusual in an Excel spreadsheet. This could mean adding a shape or an object or even …
How to Insert an Excel Spreadsheet Into Powerpoint 2013
Excel spreadsheets can be an effective way to communicate data in a Powerpoint presentation, but switching between multiple files is not an ideal solution. Fortunately, …
Remove the Line Through My Text in Excel 2013
There are a lot of different formatting choices that you can make for the data in your Excel 2013 worksheets. Whether you wish to format …
Where is the Developer Tab in Excel 2013?
The navigational system in Microsoft Excel 2013 is based around a ribbon of tools and options at the top of the window. Different settings and …
How to Fix a Slow Cursor in Excel 2013
Is your mouse moving slowly in Microsoft Excel 2013, making it difficult for you to perform the functions that you need? This can occur because …
How to Remove Cell Formatting from Selected Cells in Excel 2010
Almost every Excel user has encountered a situation where the data that they enter into a cell is not displaying the way that they intended. …
What Are Three Ways to Change Column Width in Excel?
Microsoft Excel has a lot of different tools and settings, many of which allow you to perform the same action in multiple ways. One of …
How to Delete Data But Keep Formatting in Excel
Formatting in an Excel spreadsheet can be a very important thing to people reading the spreadsheet. It can add a level of organization and recognition …
How to Remove Shading in Excel 2013
Some people like to use a lot of color in their Excel spreadsheets because it helps them find important information more quickly. But you might …
How to Edit a Link in Excel 2013
Adding a link to a cell in a Microsoft Excel spreadsheet makes it easy for readers of your spreadsheet to visit a Web page that …
How to Add a Link to a Picture in Excel 2013
Adding hyperlinks to documents is a simple and effective way to direct someone to information that is useful or important. Microsoft Excel allows you to …
Where Do I Set the Cell Height in Excel 2013?
Your Microsoft Exccel spreadsheet contains rows and columns where your data can be edited, formatted, and sorted. Occasionally those rows might be too short or …
Why Are Row Numbers Missing in Excel 2013?
Are you working on a spreadsheet that you got from someone else, and you notice that the row numbering is not sequential? This is occurring …
How to Automatically Resize Row Height in Excel 2013
Occasionally you may be working with a spreadsheet in Microsoft Excel 2013 that contains a lot of data that does not fit within the height …
How to Center a Printed Spreadsheet in Excel 2013
Printing in Excel has always required a bit of configuration to get right, and you will likely find that there is something about your spreadsheet …
How to Center All Cells at Once in Excel 2013
The data in a spreadsheet can contain all sorts of information that is useful to your colleagues and coworkers, but some of the importance of …
How to Center Horizontally in Excel 2013
You have probably noticed that the information that you enter into Microsoft Excel is typically aligned to the left if it is text, or it …
How to Hide the Formula Bar in Excel 2013
You can hide the Microsoft Excel 2013 formula bar by clicking the View tab at the top of the window, then unchecking the Formula Bar …
How to Hide the Ribbon in Excel 2013
Starting with Excel 2007, Microsoft changed the way that you navigate menus and make changes to your spreadsheets. This included changing the menu structure from …
How to Find the Highest Value in Excel 2013
Excel 2013 offers a large number of useful formulas that will help you to find or calculate important information from your spreadsheet data. Whether you …
How to Switch from A4 to Letter Paper in Excel 2013
Are you working on an Excel spreadsheet that was created by someone in a different country, and the sizing on the printed spreadsheet is incorrect? …
How to Vertically Center Cell Data in Excel 2013
The text inside of a cell in a Microsoft Excel worksheet is aligned to the bottom of the cell by default. But changes to formatting …
How to Print a Spreadsheet on One Page in Excel 2013
Excel spreadsheets are notoriously tricky to print, and even worksheets that have been optimized for printing can occasionally present problems. Fortunately, there is an option …
How to Change the Number of Sheet Tabs in a Default Excel 2013 Workbook
When you create a new .xlsx file in Microsoft Excel 2013, you are creating a new workbook. An Excel workbook includes a variable number of worksheets, …
How to Show Hidden Cells in Excel 2013
Excel workbook creators often hide rows or columns that contain irrelevant information, or information that is not important for the task that is currently being …
How to Print a Single Column in Excel 2013
Many spreadsheets may only contain a single column of information that is needed for a situation. If the rest of the spreadsheet contains similar types …
How to Stop Excel 2013 From Printing Too Large
Are you trying to print a spreadsheet that you received from someone else, but when you move to the Print screen, everything looks huge in …
How to Change the Gridline Color in Excel 2013
Do you find Excel 2013 to be kind of bland? While there are not a lot of default options for changing the theme of the …
How to Change Cell Border Color in Excel 2013
While the gridlines in a spreadsheet are supposed to be sufficient for separating your data, you might want something a little more pronounced. Or perhaps …
How to Add a Hyperlink in Excel 2013
Excel spreadsheets can be a good place to store a lot of different types of data. But the types of data that you can store …
How to Delete a Page Break in Excel 2013
If you have an Excel spreadsheet that needs to printed in a specific way, then you may have added page breaks using a similar process …
Print a Selection of Cells in Excel 2013
An Excel spreadsheet can contain a lot of information. Maybe you are working on a downloaded copy of a database, or a large order that …
How to Combine First and Last Names Into One Cell in Excel 2013
Spreadsheets in Excel are often used for storing data about customers and employees, and some of the most commonly used data fields in these situations …
How to Sort a Date Column in Excel 2013
Storing dates along with data in an Excel spreadsheet can be helpful when the data in a row is related to that date. But it …
How to Find the Number of Days Between Two Dates in Excel 2013
Excel worksheets can contain all types of different data, including formulas (like one that lets you subtract in Excel), text, numbers, pictures, and dates. Dates …
How to Change Column Color in Excel 2013
An Excel spreadsheet that is devoid of formatting can be difficult to read. This difficulty is even more apparent as the spreadsheet gets larger, and …
How to Delete a Worksheet Tab in Excel 2013
Large spreadsheets and excessive requests for edits can leave you swimming in data in your Excel workbook. Once you have finalized the file and are …
How to Show the Formula Bar in Excel 2013
The layout and appearance of your Excel 2013 installation can be customized in a number of different ways. There is an area of the default …
How to Change the Decimal Separator in Excel 2013
You might want to learn how to change the decimal separator in Excel 2013 if you are finding that your workplace or school requires you …
Can You Put a Watermark in Excel 2013?
If your company or institution has specific document requirements meant to imply ownership of a document, then you may find yourself wondering whether you can …
How to Change Row Height in Excel 2013
Partially hidden text or multiple lines of text are two of the reasons that you might want to learn how to change row height in …
How to Unhide a Row in Excel 2013
Learning how to unhide a row in Excel 2013 can help to solve some confusing situations that arise when you know data is in a …
How to Show Formulas in Excel 2013
Learning how to show formulas in Excel 2013 is a helpful way for you to determine why you might not be calculating the desired result …
How to Password Protect Excel 2013
If you want to know how to password protect in Excel 2013, then you are likely working on a spreadsheet file that contains a lot …
How to Insert a New Excel Spreadsheet in OneNote 2013
OneNote 2013 is a versatile program that makes it possible to organize all of your files and notes in one central location. You can create …
How to Create a Formula in Excel 2013
There is a lot of utility that can come from organizing data in an Excel worksheet. Information is sortable and easy to edit, and you …
How to Change the Color of a Worksheet Tab in Excel 2013
Creating an Excel file that is meant to be shared or worked on with others can be a challenging task. Everyone involved may not have …
How to Change the Default Font in Excel 2013
You can change the default Excel 2013 font by going to File > Options > General > Use this as the default font > selecting …
How to Sort By Color in Excel 2013
Adding a fill color to a row of information in Excel 2013 allows you to visually identify a particular set of information more easily. If …
How to Return to Normal View in Excel 2013
There are some things that you may want to add to your Excel spreadsheet that are only viewable on a printed document, such as adding …
How to Insert a Page Number in Excel 2013
Many spreadsheets that are created in Excel 2013 are only ever intended to be edited and viewed on a computer. In the cases of those …
How to Expand One Row in Excel 2013
If you’ve increased the size of your font, or if you have placed an object like an image in one of your cells, then you …
How to Change the Color of a Cell in Excel 2013
Large spreadsheets are generally pretty difficult to read, whether you are looking at them on a screen or as a printed document. There are a …
Removing Cell Formatting in Excel 2013
Large Excel files can be difficult to read, especially when they contain a lot of data, only some of which might be relevant to a …
How to Print Comments in Excel 2013
Comments are very helpful for identifying potential problems or asking questions without affecting the actual data contained on a spreadsheet. But they can go overlooked …
How to Change the Default View in Excel 2013
Microsoft Excel 2013 has a number of different possible uses, and it isn’t uncommon for one person to take advantage of many of these uses. …
How to Merge Cells in Excel 2013
Do you have a cell with a lot of data that you can’t see? You might have tried to expand the row or the column …
How to Print in Black and White in Excel 2013
Microsoft Excel has a number of different ways in which you can customize how a spreadsheet will print. Since spreadsheets are prone to printing poorly, …
How to Paste as Values in Excel 2013
Have you ever needed to copy cell values, not formulas? It can be frustrating when you discover that you need a way to only copy …
How to Insert a Picture in Excel 2013
Excel’s primary use is to store, compare and analyze data, but the sheer number of tools and options available to Excel users make it a …
How to Print Specific Rows in Excel 2013
We have written previously about printing in Excel 2013, such as this article about how to print all of your columns on one page, but …
How to Save as .xls By Default in Excel 2013
There are a number of different file formats to which you can save documents that you create in Excel 2013, but two of them are …