Skip to content
Solve Your Tech
Menu

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
Clear conditional formatting from your selected cells

Remove Cell Fill Color That Will Not Go Away

Last Updated On August 1, 2023 by Matthew Burleigh

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. …

Read More

Categories Programs Tags Fill Color, Macros, Microsoft Excel How-To Guides
how to print on one sheet in excel 2011

How to Print on One Page in Excel 2011

Last Updated On June 15, 2023 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Microsoft Excel 2011, Microsoft Excel How-To Guides, Printing
how to save as xls by default in excel 2010

How to Save as xls By Default in Excel 2010

Last Updated On August 1, 2023 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Macros, Microsoft Excel 2010 How-To Guides, Microsoft Excel How-To Guides, OneDrive
how to move a column in Excel 2010

How to Change Column Order in Excel 2010

Last Updated On June 21, 2023 by Matthew Burleigh

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. …

Read More

Categories Programs Tags Columns, Microsoft Excel 2010 How-To Guides, Microsoft Excel How-To Guides
how to protect a workbook in excel 2011

How to Protect a Workbook in Excel 2011

Last Updated On June 29, 2023 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Microsoft Excel 2011, Microsoft Excel How-To Guides, Passwords
remove a split screen in excel 2010

How to Remove a Split Screen in Excel 2010

Last Updated On June 22, 2023 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Microsoft Excel 2010 How-To Guides, Microsoft Excel How-To Guides, Views
printing excel borders in excel 2010

Printing Cell Borders in Excel 2010

Last Updated On July 5, 2023 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Borders, Microsoft Excel How-To Guides
how to insert a smartart pyramid in excel 2010

How to Insert a Pyramid in Microsoft Excel 2010

Last Updated On June 19, 2023 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Microsoft Excel How-To Guides, Symbols
Choose your new default save format

How to Change the Default File Format in Excel 2011 for Mac

Last Updated On June 5, 2023 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Defaults, Microsoft Excel How-To Guides
disable autocomplete in excel 2013

How to Disable AutoComplete for Cell Values in Excel 2013

Last Updated On June 30, 2023 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Microsoft Excel 2013, Microsoft Excel How-To Guides, Utilities
click clear, then formats

How to Clear Cell Formatting Excel 2011 Guide

Last Updated On August 4, 2023 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Microsoft Excel 2011, Microsoft Excel How-To Guides
click the column to repeat

How to Print the First Column on Every Page in Excel 2013

Last Updated On August 2, 2023 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Microsoft Excel 2013, Microsoft Excel How-To Guides, Titles
clear the rules from an entire sheet in microsoft excel 2010

How to Clear Rules From Entire Sheet in Excel 2010

Last Updated On June 13, 2023 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Microsoft Excel How-To Guides, Worksheets
how to freeze the top row in excel 2011

How to Freeze the Top Row in Excel 2011

Last Updated On June 17, 2023 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Microsoft Excel 2011, Microsoft Excel How-To Guides, Titles
how to copy a worksheet in excel 2010

How to Move a Worksheet Between Workbooks in Excel 2010

Last Updated On June 1, 2023 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Microsoft Excel 2010 How-To Guides, Microsoft Excel How-To Guides, Workbooks
convert csv comma delimited to pipe delimited

Can I Convert CSV to Pipe Delimited in Windows?

Last Updated On June 8, 2023 by Matthew Burleigh

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 …

Read More

Categories Programs Tags CSV, Microsoft Excel How-To Guides, Microsoft Windows 7, Microsoft Windows How-To Guides, Notepad
how to double underline in Excel 2013

How to Double Underline in Excel 2013

Last Updated On August 2, 2023 by Matthew Burleigh

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, …

Read More

Categories Programs Tags Lines, Microsoft Excel 2013, Microsoft Excel How-To Guides
Click "No Scaling"

How to Print a Two Page Spreadsheet on One Page in Excel 2010

Last Updated On June 15, 2023 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Microsoft Excel How-To Guides, Printing
Navigate to Zamzar.com

How To Convert Excel to PDF for Free Online

Last Updated On June 16, 2023 by Matthew Burleigh

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 …

Read More

