Skip to content
Live2Tech
  • iPhone
  • Windows
    • Windows 11
    • Windows 10
  • Office
    • Word
    • Excel
    • Powerpoint
    • Outlook
  • Google
    • Google Docs
    • Google Sheets
    • Google Slides
    • Gmail
    • Chrome
    • Google Drive
  • Mac & Apple
    • Mac
    • iPad
    • Apple Watch
  • All Tutorials

excel 2013

How-to guides and tutorials to help you perform specific tasks and use the Microsoft Excel 2013 application.

Excel Format Cells dialog on the Font tab with the Strikethrough effect checked

How to Strikethrough in Excel (Shortcut, Partial Text and Auto Strikethrough)

November 15, 2026March 2, 2024 by Kermit Matthews

Select the cell and press Ctrl + 5, or use Ctrl + 1 > Font > Strikethrough. How to cross out part of a cell, add a button, and auto-strike done tasks. Continue Reading How to Strikethrough in Excel (Shortcut, Partial Text and Auto Strikethrough)

Categories Excel Tags excel 2013, Formatting
Spreadsheet Options Advanced Display section with Ruler units set to Centimeters

How to Change the Excel Ruler From Inches to Centimeters

November 10, 2026April 12, 2023 by Kermit Matthews

Switch Excel ruler units to centimeters in File > Options > Advanced > Display, and view the ruler in Page Layout view. Continue Reading How to Change the Excel Ruler From Inches to Centimeters

Categories Excel Tags excel 2013
how to copy as a picture in excel 2013

How to Copy as a Picture in Excel 2013

November 10, 2026January 23, 2023 by Kermit Matthews

When you have information in a spreadsheet that you want to use in a document or a slideshow, then you might just copy and paste… Continue Reading How to Copy as a Picture in Excel 2013

Categories Excel Tags excel 2013
how to change the first page number in excel 2013

How to Change the First Page Number in Excel 2013

November 10, 2026January 23, 2023 by Kermit Matthews

While many page numbering tasks will only involve one document, you might be combining your spreadsheet with something else for a project. This could mean… Continue Reading How to Change the First Page Number in Excel 2013

Categories Excel Tags excel 2013
how to hide the recent documents list in excel 2013

How to Stop Showing Recent Documents in Excel 2013

November 10, 2026January 23, 2023 by Kermit Matthews

Microsoft Excel will show you some of the files that you have been working on recently when you click the File tab at the top-left… Continue Reading How to Stop Showing Recent Documents in Excel 2013

Categories Excel Tags excel 2013
click the show formulas button

How to Hide Formulas in Excel 2013

November 10, 2026January 18, 2023 by Kermit Matthews

Looking at the formulas you type into a Microsoft Excel spreadsheet can help you troubleshoot issues that might arise if the formula isn’t working or… Continue Reading How to Hide Formulas in Excel 2013

Categories Excel Tags excel 2013
Spreadsheet View tab with the Formula Bar checkbox in the Show group highlighted and the formula bar showing a SUM formula

Where Is the Formula Bar in Excel? (Show, Hide, Expand)

November 10, 2026January 17, 2023 by Kermit Matthews

Find the formula bar in Excel, show or hide it from the View tab on Windows, Mac, and the web, expand it for long formulas, and fix a missing formula bar. Continue Reading Where Is the Formula Bar in Excel? (Show, Hide, Expand)

Categories Excel Tags excel 2013
Spreadsheet with a selected picture and the Insert Hyperlink dialog open with a web address entered and a ScreenTip button

How to Add a Hyperlink to a Picture in Excel

November 12, 2026January 16, 2023 by Kermit Matthews

Add a hyperlink to a picture in Excel with Ctrl+K: link to a web page, another sheet, a file or an email, add a ScreenTip, and edit or remove the link. Continue Reading How to Add a Hyperlink to a Picture in Excel

Categories Excel Tags excel 2013, Objects
Spreadsheet Page Setup dialog on the Sheet tab with Rows to repeat at top set to row 1 highlighted

How to Include a Title at the Top of Every Page in Excel 2013

November 10, 2026December 8, 2022 by Kermit Matthews

Print a title on every page in Excel 2013 with Print Titles and Rows to repeat at top, or add it to the header, plus fixes when Print Titles is grayed out. Continue Reading How to Include a Title at the Top of Every Page in Excel 2013

Categories Excel Tags excel 2013, Featured Excel Guides
Spreadsheet with rows 4 to 6 selected and the right-click menu showing Hide

