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, …
Excel
How-to guides and tutorials to help you perform specific tasks and use the Microsoft Excel spreadsheet application.
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 …
How to Show Tabs in Excel 2013
A Microsoft Excel spreadsheet is a powerful tool for individuals and companies that need to organize, sort, and compare data. Excel spreadsheets are typically part …
How to Remove a Page Break in Excel 2013
Manual page breaks in Excel 2013 can be helpful when you have rows or columns that are printing on the wrong page, or if the …
Why Is the Top Row Always Displayed on My Excel 2013 Spreadsheet?
Large worksheets full of data in Excel can get very confusing, very quickly. This problem is amplified when the individual columns of the spreadsheet contain …
How to Print on Legal Paper in Excel 2010
Excel spreadsheets are notoriously difficult to print. The default print settings don’t include gridlines, won’t repeat titles or headers on each page, and are not …
How to Make All Negative Numbers Red in Excel 2013
Storing and analyzing data in Excel is something that almost every business will need to do. Whether you are tracking product sales, revenue, or website …
How to Insert a Picture Into a Cell in Excel 2010
Learning how to insert a picture into a spreadsheet in Excel 2010 is useful when you encounter a situation that calls for more than just data …
How to Lock an Image to a Cell in Excel 2010
I often find that I need to lock a picture to a cell in Excel 2010 when I am creating product spreadsheets for customers that …
How to Require a Password to View a Workbook in Excel 2013
You might decide to password protect a file in Excel 2013 if you are storing sensitive or important information, and you wish to limit access …
How to Set Excel Column Width in Inches in Excel 2013
The default unit that Microsoft Excel uses when defining column width is called a point. Unfortunately this can be confusing, as it is not a …
How to Find a Square Root in Excel 2013
Excel can perform a number of mathematical operations with the help of various formulas that it can calculate. You might already be familiar with addition, …
How to Move a Column in Excel 2013
You may need to learn how to move a column in Excel when you have entered some data into your spreadsheet and found that the …
How to Insert a New Worksheet in Excel 2010
Many Excel users typically only work with one worksheet in a workbook, but there is a lot that you can accomplish when you start leveraging …
How to Keep the Top Row Visible in Excel
It’s helpful to keep the top row visible in Excel when you are working with a spreadsheet that has a high number of rows. The …