How to Turn Off Formula AutoComplete in Excel 2013
Not everyone knows every formula in Microsoft Excel, and determining not only the correct formula, but the way to use it, can be difficult. Excel …
Excel
How-to guides and tutorials to help you perform specific tasks and use the Microsoft Excel spreadsheet application.
Where is the Developer Tab in Excel 2007?
There is a tab in the ribbon at the top of Microsoft Excel for many of the types of changes that you want to make …
How to Print an Empty Grid in Excel 2013
If you’ve ever tried to print empty cells in Excel then you have likely discovered that it isn’t as simple as going to the Print …
How to Unhide Columns in Excel 2016
Hiding columns is a great tool in Microsoft Excel when you have data that you can’t delete, but don’t want to leave visible. But you …
How to Freeze a Row in Excel
Making a large Excel spreadsheet more user-friendly can be difficult. But one way that you can improve it is by learning how to freeze a …
How to Delete a Comment in Excel for Office 365
Using comments and the other review tools in Microsoft Excel provides you with some convenient ways to collaborate on a project. Other users are able …
How to Switch the Format for a Whole Column in Excel for Office 365
Microsoft Excel gives you the option to specify the formatting for your cells. This is helpful if you are entering percentages, or currency, as anything …
How to Group Rows in Excel for Office 365
The steps in this article are going to show you how to select a number of rows and put them into a group using the …
How to Open the Watch Window in Microsoft Excel for Office 365
The steps in this article are going to show you where to find the button that opens the Watch Window in Microsoft Excel. We cover …
How to Stop a Picture from Printing in Excel for Office 365
This guide is going to show you how to change the settings for a picture in Microsoft Excel so that the picture doesn’t print. We …
How to Sum a Column in Excel
An important element of many spreadsheets is a row that displays the totals of your cell values. In a work environment, these totals are often …
How to Make an Exponent in Excel
Adding text and numbers to cells in Microsoft Excel is typically as easy as clicking on a cell and typing. Things get a little more …
How to Set the Height or Width of a Picture in Inches in Excel 2013
Adding pictures to a spreadsheet can be important if you are sending a list of products to a potential customer and want them to see …
What Does Transpose Do in Excel?
There are a number of different ways that you can paste information that you have copied in Excel. You can paste data without any formatting, …
How to Wrap Text in Excel 2013
Often when you type a lot of text into a cell in Microsoft Excel 2013, all of that text isn’t going to fit into the …
How to Add a Signature Line in Excel 2013
Adding a line for signatures to a Microsoft Excel document can be accomplished a couple of different ways. The first option that many will use …
How to Change Excel’s Decimal Separators to Commas
The decimal separator is a character that indicates that the numbers to the right of that character are less than one full unit. In some …
Why Is Excel Only Showing Two Decimal Places?
Excel can be used for many purposes, including ones where you need to store numbers to a high degree of specificity. This often involves entering …
How to Clear Data and Formatting from a Whole Spreadsheet in Excel Online
You have probably run into situations in the past where you needed to delete data from a couple of cells in your Excel spreadsheet. This …
How to Change the Name of a Document in Excel Online
When you create a new spreadsheet in Microsoft Excel Online, the name of the spreadsheet is going to be something generic like “Book1,” If you …
How to Apply Currency Formatting in Excel Online
When you type numbers into a cell in Excel Online, that data is going to be formatted as a number by default. This means that …
How to Change the Format of a Cell in Excel Online
One of the best parts about using Excel online is how many of the program’s features are available in that version. You can perform most …
How to Print Formulas in Excel Instead of Their Results
When you are working in Excel for school or work, one of the more important things that you can learn is how to use formulas. …
How to Insert a Column in Excel 2013
Sometimes you may determine that the data that you have in your spreadsheet isn’t all of the data that you actually need. You might need …
How to Change from Lowercase to Uppercase in Excel 2013
The case of the data that you type in Microsoft Excel is something that you probably don’t think about until it becomes a problem. Depending …
How to Set Column Width and Row Height in Inches Using Page Layout View in Excel 2013
It’s rare that the default column widths and row heights in your Excel spreadsheet will be the right size for all of your data. You …
How to Change Page Order in Excel 2013
When you print a large spreadsheet in Microsoft Excel 2013, the default behavior is for the data to print down, then over. This means that …
How to Print Headings in Excel 2013
Keeping track of which data goes in which columns is often a problem for people reading printed Excel spreadsheets. The columns can start to look …
How to Set Page Layout as the Default View in Excel 2013
On a new installation of Microsoft Excel 2013, new workbooks that you create will use the Normal view. This allows you to see a lot …
How to Hide a Tab on the Ribbon in Excel 2013
The row of buttons and tabs at the top of your Excel window is called the ribbon, and it offers an efficient way for you …
How to Change the Default Number of Worksheets in an Excel 2013 Workbook
A file in Microsoft Excel is called a workbook, and that workbook can include a number of different spreadsheets called worksheets. Organizing large amounts of …
How to Change the Color Scheme in Excel 2010
If you have used Excel for a while, then you have probably acclimated yourself to the visual appearance of the program. But the colors of …
How to Use a Different Decimal Separator in Excel 2013
Depending upon your current geographic location and your field of study, you may be used to a specific character that separates your decimal values. However, …
How to Unhide a Worksheet Tab in Excel 2013
Hiding data in an Excel spreadsheet is a common practice when there is data that isn’t necessary to view, but that you either need for …
How to Make All Columns the Same Width in Excel 2013
Having very wide or very skinny columns in Excel can make it difficult to work with the rest of the data in your spreadsheet. Whether …
How to Remove a Split Screen in Excel 2013
Often when you are working with a lot of data in Excel you will need to scroll to a point where a column or row …
How to Disable Formula Updates in Excel 2013
Formulas that you use in Excel can perform a number of calculations or functions that automate some of the work that you are doing. These …
How to Set the Default Browser for Excel 2013 Links
It’s not uncommon for someone to have more than one Web browser on their computer. Windows 7 includes Internet Explorer by default, but you may …
How to Use a Gradient Fill Effect in Excel 2013
Using fill colors in Microsoft Excel 2013 is a great way to identify similar data and give people that are reading your data an additional, …
How to Elongate a Cell in Excel 2013
Is there a lot of information that you are trying to include in a cell in your worksheet, and you would like to make sure …
How to Shrink Text to Fit Inside a Cell in Excel 2013
When data inside the cells of an Excel spreadsheet overlap, then some of the data can be hidden. For certain types of use cases in …
How to Add a Comment in Excel 2013
Collaborating on a spreadsheet with a group of people can be difficult, particularly when people have questions about information contained within that spreadsheet. Referencing cells …
How to Show the Developer Tab in Excel 2013
Are you trying to follow a tutorial or guide online that is telling you to select an option on the Developer tab in Excel 2013? …
How to Remove a Watermark from a Spreadsheet in Excel 2013
Some companies or organizations like to include their logo as a background watermark when they share Excel files internally and externally. While this can be helpful …
How to Paste from Horizontal to Vertical in Excel 2013
Many times when working with data in Excel I am not positive how I will need to organize the data. I am hoping that my …
How to Print Comments in Excel 2013
Comments are an invaluable tool for people that often work in teams on their Excel spreadsheets. It allows a conversation to occur concerning the data …
How to Center a Printed Spreadsheet in Excel 2013
Last updated: March 16, 2019 Is your spreadsheet printing at the very left of the page, or at the very top? Does it look strange, …
How to Delete a Footer in Excel 2013
The footer section at the bottom of the page in Excel 2013 is a convenient location for notes about your data, page numbering, file names, …
How to Clear Cell Formatting in Excel 2013
When someone sends you a spreadsheet that you need to edit or work with, it is very likely that they have already made some formatting …
Can I Get Rid of the Lines on My Spreadsheet in Excel 2013?
Excel uses a grid system to define the vertical and horizontal limits of a cell. This grid system is called “gridlines” in Excel, and serves …