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
how to change the default font size in excel 2013

How Do I Make My Font Smaller or Larger by Default in Microsoft Excel?

June 20, 2023September 21, 2022 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Fonts, Microsoft Excel 2013, Microsoft Excel How-To Guides
display all files in the folder

Why Isn’t Excel 2013 Showing the Files That I Want to Open?

June 23, 2023September 21, 2022 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Files, Microsoft Excel 2013, Microsoft Excel How-To Guides
how to view the ruler in excel 2010

How to Show Ruler in Excel 2010

August 16, 2023September 19, 2022 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Microsoft Excel 2010 How-To Guides, Microsoft Excel How-To Guides, Rulers
switch a row to a column in Excel 2010

How to Switch a Row to a Column in Excel 2010

June 2, 2023September 15, 2022 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Microsoft Excel How-To Guides, Rows
click breaks, then click insert page break

How to Insert a Page Break in Excel 2013

July 15, 2023September 15, 2022 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Breaks, Microsoft Excel 2013, Microsoft Excel How-To Guides
how to automatically insert a decimal point in excel 2010

How to Automatically Insert Decimal Point in Excel 2010

June 19, 2023September 12, 2022 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Microsoft Excel 2010 How-To Guides, Microsoft Excel How-To Guides, Punctuation
click the print selection button

How to Print Part of a Worksheet in Excel 2013

June 19, 2023September 12, 2022 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Microsoft Excel 2013, Microsoft Excel How-To Guides, Printing, Worksheets
autofit column width

How to Use the AutoFit Excel Shortcut for Columns and Rows

June 19, 2023September 6, 2022 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Columns, Microsoft Excel 2013, Microsoft Excel How-To Guides, Rows
how to set the print area in excel 2011

How to Set the Print Area in Excel 2011

June 19, 2023August 29, 2022 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Microsoft Excel 2011, Microsoft Excel How-To Guides, Printing
hide zeroes in excel 2010

How to Stop Showing Zeroes in Cells in Excel 2010

June 19, 2023August 29, 2022 by Matthew Burleigh

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

Read More

Categories Programs Tags Display, Microsoft Excel How-To Guides
turn off autocomplete in excel 2010

How to Turn off Auto Complete in Excel 2010

June 19, 2023August 25, 2022 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Microsoft Excel How-To Guides, Utilities
a simple guide to better printing in excel 2010

Excel Print Guide – Changing Important Print Settings in Excel 2010

August 29, 2023August 19, 2022 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Featured, Microsoft Excel 2010 How-To Guides, Microsoft Excel How-To Guides, Printing
how to convert a Microsoft Word table to Excel

Can I Convert a Microsoft Word Table to Excel?

June 29, 2023August 15, 2022 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Converting, Microsoft Excel How-To Guides, Microsoft Word How-To Guides, Tables
how to repeat rows in excel 2010

Can I Repeat Rows in Excel When I Print?

June 5, 2023August 15, 2022 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Microsoft Excel How-To Guides, Rows
how to display a zero instead of #n/a in excel 2013 vlookup formula

How to Display a “0” Instead of #N/A When Using VLOOKUP in Excel 2013

July 1, 2023August 12, 2022 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Formulas, Microsoft, Microsoft Excel 2013, Microsoft Excel How-To Guides
how to change the width of multiple columns in excel 2013

How to Make All Columns the Same Width in Excel 2013

June 27, 2023August 11, 2022 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Columns, Microsoft Excel 2013, Microsoft Excel How-To Guides
how you fill a cell with color in Excel

How to Color Cells in Excel

August 15, 2023August 5, 2022 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Fill Color, Microsoft Excel How-To Guides
check the cell format in excel 2013

How to See Formatting in Excel 2013

October 14, 2023July 28, 2022 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Microsoft Excel 2013, Microsoft Excel How-To Guides, Views
how to delete a worksheet in excel 2010

How to Delete a Sheet in Excel 2010

June 29, 2023July 28, 2022 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Microsoft Excel 2010 How-To Guides, Microsoft Excel How-To Guides, Worksheets
click the page layout tab

Why Isn’t My Entire Spreadsheet Printing in Excel 2010?

July 20, 2023July 20, 2022 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Microsoft Excel 2010 How-To Guides, Microsoft Excel How-To Guides, Worksheets
how to fit a spreadsheet to one page and save it as a pdf in excel 2013

How to Save a Spreadsheet as a One Page PDF in Excel 2013

July 21, 2023July 4, 2022 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Microsoft Excel 2013, Microsoft Excel How-To Guides, PDF
how to insert a new row in Excel 2013

How to Insert a Row in Excel 2013 (A Quick 4 Step Guide)

May 30, 2023July 1, 2022 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Microsoft Excel 2013, Microsoft Excel How-To Guides, Rows
click the freeze panes button

How to Freeze a Row in Excel (A Quick 4 Step Guide)

June 12, 2023July 1, 2022 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Microsoft Excel 2013, Microsoft Excel How-To Guides, Rows
enter a new row height

How to Make a Row Bigger in Excel 2010

September 20, 2023June 29, 2022 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Microsoft Excel 2010 How-To Guides, Microsoft Excel How-To Guides, Rows
how to increase the number of decimal places in excel 2013

How to Change the Number of Displayed Decimal Places in Excel 2013