How to Hide Rows and Columns in Excel 2013

November 10, 2026December 8, 2022 by Kermit Matthews

Hide rows and columns in Excel 2013 with right-click, the Format menu, or Ctrl + 9 and Ctrl + 0, unhide them again, and hide individual cell contents. Continue Reading How to Hide Rows and Columns in Excel 2013

Categories Excel Tags excel 2013, Featured Excel Guides
Spreadsheet Page Layout tab with the Breaks menu open and Reset All Page Breaks highlighted

How to Remove All Page Breaks in Excel 2013 (and Newer)

November 10, 2026December 8, 2022 by Kermit Matthews

Remove all page breaks in Excel with Reset All Page Breaks, delete single breaks in Page Break Preview, hide dotted lines, and control breaks with scaling. Continue Reading How to Remove All Page Breaks in Excel 2013 (and Newer)

Categories Excel Tags excel 2013, Featured Excel Guides
Excel 2013 Print screen with settings for print area, orientation, margins, and scaling highlighted, plus Page Setup link

The Complete Guide to Printing in Excel 2013

November 10, 2026November 9, 2022 by Kermit Matthews

Print Excel 2013 sheets cleanly: set a print area, use landscape and narrow margins, scale to fit, repeat headers, and preview. Checklist and fixes. Continue Reading The Complete Guide to Printing in Excel 2013

Categories Excel Tags excel 2013
Spreadsheet Home tab with the Fill Color palette open and a range of cells shaded yellow

How to Fill a Cell With Color in Excel 2013

November 10, 2026November 9, 2022 by Kermit Matthews

Fill cells with color in Excel 2013 using the Fill Color button, Format Cells, or conditional formatting, and remove shading with No Fill. Continue Reading How to Fill a Cell With Color in Excel 2013

Categories Excel Tags excel 2013
Spreadsheet print screen with the settings menu open and Print Selection highlighted, and a preview showing only the selected cells

How to Print Part of a Spreadsheet in Excel

November 10, 2026June 13, 2022 by Kermit Matthews

Print only part of an Excel spreadsheet with Print Selection or a saved print area, print separate ranges, and fit the selection on one page. Continue Reading How to Print Part of a Spreadsheet in Excel

Categories Excel Tags excel 2013
Format Cells dialog with Custom selected and a 12-digit zero format in the Type box

How to Format UPC Codes in Excel

November 10, 2026February 24, 2022 by Kermit Matthews

Keep UPC codes at 12 digits in Excel with a custom format of twelve zeros. Stops lost leading zeros and scientific notation. Continue Reading How to Format UPC Codes in Excel

Categories Excel Tags excel, excel 2013
hold down ctrl and select multiple cells

How to Select Cells in Excel 2013

November 15, 2026January 26, 2022 by Kermit Matthews

Making cell selections in spreadsheet applications like Google Sheets or Microsoft Excel can be as easy as clicking on the cell you want. Maybe if… Continue Reading How to Select Cells in Excel 2013

Categories Excel Tags excel 2013
Excel Page Layout tab with the Print Area menu open and Set Print Area highlighted

How to Set the Print Area in Excel 2013

November 10, 2026December 28, 2021 by Kermit Matthews

Set the print area in Excel 2013 from Page Layout > Print Area, add to it, print multiple areas, fit it on one page, and clear it. Continue Reading How to Set the Print Area in Excel 2013

Categories Excel Tags excel 2013
Spreadsheet app with a picture selected, the Picture Format tab open and the Crop menu showing Crop to Shape and Aspect Ratio options

How to Crop a Picture in Excel (Shapes, Ratios and More)

November 10, 2026December 2, 2021 by Kermit Matthews

Crop a picture in Excel with the Picture Format tab: trim edges, crop to a circle or aspect ratio, reset a crop and delete cropped areas. Continue Reading How to Crop a Picture in Excel (Shapes, Ratios and More)

Categories Excel Tags Cropping, excel 2013, Pictures
how to switch to a4 paper in excel 2013

How to Print Excel Sheet in A4 Size in Excel 2013

November 15, 2026October 21, 2021 by Kermit Matthews

The print settings for an Excel spreadsheet are frequently an afterthought for Excel users, as the focus is on ensuring that the data in the… Continue Reading How to Print Excel Sheet in A4 Size in Excel 2013

Categories Excel Tags excel 2013
Spreadsheet ribbon on the Page Layout tab with the Sheet Options Headings Print checkbox highlighted