Categories Web Browsers and Applications Tags Converting, Microsoft Excel How-To Guides
How to Strike Through in Excel 2010

How to Strike Through in Excel 2010

Last Updated On July 25, 2023 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Microsoft Excel 2010 How-To Guides, Microsoft Excel How-To Guides, Strikethrough
How to Remove Strikethrough in Excel

How to Remove Strikethrough in Excel 2010

Last Updated On June 26, 2023 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Microsoft Excel 2010 How-To Guides, Microsoft Excel How-To Guides, Strikethrough
how to change cell format type in Excel

How to Change Text to Number in Excel for Office 365

Last Updated On September 20, 2023 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Microsoft Excel How-To Guides, Microsoft Office
how to count the number of characters in a cell in Excel 2013

How to Use the Character Count Excel 2013 Tool

Last Updated On August 4, 2023 by Matthew Burleigh

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. …

Read More

Categories Programs Tags Formulas, Microsoft Excel 2013, Microsoft Excel How-To Guides
how to enable macros in excel

How to Enable Macros in Excel for Office 365

Last Updated On June 8, 2023 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Macros, Microsoft Excel How-To Guides, Office 365
how to calculate percentage in excel 2013

How to Calculate Percentage in Excel

Last Updated On June 30, 2023 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Featured Excel, Formulas, Microsoft Excel 2013, Microsoft Excel How-To Guides
click the autofit column width option

How to AutoFit All Columns in Excel 2013 (An Easy 4 Step Guide)

Last Updated On June 18, 2023 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Columns, Microsoft Excel 2013, Microsoft Excel How-To Guides
press ctrl + the semi colon

How to Add the Current Date to a Cell in Excel 2010

Last Updated On July 17, 2023 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Microsoft Excel 2010 How-To Guides, Microsoft Excel How-To Guides, Time
how to create bullet lists in excel 2010

How to Insert Bullet List Items in Excel 2010

Last Updated On July 17, 2023 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Microsoft Excel 2010 How-To Guides, Microsoft Excel How-To Guides, Punctuation
insert a row in excel 2013

Inserting and Deleting Rows in Excel 2013

Last Updated On July 31, 2023 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Microsoft Excel 2013, Microsoft Excel How-To Guides, Rows
how to stop excel 2010 from changing numbers to dates

Why Does Excel Keep Changing My Numbers to Dates?

Last Updated On June 30, 2023 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Microsoft Excel How-To Guides, Worksheets
click the list option

How to Create a Drop-Down List in Excel 2010

Last Updated On July 21, 2023 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Featured Excel, Microsoft Excel 2010 How-To Guides, Microsoft Excel How-To Guides, Utilities
how to remove all hyperlinks in Excel 2013

How to Break All Links in Excel 2013

Last Updated On June 23, 2023 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Hyperlinks, Microsoft Excel 2013, Microsoft Excel How-To Guides
how view google calendar file excel

How to View a Google Calendar File in Excel

Last Updated On July 20, 2023 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Google Calendar How-To Guides, Microsoft Excel 2010 How-To Guides, Microsoft Excel How-To Guides
how to show the developer tab in excel 2010

How to Show Developer Tab – Excel 2010

Last Updated On June 17, 2023 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Macros, Microsoft Excel 2010 How-To Guides, Microsoft Excel How-To Guides
how to add the developer tab in excel for mac

How to Enable the Developer Tab in Excel for Mac

Last Updated On June 8, 2023 by Matthew Burleigh

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 …

Read More

Categories Programs Tags MacOS Sierra, Microsoft Excel How-To Guides, Ribbon, Tabs
how to remove the first character from a cell in excel 2013

How to Remove First Character in Excel 2013 Cell

Last Updated On July 21, 2023 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Featured Excel, Formulas, Microsoft Excel 2013, Microsoft Excel How-To Guides
how to change the default save type in excel for mac

How to Change the Default Save Type in Excel for Mac

Last Updated On June 5, 2023 by Matthew Burleigh

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. …

Read More

Categories Programs Tags Defaults, Microsoft Excel How-To Guides
disable formula updates in excel 2010

How to Turn Off Formulas in Excel 2010

Last Updated On July 1, 2023 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Formulas, Microsoft Excel How-To Guides
type the subtraction formula into the cell