July 1, 2023June 16, 2022 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Microsoft Excel 2013, Microsoft Excel How-To Guides, Punctuation
how to add a column in Microsoft Excel

Microsoft Excel Add Column Tutorial

June 1, 2023June 14, 2022 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Columns, Microsoft Excel How-To Guides
set the print area

How to Make a Blank Excel Sheet Printable

June 19, 2023June 14, 2022 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Microsoft Excel 2013, Microsoft Excel How-To Guides, Tables
Select pivot table from the Insert menu

How to Create a Pivot Table in Excel 2010

August 3, 2023June 14, 2022 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Microsoft Excel How-To Guides, Pivot Tables
fit to one page in excel 2013

How to Fit to One Page in Excel 2013 (3 Different Options)

June 15, 2023June 10, 2022 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Microsoft Excel 2013, Microsoft Excel How-To Guides
how to enlarge a cell in Excel 2010

How to Enlarge Cells in Excel 2010

July 7, 2023June 9, 2022 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Columns, Microsoft Excel How-To Guides, Rows
how to create a christmas list in excel

How to Make a Christmas List Spreadsheet in Excel

July 9, 2023June 6, 2022 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Christmas, Microsoft Excel 2013, Microsoft Excel How-To Guides, Pivot Tables
how to make all text uppercase in excel 2010

How to Change Lowercase to Uppercase in Excel 2010

July 3, 2023June 2, 2022 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Microsoft Excel How-To Guides, Punctuation
how to create a table in Microsoft Excel

Microsoft Excel Create Table Guide

August 22, 2023May 26, 2022 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Microsoft Excel How-To Guides, Tables
how to expand all rows in excel 2013

How to Expand All Rows in Excel 2013

June 15, 2023May 26, 2022 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Microsoft Excel 2013, Microsoft Excel How-To Guides, Rows
uncheck the show sheet tabs option

How to Hide Tabs in Excel 2010

July 15, 2023April 12, 2022 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Microsoft Excel 2010 How-To Guides, Microsoft Excel How-To Guides, Tabs
how to fit all columns on one page in excel 2010

How to Print All Columns in Excel 2010 on One Page

June 30, 2023March 30, 2022 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Columns, Microsoft Excel 2010 How-To Guides, Microsoft Excel How-To Guides
position your mouse at the bottom-right corner

How to Fill Column With Same Value in Excel 2010

June 15, 2023March 28, 2022 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Columns, Microsoft Excel 2010 How-To Guides, Microsoft Excel How-To Guides
disable the auto fill options button in excel 2010

How to Turn Off Autofill in Excel 2010

July 19, 2023March 22, 2022 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Microsoft Excel 2010 How-To Guides, Microsoft Excel How-To Guides, Utilities
click the custom header button

How to Add Same Header to All Sheets in Excel 2013

July 5, 2023March 17, 2022 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Header, Microsoft Excel 2013, Microsoft Excel How-To Guides, Workbooks, Worksheets
view the median formula

How to Calculate Median in Excel 2013

July 18, 2023March 16, 2022 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Formulas, Microsoft Excel 2013, Microsoft Excel How-To Guides
how to justify text in excel 2010

How to Justify Text in Excel 2010

June 24, 2023March 2, 2022 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Alignment, Microsoft Excel How-To Guides
smaller image of blank Excel worksheet

What is the Difference Between a Workbook and a Worksheet in Excel 2010?

July 28, 2023February 7, 2022 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Microsoft Excel 2010 How-To Guides, Microsoft Excel How-To Guides, Workbooks, Worksheets
see print layout in excel 2013

How to Use Print View – Excel 2013

June 29, 2023February 2, 2022 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Microsoft Excel 2013, Microsoft Excel How-To Guides, Views
add a border to text box in excel 2013

How to Add a Text Box Outline in Excel 2013

June 28, 2023February 1, 2022 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Borders, Microsoft Excel 2013, Microsoft Excel How-To Guides
right click and insert cut cells

How to Move a Row in Excel 2010

June 30, 2023January 5, 2022 by Matthew Burleigh

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

Read More

Categories Programs Tags Microsoft Excel 2010 How-To Guides, Microsoft Excel How-To Guides, Rows
how to disable automatic hyperlinks in excel 2010

How to Turn Off Auto Hyperlink in Excel 2010

June 30, 2023January 3, 2022 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Hyperlinks, Microsoft Excel How-To Guides
formula bar is displayed

How to Unhide Formula Bar in Excel 2010

July 27, 2023December 14, 2021 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Formulas, Microsoft Excel 2010 How-To Guides, Microsoft Excel How-To Guides
how to remove a vertical page break in excel 2013

How to Remove a Vertical Page Break in Excel 2013

June 2, 2023December 9, 2021 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Breaks, Microsoft Excel 2013, Microsoft Excel How-To Guides
click the delete background button

How to Remove an Excel 2010 Watermark

July 15, 2023December 1, 2021 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Background, Microsoft Excel 2010 How-To Guides, Microsoft Excel How-To Guides
trim a digit from a number in excel 2013

How to Remove Last Digit in Excel 2013

August 10, 2023November 30, 2021 by Matthew Burleigh

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 …

Read More

Categories Programs Tags Formulas, Microsoft Excel 2013, Microsoft Excel How-To Guides
Older posts
Newer posts
← Previous Page1 Page2 Page3 … 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