Skip to content
Live2Tech
Menu

Excel

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

how to display a formula result in a text box in excel 2013

How to Display Cell Formulas in Excel 2013 Text Boxes

May 4, 2023January 18, 2023 by Kermit Matthews

It might seem strange to include a text box in a Microsoft Excel spreadsheet, but the versatility that you get with text box positioning can …

Read More

Categories Excel Tags excel 2013
how to hide the horizontal scroll bar in excel 2013

How to Hide Scroll Bar Excel 2013 Guide

May 8, 2023January 18, 2023 by Kermit Matthews

The scroll bars in Microsoft Excel can be pretty important when you’re working with a lagrwe spreadsheet and you keep needing to go to cells …

Read More

Categories Excel Tags excel 2013
show the formula bar in excel 2013

Where is the Formula Bar in Excel 2013?

May 7, 2023January 17, 2023 by Kermit Matthews

When you are adding a formula to one of the cells in your Microsoft Excel spreadsheet, the full formula might be too large to see …

Read More

Categories Excel Tags excel 2013
how to hyperlink a picture in excel 2013

How to Add a Hyperlink to a Picture in an Excel 2013 Spreadsheet

April 29, 2023January 16, 2023 by Kermit Matthews

You may already be familiar with the use of hyperlinks in Microsoft Word documents or on Web pages that you view in a browser like …

Read More

Categories Excel Tags excel 2013, Objects
how to make all letters capital in Excel

How to Make All Letters Capital in Excel 2013

May 4, 2023December 14, 2022 by Kermit Matthews

While many situations might call for proper capitalization in a document, there is a benefit to knowing how to change the case of some of …

Read More

Categories Excel Tags excel 2013, Featured Excel Guides
delete a text box in excel 2013

How to Delete a Text Box in Excel 2013

May 14, 2023December 8, 2022 by Kermit Matthews

The cell structure in an Excel spreadsheet is pretty rigid, so you don’t have a lot of options when you need to display text in …

Read More

Categories Excel Tags excel, excel 2013
how to remove fill color from text box in word 2013

How to Remove Fill Color in Excel Text Box in Microsoft Excel 2013

April 29, 2023December 8, 2022 by Kermit Matthews

Once you start using color to format your spreadsheet cells, you may start to use it whenever the chance arises. But you may find that …

Read More

Categories Excel, Word Tags Featured Excel Guides, word 2013
how to add a header in excel 2013

How to Add a Title in Excel 2013

May 20, 2023December 8, 2022 by Kermit Matthews

When you are sharing a spreadsheet with another person, it’s useful to both parties to be able to give that document a name. Naming the …

Read More

Categories Excel Tags excel 2013, Featured Excel Guides
how to hide a row or column in excel 2013

How to Hide Cells in Excel 2013

May 18, 2023December 8, 2022 by Kermit Matthews

Deleting data that you don’t need anymore is beneficial in excel, but it might be more than you need in certain situations. There are times …

Read More

Categories Excel Tags excel 2013, Featured Excel Guides
how save excel chart as image 4 How to Save an Excel Chart as an Image in Excel 2016

How to Save an Excel Chart as an Image in Excel 2016

May 6, 2023December 8, 2022 by Kermit Matthews

You can easily turn a dataset into a chart or graph in Microsoft Excel. These charts and graphs offer great ways to visualize data that …

Read More

Categories Excel Tags Featured Excel Guides
how to print the top row on every page in excel 2016

How to Set Row 1 to Print on Every Page – Excel 2016

May 13, 2023December 8, 2022 by Kermit Matthews

The top row of a spreadsheet provides a very useful way to identify the data in the cells in the rest of the worksheet. While …

Read More

Categories Excel Tags excel 2016, Featured Excel Guides
how to remove all page breaks in excel 2013

How to Remove Page Breaks in Excel 2013

May 3, 2023December 8, 2022 by Kermit Matthews

Until you start trying to customize the appearance of a printed spreadsheet in Excel you may not know how difficult it can be to fix …

