Remove Cell Fill Color That Will Not Go Away
There is a Fill Color button in Microsoft Excel that you can typically use to add or remove a background color from some selected cells. …
Microsoft Excel How-To Guides
Articles to help you answer questions and fix problems that you might be having with different versions of the Microsoft Excel spreadsheet application.
Not sure where to start? Check out our featured Microsoft Excel guides below:
- How to Create a Drop-down List in Excel – create and use a drop-down list in one of the cells in your spreadsheet.
- How to Subtract in Excel – use a formula to subtract cell values or numbers from one another.
- How to Remove the First Character in Excel – use a formula to remove the first one, two, or more characters from a string in Excel
How to Print on One Page in Excel 2011
Sometimes a spreadsheet that you are trying to print in Microsoft Excel 2011 is going to have one too many rows or columns to naturally …
How to Save as xls By Default in Excel 2010
The Excel 2010 default file save format in .xlsx, which is great when you are working with people that are using Excel 2010 or newer …
How to Change Column Order in Excel 2010
The initial structure of a spreadsheet in Microsoft Excel 2010 isn’t always perfect, and you sometimes need to put rows or columns in different locations. …
How to Protect a Workbook in Excel 2011
Microsoft Excel workbooks can often contain important or sensitive data that you may not want anyone with the file to be able to see. One …
How to Remove a Split Screen in Excel 2010
Microsoft Excel has several different viewing options that you can pick from when you are editing your spreadsheets. The correct view is the one that …
Printing Cell Borders in Excel 2010
The lines around the cells in your Microsoft Excel spreadsheet are called gridlines, and they serve an important function in visually separating data. If you …
How to Insert a Pyramid in Microsoft Excel 2010
While Microsoft Excel is typically thought of as a way to save, sort, and manipulate data, it has some additional tools that let you add …
How to Change the Default File Format in Excel 2011 for Mac
Whenever you use an application and find that you are switching some settings for every file, it can be a good idea t o change …
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 Clear Cell Formatting Excel 2011 Guide
You can clear the formatting from your cells in Excel 2011 by clicking the gray button at the top-left of the spreadsheet, choosing the Home …
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 Clear Rules From Entire Sheet in Excel 2010
The conditional formatting feature in Microsoft Excel can be a very helpful feature for identifying and sorting data. But if something changes, or you are …
How to Freeze the Top Row in Excel 2011
When you work with bigger spreadsheets, it can be difficult to remember what data goes in which column. If you have been scrolling all the …
How to Move a Worksheet Between Workbooks in Excel 2010
Copying and pasting data between Excel worksheets, or even different workbooks, is a great way to work efficiently. Occasionally, however, you may have an entire …
Can I Convert CSV to Pipe Delimited in Windows?
Whether you have created your own CSV file in an application like Microsoft Excel or Google Sheets, or you have received the file from someone …
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 Print a Two Page Spreadsheet on One Page in Excel 2010
When you have a large spreadsheet that you need to print, adjusting the formatting can be a hassle. The individual page formatting options in Excel …
How To Convert Excel to PDF for Free Online
There are several online conversion utilities, such as Zamzar.com, that allow you to convert your Excel files to PDF files. The conversion process does not …
How to Strike Through in Excel 2010
Text formatting comes in a variety of options. You’ve probably changed a font or font color before, which is an effective way to adjust the …
How to Remove Strikethrough in Excel 2010
Many applications offer you a variety of different ways to change the appearance of your text. You’ve probably done things like bold text or underline …
How to Change Text to Number in Excel for Office 365
Microsoft Excel has a large number of formatting options that you can change. Some of these settings apply to an entire workbook or worksheet, while …
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 Enable Macros in Excel for Office 365
Microsoft Excel has a number of features that can really speed up the way you work with your data. One of these features involves something …
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 …
How to Add the Current Date to a Cell in Excel 2010
There are a lot of tools in Microsoft Excel that serve very specific purposes. Many people won’t use a lot of these, but they can …
How to Insert Bullet List Items in Excel 2010
While much of the data that you add to a Microsoft Excel spreadsheet might only take up one line, situations might exist where you want …
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 …
Why Does Excel Keep Changing My Numbers to Dates?
Occasionally you might enter data into one of your cells in Excel, only to find that Excel has converted that number to a date. This …
How to Create a Drop-Down List in Excel 2010
A spreadsheet with a lot of typos can be tough to work with, so reducing those types of errors is important. A dropdown list is …
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 View a Google Calendar File in Excel
Google usually provides data in a format that is compatible with other applications. You might have already found that you can download Docs files to …
How to Show Developer Tab – Excel 2010
Many tech tutorials that you find online for Microsoft Excel will tell you to navigate via the tabs at the top of the window. This …
How to Enable the Developer Tab in Excel for Mac
While there is a lot that you can do in the Microsoft Excel spreadsheet application on your MacBook Pro or MacBook Air, some of the …
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 …
How to Change the Default Save Type in Excel for Mac
If you are constantly saving your spreadsheets in a different file type than Excel’s default setting, then it’s an easy thing to forget to do. …
How to Turn Off Formulas in Excel 2010
Microsoft Excel formulas are amazing for their ability to quickly perform complex calculations and provide you with an answer. While it can seem like these …
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 …
Why is My Worksheet Backwards in Excel 2010?
Microsoft Excel has a couple of different potential layouts, though many people will only ever see one. A layout option that can be really confusing …
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 Display The Top Row on Every Page in Excel 2010
have you ever been flipping through multiple pages of a spreadsheet to figure out which column a cell belongs to? If so, then you aren’t …
How to Unfreeze the Top Row in Excel 2010
If you have previously frozen the top row of your spreadsheet so that it was easier to identify the data in your cells, then you …
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 to Unhide a Worksheet in Excel 2010
Did you previously hide a worksheet because it contained important information that you didn’t want anyone to edit? Or perhaps you simply have too many …