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

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

Excel Options Advanced page with the Zoom on roll with IntelliMouse checkbox cleared and highlighted

How to Stop Excel From Zooming When You Scroll the Mouse Wheel

November 10, 2026April 8, 2022 by Kermit Matthews

Stop Excel zooming on scroll: File > Options > Advanced, uncheck Zoom on roll with IntelliMouse. Plus fixes for a stuck Ctrl key and touchpad zoom. Continue Reading How to Stop Excel From Zooming When You Scroll the Mouse Wheel

Categories Excel
Excel 2010 Print screen with the scaling option set to Fit Sheet on One Page and the preview showing the whole sheet on one page

How to Make an Excel 2010 Spreadsheet Fit on One Page

November 12, 2026March 14, 2022 by Kermit Matthews

Make an Excel 2010 sheet fit on one page: File > Print > Fit Sheet on One Page, or set Scale to Fit to 1 page wide by 1 tall. Plus readability tips. Continue Reading How to Make an Excel 2010 Spreadsheet Fit on One Page

Categories Excel
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 with column B selected and Copy highlighted in the right-click menu

How to Copy a Column in Excel (6 Methods)

November 10, 2026December 27, 2021 by Kermit Matthews

Copy a column in Excel with copy and paste, Insert Copied Cells, Ctrl + drag, or Paste Special, and learn how formulas change when you copy them. Continue Reading How to Copy a Column in Excel (6 Methods)

Categories Excel Tags Featured Excel Guides
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 rename a tab in excel 2016

How to Change a Tab Name in Excel 2016

November 15, 2026November 5, 2021 by Kermit Matthews

When you first start working with Microsoft Excel and are familiarizing yourself with some basic formulas, you may not give much thought to the names… Continue Reading How to Change a Tab Name in Excel 2016

Categories Excel Tags excel 2016
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 unhide columns in Excel 2016

How to Unhide Columns in Excel 2016

November 15, 2026February 25, 2021 by Kermit Matthews

Hiding columns is a great tool in Microsoft Excel when you have data that you can’t delete, but don’t want to leave visible. But you… Continue Reading How to Unhide Columns in Excel 2016

Categories Excel
Spreadsheet with a commented cell right-clicked and Delete Comment highlighted

How to Delete a Comment in Excel for Microsoft 365 (One or All)

November 10, 2026September 9, 2020 by Kermit Matthews

Delete a comment in Excel for Microsoft 365 with the right-click menu or Review tab, delete all comments at once, and remove notes too. Continue Reading How to Delete a Comment in Excel for Microsoft 365 (One or All)

Categories Excel
how to format all cells in a column in Excel

How to Switch the Format for a Whole Column in Excel for Office 365

November 10, 2026August 17, 2020 by Kermit Matthews

Microsoft Excel gives you the option to specify the formatting for your cells. This is helpful if you are entering percentages, or currency, as anything… Continue Reading How to Switch the Format for a Whole Column in Excel for Office 365

Categories Excel
Spreadsheet with the Data tab Group button highlighted and three selected rows grouped with an outline bar and collapse button in the left margin

How to Group Rows in Excel for Microsoft 365 (Collapse and Expand)

November 10, 2026March 4, 2020 by Kermit Matthews

Group rows in Excel for Microsoft 365 to collapse and expand sections, with shortcuts, nested levels, Auto Outline, Subtotal, and how to ungroup. Continue Reading How to Group Rows in Excel for Microsoft 365 (Collapse and Expand)

Categories Excel Tags Rows
Formulas tab with Watch Window highlighted and a watch list showing cells and values

How to Open the Watch Window in Excel

November 10, 2026August 28, 2019 by Kermit Matthews

Open the Watch Window in Excel from Formulas > Watch Window, then Add Watch to track cell values and formulas while you work on other sheets. Continue Reading How to Open the Watch Window in Excel

Categories Excel
how to stop a picture from printing in Microsoft Excel

How to Stop a Picture from Printing in Excel for Office 365

November 10, 2026August 21, 2019 by Kermit Matthews

Here’s how to change the settings for a picture in Microsoft Excel so that the picture doesn’t print. We will give a brief overview of… Continue Reading How to Stop a Picture from Printing in Excel for Office 365

Categories Excel
Excel Home tab with the AutoSum button highlighted and a SUM formula totaling a column of amounts, plus the Sum shown in the status bar

How to Sum a Column in Excel

November 10, 2026August 14, 2019 by Kermit Matthews