How to Print Without Column Letters and Row Numbers in Excel

November 13, 2026April 21, 2021 by Kermit Matthews

Print Excel sheets without column letters and row numbers by unchecking Headings > Print in Page Layout. Works in Excel 2013 through Microsoft 365. Continue Reading How to Print Without Column Letters and Row Numbers in Excel

Categories Excel Tags excel 2013
how to add a signature line in excel 2103

How to Add a Signature Line in Excel

November 9, 2026November 27, 2018 by Kermit Matthews

Timesheets, expense forms and approval sheets often start life in Excel, and sooner or later someone has to sign one. In Excel for Windows, go… Continue Reading How to Add a Signature Line in Excel

Categories Excel Tags excel 2013, Lines
Home tab with the Increase Decimal button highlighted

Why Is Excel Only Showing Two Decimal Places?

November 14, 2026September 24, 2018 by Kermit Matthews

Excel shows two decimals because of the cell format, not the stored value. Use Increase Decimal or Format Cells to show more digits. Continue Reading Why Is Excel Only Showing Two Decimal Places?

Categories Excel Tags excel 2013
how to change the page order in excel 2013

How to Change Page Order in Excel

November 10, 2026December 8, 2017 by Kermit Matthews

You print a wide sheet, pick up the stack, and the pages make no sense: every page of the left-hand columns comes first, and the… Continue Reading How to Change Page Order in Excel

Categories Excel Tags excel 2013
how to print headings in excel 2013

How to Print Row and Column Headings in Excel

November 13, 2026October 18, 2017 by Kermit Matthews

A printed spreadsheet full of numbers is hard to discuss when nobody can say “look at cell D14,” because the column letters and row numbers… Continue Reading How to Print Row and Column Headings in Excel

Categories Excel Tags excel 2013
how to hide a ribbon tab in excel 2013

How to Hide a Ribbon Tab in Excel

November 8, 2026September 20, 2017 by Kermit Matthews

Draw, Developer, Help and a row of add-in tabs can crowd Excel’s ribbon until the tabs you actually use are hard to find. You can… Continue Reading How to Hide a Ribbon Tab in Excel

Categories Excel Tags excel 2013
how to change default number of sheets in excel 2013

How to Change the Default Number of Sheets in Excel

November 8, 2026September 1, 2017 by Kermit Matthews

If every new workbook starts with one sheet and you immediately add two more so each month of a quarter has its own sheet, Excel… Continue Reading How to Change the Default Number of Sheets in Excel

Categories Excel Tags excel 2013
how to unhide a worksheet in excel 2013

How to Unhide a Worksheet Tab in Excel

November 9, 2026July 24, 2017 by Kermit Matthews

A worksheet tab that was there yesterday is gone, but the formulas that use it still work. The sheet is most likely hidden, not deleted.… Continue Reading How to Unhide a Worksheet Tab in Excel

Categories Excel Tags excel 2013
how to set the default browser for excel 2013 links

How to Set the Default Browser for Excel Links

November 16, 2026July 10, 2017 by Kermit Matthews

You click a link in a spreadsheet and it opens in a browser you never use. Excel has no browser setting of its own: it… Continue Reading How to Set the Default Browser for Excel Links

Categories Excel Tags excel 2013
Spreadsheet Fill Effects dialog with Two colors selected, Color 1 and Color 2 set, Horizontal shading style and a variant highlighted, with a sample preview

How to Use a Gradient Fill Effect in Excel 2013

November 10, 2026June 19, 2017 by Kermit Matthews

Add a gradient fill in Excel 2013: select cells, press Ctrl + 1, go to Fill > Fill Effects, pick two colors and a style. Plus shapes and charts. Continue Reading How to Use a Gradient Fill Effect in Excel 2013

Categories Excel Tags excel 2013
how to elongate a cell in excel 2013

How to Make a Cell Longer in Excel

November 9, 2026June 14, 2017 by Kermit Matthews

A cell in Excel can grow in two directions: wider, by changing the column width, or taller, by changing the row height. Either way, Excel… Continue Reading How to Make a Cell Longer in Excel

Categories Excel Tags excel 2013
Format Cells dialog on the Alignment tab with Shrink to fit checked under Text control

How to Shrink Text to Fit Inside a Cell in Excel

November 10, 2026June 12, 2017 by Kermit Matthews

Shrink text to fit inside a cell in Excel with Format Cells > Alignment > Shrink to fit, and learn when to use Wrap text or AutoFit instead. Continue Reading How to Shrink Text to Fit Inside a Cell in Excel

