Skip to content
Solve Your Tech
Menu

Microsoft Excel 2013

How-to guides and tutorials about topics related to the Microsoft Excel 2013 application and ways that you can edit spreadsheets.

how to remove the first character from a cell in excel 2013

How to Remove First Character in Excel 2013 Cell

December 18, 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
disable autocomplete in excel 2013

How to Disable AutoComplete for Cell Values in Excel 2013

June 30, 2023January 26, 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 the column to repeat

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

August 2, 2023January 26, 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
how to double underline in Excel 2013

How to Double Underline in Excel 2013

August 2, 2023January 18, 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
how to count the number of characters in a cell in Excel 2013

How to Use the Character Count Excel 2013 Tool

August 4, 2023November 28, 2022 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 calculate percentage in excel 2013

How to Calculate Percentage in Excel

June 30, 2023November 25, 2022 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)

June 18, 2023November 25, 2022 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
insert a row in excel 2013

Inserting and Deleting Rows in Excel 2013

July 31, 2023November 23, 2022 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 remove all hyperlinks in Excel 2013

How to Break All Links in Excel 2013

June 23, 2023November 17, 2022 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
type the subtraction formula into the cell

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

June 29, 2023November 8, 2022 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

July 27, 2023November 6, 2022 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
how to combine three columns into one in Excel 2013

How to Combine Three Columns Into One in Excel

July 28, 2023October 28, 2022 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

June 19, 2023October 19, 2022 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

June 12, 2023October 19, 2022 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
how to wrap text for all cells in excel 2013 spreadsheet

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

July 21, 2023October 4, 2022 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

June 19, 2023September 30, 2022 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

June 19, 2023September 23, 2022 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
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
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
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 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
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 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
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
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
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 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 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
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
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
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
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
add a file name to the header in excel 2013

How to Add the Filename to the Header in Excel 2013

June 24, 2023November 17, 2021 by Matthew Burleigh

While you may already be familiar with specific formatting requirements that you need for school or work when working in Microsoft Word, it’s also possible …

Read More

Categories Programs Tags Header, Microsoft Excel 2013, Microsoft Excel How-To Guides
how to change the font of an entire worksheet in excel 2013

How to Change Font in Excel 2013 for a Whole Worksheet

August 2, 2023October 13, 2021 by Matthew Burleigh

When you are trying to change the appearance of text or data in Excel, then you need to select the cell that you wish to …

Read More

Categories Programs Tags Fonts, Microsoft Excel 2013, Microsoft Excel How-To Guides
how to create a new worksheet in excel 2013

How to Insert a New Worksheet in Excel 2013

July 20, 2023September 22, 2021 by Matthew Burleigh

Taking advantage of the ability to have multiple sheet tabs in Microsoft Excel is a great way to keep similar types of data organized. For …

Read More

Categories Programs Tags Microsoft Excel 2013, Microsoft Excel How-To Guides, Worksheets
get ris fo the text box border in excel 2013

How to Remove Text Box Border in Excel 2013

June 30, 2023September 17, 2021 by Matthew Burleigh

While much of the data that you add to a spreadsheet in Microsoft Excel will probably go inside the cells, you may find that you …

Read More

Categories Programs Tags Borders, Microsoft Excel 2013, Microsoft Excel How-To Guides
how to make a pie chart in excel 2013

How to Make a Pie Chart in Excel 2013

July 17, 2023September 8, 2021 by Matthew Burleigh

Placing your data into cells in Excel provides you with ways that you can compare and interact with your data. Typically this will involve various …

Read More

Categories Programs Tags Microsoft Excel 2013, Microsoft Excel How-To Guides, Ribbon
how to change the unit of measurement from inches to centimeters in excel 2013

How to Change Ruler from Inches to Centimeters in Excel 2013

June 30, 2023August 12, 2021 by Matthew Burleigh

Since Microsoft Excel spreadsheets often rely on the precision of data that is entered into cells, it’s helpful to be using the unit of measurement …

Read More

Categories Programs Tags Microsoft Excel 2013, Microsoft Excel How-To Guides, Rulers
how to move a column in excel 2013

How to Move a Column in Excel 2013

July 20, 2023July 9, 2021 by Matthew Burleigh

If you’ve ever re-typed a lot of data in an Excel spreadsheet, then it’s probably something that you don’t want to do again. So if …

Read More

Categories Programs Tags Columns, Microsoft Excel 2013, Microsoft Excel How-To Guides
add the cell borders that you want

How to Add Borders in Excel 2013

July 21, 2023June 1, 2021 by Matthew Burleigh

Excel spreadsheets show a pattern of lines on the screen that represent the perimeters of the cells. These are called gridlines, and they make it …

Read More

Categories Programs Tags Borders, Microsoft Excel 2013, Microsoft Excel How-To Guides
click the 4 on 1 option

How to Print More Than One Worksheet on a Page in Excel 2013

July 18, 2023April 10, 2021 by Matthew Burleigh

A Microsoft Excel workbook can frequently include a number of different tabs called worksheets. Each worksheet in your Excel file might include important information that …

Read More

Categories Programs Tags Microsoft Excel 2013, Microsoft Excel How-To Guides, Workbooks
how to print gridlines in excel 2013

How to Print Excel with Lines

June 8, 2023April 1, 2021 by Matthew Burleigh

A default spreadsheet in Microsoft Excel 2013 is going to display rows and columns of cells that are separated via a sequence of lines. These …

Read More

Categories Programs Tags Lines, Microsoft Excel 2013, Microsoft Excel How-To Guides
delete the password, then click the ok button

How to Remove a Password in Excel 2013

July 1, 2023March 25, 2021 by Matthew Burleigh

Sometimes when you are editing an Excel file, you are working with sensitive information. Since anyone with access to your computer or the Excel spreadsheet …

Read More

Categories Programs Tags Microsoft Excel 2013, Microsoft Excel How-To Guides, Passwords
Older posts
Page1 Page2 … Page5 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 2025
  • 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