Sum a column in Excel with AutoSum (Alt + =), the SUM function, the status bar, or a table total row, and fix totals that show 0 or the wrong number. Continue Reading How to Sum a Column in Excel

Categories Excel Tags Columns
Excel worksheet with the formula =A2^B2 in the formula bar and the result highlighted in column C

How to Make an Exponent in Excel

November 10, 2026May 31, 2019 by Kermit Matthews

Use the caret, like =5^3, or =POWER(5,3). How to use cell references, negative and fractional exponents, and show exponents as superscript. Continue Reading How to Make an Exponent in Excel

Categories Excel
how set width height image excel 4 How to Set Picture Height and Width in Inches in Excel

How to Set Picture Height and Width in Inches in Excel

November 8, 2026January 10, 2019 by Kermit Matthews

When an image has to come out at an exact printed size, such as a 2-inch logo on an invoice or a 1.5-inch product photo… Continue Reading How to Set Picture Height and Width in Inches in Excel

Categories Excel
how to wrap text in excel 2013

How to Wrap Text in Excel

November 9, 2026November 28, 2018 by Kermit Matthews

You type a long product description or note into a cell, and Excel either spills it across the empty cells to the right or chops… Continue Reading How to Wrap Text in Excel

Categories Excel Tags Text Formatting
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 rename a spreadsheet in excel online

How to Change the Name of a Document in Excel Online

November 10, 2026July 23, 2018 by Kermit Matthews

When you create a new spreadsheet in Microsoft Excel Online, the name of the spreadsheet is going to be something generic like “Book1,” If you… Continue Reading How to Change the Name of a Document in Excel Online

Categories Excel
Excel for the web Home tab with the Number Format dropdown open and Currency highlighted

How to Apply Currency Formatting in Excel Online

November 14, 2026July 19, 2018 by Kermit Matthews

Apply currency formatting in Excel Online: select cells, then Home > Number Format > Currency or Accounting. Plus changing symbols and decimals. Continue Reading How to Apply Currency Formatting in Excel Online

Categories Excel
how to change cell format in excel online

How to Change the Format of a Cell in Excel Online

November 10, 2026July 17, 2018 by Kermit Matthews

One of the best parts about using Excel online is how many of the program’s features are available in that version. You can perform most… Continue Reading How to Change the Format of a Cell in Excel Online

Categories Excel Tags excel online
Spreadsheet with the Formulas tab open, Show Formulas turned on, and cells displaying their formulas instead of results

How to Print Formulas in Excel Instead of Their Results

November 10, 2026May 11, 2018 by Kermit Matthews

Print formulas in Excel by turning on Show Formulas (Ctrl + `), printing headings and gridlines, or using FORMULATEXT to print formulas beside results. Continue Reading How to Print Formulas in Excel Instead of Their Results

Categories Excel
how to insert a column in excel 2013

How to Insert a Column in Excel

November 9, 2026May 10, 2018 by Kermit Matthews

You build a tidy sales table, then notice a gap: there is no column for a new month, or for the category you forgot. The… Continue Reading How to Insert a Column in Excel

Categories Excel
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 change the color scheme in excel 2010

How to Change the Color Scheme in Excel

November 10, 2026August 16, 2017 by Kermit Matthews

If Excel’s bright white window is tiring your eyes by mid-afternoon, or you want it to look different, the setting you need is the Office… Continue Reading How to Change the Color Scheme in Excel

Categories Excel Tags excel 2010
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
Spreadsheet Format Picture pane on the Size and Properties tab with Move and size with cells selected and a picture sitting inside a cell

How to Lock an Image to a Cell in Excel

November 12, 2026March 10, 2017 by Kermit Matthews

Lock a picture to a cell in Excel with Move and size with cells or Place in Cell, and protect the sheet so images can’t be moved or deleted. Continue Reading How to Lock an Image to a Cell in Excel

Categories Excel Tags excel 2010
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 app with the plus New sheet button next to the sheet tabs and the Insert Sheet command on the Home tab

How to Insert a New Worksheet in Excel (4 Ways)

November 10, 2026January 18, 2017 by Kermit Matthews

Insert a new worksheet in Excel with the + button, Shift + F11, Home > Insert > Insert Sheet, or a right-click, and add several sheets at once. Continue Reading How to Insert a New Worksheet in Excel (4 Ways)

Categories Excel Tags excel 2010
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
Older posts
Newer posts
← Previous Page1 Page2 Page3 Next →

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