How Do I Make My Font Smaller or Larger by Default in Microsoft Excel?
Is the font in your spreadsheets difficult ot read because it’s so small? Or are you having trouble seeing all of your data because the …
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
Why Isn’t Excel 2013 Showing the Files That I Want to Open?
Are you trying to open a file that you know is compatible with Excel, but it’s not showing in File Explorer? When you click Open …
How to Show Ruler in Excel 2010
While your primary concern when working with data in an Excel spreadsheet may be ensuring that the data is correct, you may also need to …
How to Switch a Row to a Column in Excel 2010
Do you have data in a spreadsheet that is in a row but should be in a column? You might have tried to copy and …
How to Insert a Page Break in Excel 2013
Have you been trying to get your spreadsheet to print correctly? If so, then you may have discovered that it is surprisingly difficult. Whether the …
How to Automatically Insert Decimal Point in Excel 2010
If you spend a lot of time in Microsoft Excel then you have probably either forgotten to include a decimal point at some point, or …
How to Print Part of a Worksheet in Excel 2013
It’s really easy to make a mistake when you are trying to print an Excel spreadsheet. But even if you have gone through and made …
How to Use the AutoFit Excel Shortcut for Columns and Rows
Adjusting the height of rows or the width of columns in Microsoft Excel is a common activity. But if it’s something that you do a …
How to Set the Print Area in Excel 2011
Do you want to print some of the data in your Excel spreadsheet, but you don’t want to waste ink or paper printing a lot …
How to Stop Showing Zeroes in Cells in Excel 2010
When you enter a formula into one of the cells in your Microsoft Excel worksheet you will see the result of that formula by default. …
How to Turn off Auto Complete in Excel 2010
In situations where you are tying a long word or value that is easy to mistype, then the autocomplete feature can be really useful. This …
Excel Print Guide – Changing Important Print Settings in Excel 2010
Microsoft Excel is a great way to manage and edit large amounts of data. The row and column structure, combined with all of the different …
Can I Convert a Microsoft Word Table to Excel?
While it might initially seem like there wouldn’t be a lot of crossover in the types of information that you have in a Word document …
Can I Repeat Rows in Excel When I Print?
Large spreadsheets with a lot of rows can be difficult to edit. Keeping all of the data in the correct location can often require some …
How to Display a “0” Instead of #N/A When Using VLOOKUP in Excel 2013
The VLOOKUP formula in Microsoft Excel is one of the most efficient ways to find data in spreadsheets. Along with the concatenate formula, I have …
How to Make All Columns the Same Width in Excel 2013
Microsoft Excel has several tools that can help you format the size of cells. Our article on how to autofit all columns in Excel provides …
How to Color Cells in Excel
If you’re wondering how to fill a cell with color in Excel, then it’s probably because you are trying to make your data easier to …
How to See Formatting in Excel 2013
Microsoft Excel spreadsheets can have a lot of different types of formatting. Usually, Excel will be able to determine the appropriate formatting type based on …
How to Delete a Sheet in Excel 2010
New Microsoft Excel files often contain a couple of blank tabs where you can add data. But if you only need one tab for your …
Why Isn’t My Entire Spreadsheet Printing in Excel 2010?
If you have finished creating or editing a spreadsheet in Microsoft Excel and then gone to print it out, you might find that it hasn’t …
How to Save a Spreadsheet as a One Page PDF in Excel 2013
Turning a file into a single page PDF is a great way to make something that can be easily printed or shared. But Microsoft Excel …
How to Insert a Row in Excel 2013 (A Quick 4 Step Guide)
It’s really easy to miss some information when you are doing a lot of data entry in Microsoft Excel. Sometimes you can just add that …
How to Freeze a Row in Excel (A Quick 4 Step Guide)
When you need to use the Microsoft Excel lock row utility, it’s often because you have a lot of data and it’s tough to remember …
How to Make a Row Bigger in Excel 2010
Adjusting the size of the cells in your spreadsheet is a pretty common occurrence, so you will eventually need to know how to make a …
How to Change the Number of Displayed Decimal Places in Excel 2013
Microsoft Excel 2013 provides a lot of ways for you to change the formatting of your data. There are ways to convert text to numbers …
Microsoft Excel Add Column Tutorial
You can do a lot to compare, edit, and evaluate your data when you enter values into a spreadsheet. One common action that people using …
How to Make a Blank Excel Sheet Printable
If you’ve ever tried to print a page of Excel cells that didn’t have any information in them, then you probably know that it can …
How to Create a Pivot Table in Excel 2010
While there is a lot that you can do to sort and total data in normal cells of an Excel spreadsheet, the Pivot Table tool …
How to Fit to One Page in Excel 2013 (3 Different Options)
Getting a spreadsheet to correctly fill a single page can be quite the task in Microsoft Excel. If you’ve ever tried to drag around columns …
How to Enlarge Cells in Excel 2010
The default cell size in Microsoft Excel is rarely going to be correct for the data that you are entering into a cell. You might …
How to Make a Christmas List Spreadsheet in Excel
While elements of Christmas shopping have gotten easier with online shopping, it can still be tough to keep track of spending and purchases. One way …
How to Change Lowercase to Uppercase in Excel 2010
Despite the annoyance that many people have for caps lock and people that write in all uppercase letters, it does have its place in certain …
Microsoft Excel Create Table Guide
If you’ve ever used a worksheet in Excel that contained a table, then you’ve probably noticed how useful of a tool it can be. But …
How to Expand All Rows in Excel 2013
While the standard structure of a spreadsheet is ideal for storing small bits of data in each cell, you may eventually need to store long …
How to Hide Tabs in Excel 2010
Being able to edit a visible property for one of your cells or worksheets in Microsoft Excel typically involves switching between the different tabs on …
How to Print All Columns in Excel 2010 on One Page
Microsoft Excel can be a difficult application to work with when you need to print a spreadsheet. One common problem involves getting your column to …
How to Fill Column With Same Value in Excel 2010
It’s possible that you have already noticed how often the mouse cursor can change as you hover over various parts of your spreadsheet. These cursor …
How to Turn Off Autofill in Excel 2010
Taking advantage of the various convenience features in applications like Google Sheets or Microsoft Excel is a great way to make yourself more efficient. One …
How to Add Same Header to All Sheets in Excel 2013
When you want to make the same change to multiple cells in a Microsoft Excel worksheet, then you can usually do so by selecting all …
How to Calculate Median in Excel 2013
Learning how to calculate a median in Excel 2013 is similar to learning how to perform most other mathematical functions within the program, such as …
How to Justify Text in Excel 2010
While Microsoft Excel 2010 is most useful as a means to store, organize and compare data, you will eventually have to put some of your …
What is the Difference Between a Workbook and a Worksheet in Excel 2010?
Have you seen the terms “worksheet” and “workbook” a lot when reading about Microsoft Excel? They may seem like the same thing, or at least …
How to Use Print View – Excel 2013
Working with data in Microsoft Excel can have an extra element of difficulty when printing is involved. Often it can make things a bit easier …
How to Add a Text Box Outline in Excel 2013
Occasionally you will need to display content in a spreadsheet in a location other than a cell. Creating a text box can be a good …
How to Move a Row in Excel 2010
Learning how to move a row in Excel 2010 is a good way to quickly adjust the layout of the data in an Excel worksheet. …
How to Turn Off Auto Hyperlink in Excel 2010
Hyperlinks in productivity applications like Microsoft Word, Microsoft Powerpoint, or Microsoft Excel can be useful to people that are reading your documents. It provides a …
How to Unhide Formula Bar in Excel 2010
Knowing exactly what you are working on is critical in Microsoft Excel, especially when you are adjusting a formula. One way to make this a …
How to Remove a Vertical Page Break in Excel 2013
As you enter information into a spreadsheet in Microsoft Excel you may not be paying attention to how that data will be displayed if you …
How to Remove an Excel 2010 Watermark
While there is no direct way to add a watermark in Excel, there are a variety of alternatives, including header and footer tools, basic image …
How to Remove Last Digit in Excel 2013
The Microsoft Office spreadsheet application, Microsoft Excel, offers a lot of ways that you can manipulate the values within the cells of your spreadsheets. For …