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:
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. But you might encounter a situation where that’s not working. This is because the creator of that spreadsheet is using something called “conditional formatting” to apply the fill color. Our … Read more
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 fit on one page. You can attempt a couple of different options to resolve this problem, but there is actually an option in Excel 2011 specifically meant to handle this … Read more
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 versions. But when you have coworkers who are using older versions of Microsoft Excel, then they might not be able to open those files. Our tutorial will show you how … Read more
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. While there are a couple of ways to accomplish this, one effective solution involves copying and pasting entire ranges of data. This tutorial about how to change column order in … Read more
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 way that you can help to protect that data is by adding a password to the file. Our tutorial will show you how to protect a workbook in Excel 2011 … Read more
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 makes it the easiest for you to see the information that is important to you while allowing you to comfortably navigate the application’s interface. But if there is a split … Read more
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 have ever turned off gridlines in a spreadsheet then you probably know how difficult their absence can make it to work. This problem becomes evident on printed spreadsheets as well, … Read more
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 objects and media to your spreadsheets. You might have already added a picture or a text box in the past, but there are also tools to add shapes, even some … Read more
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 the default settings. The Microsoft Excel 2100 for Mac application has many of its own default settings, including one for the types of files that it creates. Our tutorial below … Read more
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 expecting this and want to incorporate it into the way you edit spreadsheets, then it can be a helpful tool. But if you find that is causing problems, then our … Read more