Read More

Categories Excel Tags excel 2013, Featured Excel Guides
how to center horizontally vertically excel 2010 4 How to Center Worksheet Horizontally in Excel (and Vertically, Too)

How to Center Worksheet Horizontally in Excel (and Vertically, Too)

May 14, 2023December 8, 2022 by Kermit Matthews

When you don’t adjust the print settings for a spreadsheet in Excel, it’s going to align to the left side of the printed page. This …

Read More

Categories Excel Tags excel 2010, Featured Excel Guides
how to repeat a row at the top in excel 2013

The Complete Guide to Optimizing a Page for Printing in Excel 2013

May 10, 2023November 9, 2022 by Kermit Matthews

I have worked for several businesses and, while they all had significant differences, one thing that they had in common was a heavy reliance on …

Read More

Categories Excel, Featured Tags excel 2013
how to fill a cell with color in excel 2013

How Do You Fill a Cell With Color in Excel 2013?

April 26, 2023November 9, 2022 by Kermit Matthews

Microsoft Excel has a lot of formatting options that you can use to make your data stand out, or easier to read. Some of these …

Read More

Categories Excel Tags excel 2013
how to disable live preview in excel 2013

How to Disable Excel Live Preview

April 25, 2023June 13, 2022 by Kermit Matthews

Newer versions of applications often come with features that are meant to make things easier for users. Microsoft Excel is one such program, and the …

Read More

Categories Excel Tags excel 2013
why is only part of spreadsheet printing in excel 2013

Why Is Excel Cutting Off Text When Printing My Spreadsheet?

April 28, 2023June 13, 2022 by Kermit Matthews

It can be a lot of work to get your Excel spreadsheet finalized, and the data looking good, in a presentable format. You may have …

Read More

Categories Excel Tags excel 2013
click bottom-right corner, then drag down

Fill Cells With Consecutive Numbers in Excel 2013 Automatically and Quickly

May 9, 2023May 17, 2022 by Kermit Matthews

Have you ever manually typed a sequence of numbers into a spreadsheet? Whether you only needed to enter a handful of them or you were …

Read More

Categories Excel Tags excel 2013
how to stop Excel from zooming when you scroll your mouse wheel

How to Stop Excel from Zooming When I Scroll My Mouse Wheel

March 15, 2024April 8, 2022 by Kermit Matthews

The steps in this guide will show you how to turn off a setting that is causing Excel to zoom in or zoom out whenever …

Read More

Categories Excel
remove dollar sign formatting excel 2013

How to Format Money Without the Dollar Sign in Excel 2013

May 11, 2023March 29, 2022 by Kermit Matthews

Using the correct formatting option when you are working with data in an Excel spreadsheet can make it much easier for both you and your …

Read More

Categories Excel Tags excel 2013
stop printing gridlines in excel 2013

How to Print Excel Without Lines in Microsoft Office 2013

April 24, 2023March 28, 2022 by Kermit Matthews

Microsoft Excel spreadsheets, unlike ones that you create in Google Sheets, will not print gridlines or cell borders by default. Sometimes this is helpful, but …

Read More

Categories Excel Tags excel 2013
how to print excel 2010 spreadsheet on one page

How to Use the Excel 2010 Fit to Page Option

October 19, 2023March 14, 2022 by Kermit Matthews

Printers and printing can be frustrating, so it would be great if everyone would view spreadsheets, grids, and other similar types of documents on their …

Read More

Categories Excel
select number, then change decimal places to zero

How to Format UPC Codes in Excel

April 26, 2023February 24, 2022 by Kermit Matthews

Microsoft Excel provides a large variety of options that can help you to properly format your data. If you have ever worked with currency cells …

Read More

Categories Excel Tags excel, excel 2013
how to remove underline from link in excel 2013

How to Remove Underline in Excel 2013 Hyperlinks

May 6, 2023February 4, 2022 by Kermit Matthews

