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