How to Subtract in Excel 2013 with a Formula (An Easy 4 Step Guide)

Last Updated On June 29, 2023 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Featured Excel, Formulas, Microsoft Excel 2013, Microsoft Excel How-To Guides
click the color you want to use

How to Change Font Color in Excel 2013

Last Updated On July 27, 2023 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Fonts, Microsoft Excel 2013, Microsoft Excel How-To Guides
uncheck the show sheet right to left option

Why is My Worksheet Backwards in Excel 2010?

Last Updated On July 5, 2023 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Columns, Microsoft Excel 2010 How-To Guides, Microsoft Excel How-To Guides, Worksheets
how to combine three columns into one in Excel 2013

How to Combine Three Columns Into One in Excel

Last Updated On July 28, 2023 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Columns, Concatenate, Formulas, Microsoft Excel 2013, Microsoft Excel How-To Guides
freeze multiple rows in excel 2013

How to Freeze Multiple Rows in Excel 2013

Last Updated On June 19, 2023 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Featured Excel, Microsoft Excel 2013, Microsoft Excel How-To Guides, Titles
enter the new name for the worksheet tab

How to Rename a Worksheet Tab in Excel 2013

Last Updated On June 12, 2023 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Microsoft Excel 2013, Microsoft Excel How-To Guides, Worksheets
Select the row to repeat at the top of your Excel spreadsheet

How to Display The Top Row on Every Page in Excel 2010

Last Updated On June 15, 2023 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Microsoft Excel How-To Guides, Titles
how to unfreeze the top row in excel 2010

How to Unfreeze the Top Row in Excel 2010

Last Updated On May 30, 2023 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Microsoft Excel 2010 How-To Guides, Microsoft Excel How-To Guides, Rows
how to wrap text for all cells in excel 2013 spreadsheet

How to Wrap Text for Every Cell in a Spreadsheet in Excel 2013

Last Updated On July 21, 2023 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Microsoft Excel 2013, Microsoft Excel How-To Guides, Selections
click the Paste arrow, then click transpose

How to Switch a Row to a Column in Excel 2013

Last Updated On June 19, 2023 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Columns, Microsoft Excel 2013, Microsoft Excel How-To Guides
how to change the cell font in excel 2013

How to Change Cell Font in Excel 2013

Last Updated On June 19, 2023 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Fonts, Microsoft Excel 2013, Microsoft Excel How-To Guides
select a sheet, then click OK

How to Unhide a Worksheet in Excel 2010

Last Updated On June 19, 2023 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Microsoft Excel 2010 How-To Guides, Microsoft Excel How-To Guides, Worksheets
Older posts
Page1 Page2 … Page9 Next →

Join Our Free Newsletter

Featured guides and deals

You may opt out at any time.
Read our Privacy Policy

  • iPhone
  • iPad
  • Apple Watch
  • Google Docs
  • Google Sheets
  • Google Slides
  • Google Chrome
  • Microsoft Excel
  • Microsoft Outlook
  • Microsoft Powerpoint
  • Microsoft Windows
  • Microsoft Word
  • Firefox
  • Photoshop
  • Gmail
  • Amazon Fire TV
  • Google Drive
  • Microsoft Edge

info@solveyourtech.com
4845290651
2138 W. Union Blvd.
#1037
Bethlehem, PA 18018
United States

  • SolveYourTech YouTube
  • SolveYourTech Facebook
  • SolveYourTech Instagram
  • SolveYourTech Twitter
  • SolveYourTech Pinterest
  • SolveYourTech LinkedIn
  • SolveYourTech TikTok
  • Newsletter
  • Affiliate Disclaimer
  • Terms of Use
  • Privacy Policy
  • Contact
  • About Us
© SolveYourTech.com 2023
  • Featured
  • Categories
    • Article Topics
    • Application Guides
    • Device Guides
    • Reviews
  • Programs
    • Excel
    • Outlook
    • Powerpoint
    • Windows
    • Word
  • Devices
    • iPhone
    • iPad
    • Apple Watch
    • Fire TV
  • Web Apps
    • Chrome
    • Docs
    • Sheets
    • Slides
  • Store