When you create a hyperlink in a Microsoft Office application like Microsoft Excel, you will typically change the linked text in ways other than making …

Read More

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

How to Select Cells in Excel 2013

May 5, 2023January 26, 2022 by Kermit Matthews

Making cell selections in spreadsheet applications like Google Sheets or Microsoft Excel can be as easy as simply clicking on the cell you want. Maybe …

Read More

Categories Excel Tags excel 2013
select the new fill color

How to Change the Excel Cell Shading Color in Excel 2010

April 29, 2023January 13, 2022 by Kermit Matthews

Applying a formatting change to unformatted data in Microsoft Excel can be pretty straightforward. You simply select whatever text, number, or object you want to …

Read More

Categories Excel Tags excel, excel 2010, fill color
how to change the default font in excel 2013

How to Change the Default Font in Excel 2013

April 30, 2023January 6, 2022 by Kermit Matthews

Fonts can be something that you focus on a lot when you are creating a document in Google Docs or Microsoft Word, but it may …

Read More

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

How to Set the Print Area – Excel 2013

April 24, 2023December 28, 2021 by Kermit Matthews

Working with a big spreadsheet in Google Sheets or Microsoft Excel can be difficult, and that difficulty is often amplified when the file needs to …

Read More

Categories Excel Tags excel 2013
how copy column excel 2 How to Copy a Column in Excel for Office 365

How to Copy a Column in Excel for Office 365

April 22, 2023December 27, 2021 by Kermit Matthews

Many of the popular productivity apps that use every day, like Google Sheets and Google Docs, as well as Microsoft Word and Microsoft Excel, will …

Read More

Categories Excel Tags Featured Excel Guides
how to crop a picture in excel 2013

How to Crop Image in Excel 2013

May 10, 2023December 2, 2021 by Kermit Matthews

Microsoft Excel not only allows you to add images to your spreadsheets, but it provides a handy set of tools that you can use to …

Read More

Categories Excel Tags Cropping, excel 2013, Pictures
how to remove strikethrough in excel 2013

How to Remove Strikethrough in Excel 2013

April 23, 2023November 23, 2021 by Kermit Matthews

If you have ever opened the Format Cells window in Microsoft Excel and explored the sections in there then you might have discovered a Font …

Read More

Categories Excel Tags excel 2013, Featured Excel Guides
how to enable macros in excel 2013

How to Enable Macros in Excel 2013

April 25, 2023November 11, 2021 by Kermit Matthews

Macros in Microsoft Excel give you a way to automate tasks that could be time-consuming if performed manually. But macros can potentially be dangerous if …

Read More

Categories Excel Tags excel 2013
how to rename a tab in excel 2016

How to Change a Tab Name in Excel 2016

May 10, 2023November 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 …

Read More

Categories Excel Tags excel 2016
click the row number to repeat

How to Print First Row on Every Page – Excel 2010

May 2, 2023October 22, 2021 by Kermit Matthews

While there are a number of techniques that you can use to organize large amounts of data, such as giving a sheet tab a more …

Read More

Categories Excel, Microsoft Tags excel, excel 2010, printing
how to switch to a4 paper in excel 2013

How to Print Excel Sheet in A4 Size in Excel 2013

May 11, 2023October 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 …

Read More

Categories Excel Tags excel 2013
remove percentage in excel 2013

How to Remove Percentage in Excel 2013

April 25, 2023April 22, 2021 by Kermit Matthews

Managing the data inside an Excel spreadsheet can be difficult when the formatting is important. This can occur when you are using certain formulas, and …

Read More

Categories Excel Tags excel 2013
stop printing headings in excel 2013

How to Print Without Column Letters and Row Numbers in Excel 2013

May 21, 2023April 21, 2021 by Kermit Matthews

Excel print settings can be frustrating to adjust when you are creating your own, new spreadsheet, but they can be even worse when someone else …

Read More

Categories Excel Tags excel 2013
how to disable formula autocomplete in excel 2013