Categories Excel Tags excel 2013
how to add a comment in excel 2013

How to Add a Comment in Excel

November 10, 2026June 8, 2017 by Kermit Matthews

What Excel 2013 called a comment is now called a note, and a comment in current Excel is a threaded conversation that other people can… Continue Reading How to Add a Comment in Excel

Categories Excel Tags excel 2013
Spreadsheet Options dialog on Customize Ribbon with the Developer tab checked under Main Tabs and the OK button highlighted

How to Show the Developer Tab in Excel (2013 and Later)

November 15, 2026June 6, 2017 by Kermit Matthews

Show the Developer tab in Excel 2013, 2016, 2019, 2021, and Microsoft 365 on Windows or Mac, and learn what its macro, VBA, and control tools do. Continue Reading How to Show the Developer Tab in Excel (2013 and Later)

Categories Excel Tags excel 2013
Excel Page Layout tab with the Delete Background button highlighted and a faint watermark in the header

How to Remove a Watermark From a Spreadsheet in Excel 2013

November 12, 2026May 30, 2017 by Kermit Matthews

Most Excel watermarks are header pictures: open Page Layout view and delete &[Picture]. For backgrounds, click Page Layout > Delete Background. All methods. Continue Reading How to Remove a Watermark From a Spreadsheet in Excel 2013

Categories Excel Tags excel 2013
Spreadsheet Paste Special dialog with the Transpose checkbox selected to paste a vertical column as a horizontal row

How to Paste Vertical Data Horizontally in Excel (Transpose)

November 10, 2026May 18, 2017 by Kermit Matthews

Paste vertical data horizontally in Excel, or the reverse, with Paste Special Transpose, the Ctrl+Alt+V shortcut, or the TRANSPOSE function. Continue Reading How to Paste Vertical Data Horizontally in Excel (Transpose)

Categories Excel Tags excel 2013, Rows
how to hide gridlines in excel 2013

How to Hide Gridlines in Excel

November 13, 2026May 4, 2017 by Kermit Matthews

To hide gridlines in Excel, open the View tab and clear the Gridlines check box in the Show group. The faint gray lines vanish at… Continue Reading How to Hide Gridlines in Excel

Categories Excel Tags excel 2013
Spreadsheet Options Advanced page with Show sheet tabs checked under Display options for this workbook

How to Show Sheet Tabs in Excel: 6 Fixes When Tabs Are Missing

November 10, 2026May 1, 2017 by Kermit Matthews

Excel sheet tabs missing? Turn on Show sheet tabs in Options, move the scroll bar, maximize the window, or unhide hidden sheets. Steps for Windows, Mac, web. Continue Reading How to Show Sheet Tabs in Excel: 6 Fixes When Tabs Are Missing

Categories Excel Tags excel 2013
Word processor with the Reviewing Pane open on the left listing each comment with the reviewer name and text, and the Reviewing Pane button on the Review tab highlighted

How to Set Excel Column Width in Inches

November 10, 2026February 24, 2017 by Kermit Matthews

Set Excel column width and row height in inches using Page Layout view, change ruler units, and learn how Excel character widths convert. Continue Reading How to Set Excel Column Width in Inches

Categories Excel Tags excel 2013
Spreadsheet with the SQRT formula in the formula bar and a column of numbers with their square roots, plus a power formula alternative

How to Find the Square Root in Excel

November 10, 2026February 7, 2017 by Kermit Matthews

Find square roots in Excel with =SQRT(A2) or =A2^(1/2), calculate cube and nth roots, handle negative numbers and show the square root symbol. Continue Reading How to Find the Square Root in Excel

Categories Excel Tags excel 2013, Formulas
Spreadsheet View tab with the Freeze Panes menu open and Freeze Top Row highlighted

How to Freeze the Top Row in Excel

November 10, 2026January 6, 2017 by Kermit Matthews

Keep the top row visible in Excel with Freeze Top Row, freeze multiple rows or columns, unfreeze panes, and fix Freeze Panes when it’s grayed out. Continue Reading How to Freeze the Top Row in Excel

Categories Excel Tags excel 2013, Rows
Excel Format Cells dialog on the Number tab with the Text category highlighted

How to Stop Excel from Changing Numbers to Dates

November 14, 2026December 21, 2016 by Kermit Matthews