How to Turn Off Formula AutoComplete in Excel 2013

April 23, 2023April 9, 2021 by Kermit Matthews

Not everyone knows every formula in Microsoft Excel, and determining not only the correct formula, but the way to use it, can be difficult. Excel …

Read More

Categories Excel Tags excel 2013
an enabled developer tab in excel 2007

Where is the Developer Tab in Excel 2007?

May 20, 2023March 29, 2021 by Kermit Matthews

There is a tab in the ribbon at the top of Microsoft Excel for many of the types of changes that you want to make …

Read More

Categories Excel Tags excel 2007
how to print an empty grid in excel 2013

How to Print an Empty Grid in Excel 2013

May 12, 2023March 24, 2021 by Kermit Matthews

If you’ve ever tried to print empty cells in Excel then you have likely discovered that it isn’t as simple as going to the Print …

Read More

Categories Excel Tags excel 2013
how to unhide columns in excel 3 How to Unhide Columns in Excel 2016

How to Unhide Columns in Excel 2016

May 8, 2023February 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 …

Read More

Categories Excel
how to freeze row excel 3 How to Freeze a Row in Excel

How to Freeze a Row in Excel

May 20, 2023February 25, 2021 by Kermit Matthews

Making a large Excel spreadsheet more user-friendly can be difficult. But one way that you can improve it is by learning how to freeze a …

Read More

Categories Excel
how to delete a comment in Excel

How to Delete a Comment in Excel for Office 365

May 15, 2023September 9, 2020 by Kermit Matthews

Using comments and the other review tools in Microsoft Excel provides you with some convenient ways to collaborate on a project. Other users are able …

Read More

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

April 29, 2023August 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 …

Read More

Categories Excel
how to group rows in excel 4 How to Group Rows in Excel for Office 365

How to Group Rows in Excel for Office 365

May 13, 2023March 4, 2020 by Kermit Matthews

The steps in this article are going to show you how to select a number of rows and put them into a group using the …

Read More

Categories Excel Tags Rows
how show watch window excel 4 How to Open the Watch Window in Microsoft Excel for Office 365

How to Open the Watch Window in Microsoft Excel for Office 365

April 30, 2023August 28, 2019 by Kermit Matthews

The steps in this article are going to show you where to find the button that opens the Watch Window in Microsoft Excel. We cover …

Read More

Categories Excel
how stop picture printing excel 4 How to Stop a Picture from Printing in Excel for Office 365

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

May 6, 2023August 21, 2019 by Kermit Matthews

This guide is going to show you how to change the settings for a picture in Microsoft Excel so that the picture doesn’t print. We …

Read More

Categories Excel
how to sum column excel 2 How to Sum a Column in Excel

How to Sum a Column in Excel

May 20, 2023August 14, 2019 by Kermit Matthews

An important element of many spreadsheets is a row that displays the totals of your cell values. In a work environment, these totals are often …

Read More

Categories Excel Tags Columns
how to make exponent in excel 4 How to Make an Exponent in Excel

How to Make an Exponent in Excel

May 17, 2023May 31, 2019 by Kermit Matthews

Adding text and numbers to cells in Microsoft Excel is typically as easy as clicking on a cell and typing. Things get a little more …

Read More

Categories Excel
how set width height image excel 4 How to Set the Height or Width of a Picture in Inches in Excel 2013

How to Set the Height or Width of a Picture in Inches in Excel 2013

April 30, 2023January 10, 2019 by Kermit Matthews

Adding pictures to a spreadsheet can be important if you are sending a list of products to a potential customer and want them to see …

Read More

Categories Excel
Older posts
Newer posts
← Previous Page1 Page2 Page3 Page4 Next →

Join Our Free Newsletter

Featured guides and deals

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

  • About Us
  • Contact
  • Disclaimer
  • Privacy Policy
© Live2Tech.com 2025
  • Popular
  • iPhone
  • Excel
  • Word
  • Docs
  • Sheets
  • Tutorials