Stop Excel from changing numbers to dates by formatting cells as Text, typing an apostrophe, entering fractions correctly, or importing CSVs as text. Continue Reading How to Stop Excel from Changing Numbers to Dates

Categories Excel Tags excel 2013
why do columns have number labels instead of letters in Excel 2013

Why Does Excel Show Column Numbers Instead of Letters?

November 15, 2026December 14, 2016 by Kermit Matthews

You open a spreadsheet and the column headings read 1, 2, 3 instead of A, B, C, and a simple formula in the formula bar… Continue Reading Why Does Excel Show Column Numbers Instead of Letters?

Categories Excel Tags excel 2013
how to show a dollar symbol to the left of a number in excel 2013

How to Show a Dollar Sign Next to Numbers in Excel

November 14, 2026October 7, 2016 by Kermit Matthews

When people ask how to show a dollar sign in Excel, they usually mean one of two looks. Either the $ sits right against the… Continue Reading How to Show a Dollar Sign Next to Numbers in Excel

Categories Excel Tags excel 2013
switch to numerical formatting - step 4

How to Apply Number Formatting to a Cell in Excel 2013

November 14, 2026July 14, 2016 by Kermit Matthews

Excel 2013 can do a very good job of automatically detecting the type of information that you have entered into a cell. Unfortunately it does not… Continue Reading How to Apply Number Formatting to a Cell in Excel 2013

Categories Excel Tags excel 2013
hide a worksheet in excel 2013

How to Hide a Worksheet in Excel

November 9, 2026June 16, 2016 by Kermit Matthews

A lookup table, a list of rates or a sheet full of helper formulas often needs to stay in the workbook without cluttering the view.… Continue Reading How to Hide a Worksheet in Excel

Categories Excel Tags excel 2013
center across multiple cells in excel 2013

How to Center Text Across Multiple Cells in Excel

November 10, 2026December 8, 2015 by Kermit Matthews

You want a report title centered over the columns of a table, but you do not want merged cells getting in the way of sorting,… Continue Reading How to Center Text Across Multiple Cells in Excel

Categories Excel Tags excel 2013
how to unhide headings in excel 2013

How to Show Row Numbers and Column Letters in Excel

November 13, 2026December 7, 2015 by Kermit Matthews

The sheet opens, and the A, B, C labels across the top and the 1, 2, 3 labels down the side are gone. In current… Continue Reading How to Show Row Numbers and Column Letters in Excel

Categories Excel Tags excel 2013
clear the print area in excel 2013

How to Clear a Print Area in Excel

November 9, 2026November 30, 2015 by Kermit Matthews

If Excel keeps printing the same small block of cells and ignores the rest of the sheet, the worksheet most likely has a saved print… Continue Reading How to Clear a Print Area in Excel

Categories Excel Tags excel 2013
Spreadsheet Formulas tab Calculation Options menu with Manual selected

How to Switch to Manual Calculation in Excel

November 10, 2026November 12, 2015 by Kermit Matthews

Set Excel to manual calculation in Formulas > Calculation Options, recalculate with F9, and switch back to automatic. Continue Reading How to Switch to Manual Calculation in Excel

Categories Excel Tags excel 2013
remove the hyperlinks in excel 2013

How to Remove All Hyperlinks in Excel

November 9, 2026October 28, 2015 by Kermit Matthews

To remove every hyperlink on a sheet in Excel, press Ctrl+A to select all cells, right-click any selected cell, and choose Remove Hyperlinks. The words… Continue Reading How to Remove All Hyperlinks in Excel

Categories Excel Tags excel 2013

Join Our Free Newsletter

Featured guides and deals

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

Live2Tech

Plain-English, step-by-step guides for the devices and apps you use every day.

Apple

  • iPhone
  • iPad
  • Mac
  • Apple Watch

Windows

  • Windows 11
  • Windows 10

Microsoft Office

  • Word
  • Excel
  • Powerpoint
  • Outlook

Google

  • Google Docs
  • Google Sheets
  • Google Slides
  • Gmail
  • Chrome
  • Google Drive
  • About Us
  • Contact
  • Disclaimer
  • Privacy Policy
© Live2Tech.com 2026
  • iPhone
  • Windows
    • Windows 11
    • Windows 10
  • Office
    • Word
    • Excel
    • Powerpoint
    • Outlook
  • Google
    • Google Docs
    • Google Sheets
    • Google Slides
    • Gmail
    • Chrome
    • Google Drive
  • Mac & Apple
    • Mac
    • iPad
    • Apple Watch
  • All Tutorials