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 change inches to centimeters on excel 2013 ruler

How to Change from Inches to Centimeters on the Excel 2013 Ruler

Last Updated On May 18, 2023 by Kermit Matthews

Microsoft Excel will use the unit of measurement that is the default for the country where it thinks you are. it’s possible that this setting …

Read More

Categories Excel Tags excel 2013
how to freeze top 2 rows in Excel

How to Freeze Top 2 Rows in Excel [2023 Guide]

Last Updated On May 22, 2023 by Kermit Matthews

The option to freeze rows in Microsoft Excel may not be used for a time, but it can be incredibly useful if you start using …

Read More

Categories Excel
how to expand all rows in Excel for Office 365

How to Expand All Rows in Excel for Office 365

Last Updated On April 27, 2023 by Kermit Matthews

Making data easy to read in Excel can go a long way in helping the perceived quality of your work. This can involve things like …

Read More

Categories Excel Tags Rows
how to clear the clipboard in Excel for Office 365

How to Clear the Clipboard in Excel for Office 365

Last Updated On April 23, 2023 by Kermit Matthews

You may not give much thought to the clipboard in Microsoft Excel when it’s working properly because it doesn’t seem like something that could malfunction. …

Read More

Categories Excel
how to print all excel columns on one page

How to Prevent Extra Pages from Printing in Excel 2010

Last Updated On May 3, 2023 by Kermit Matthews

The first time you try and print a large spreadsheet in Microsoft Excel, there’s a good chance that something will go wrong. There won’t be …

Read More

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

How to Copy as a Picture in Excel 2013

Last Updated On May 10, 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 …

Read More

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

Last Updated On May 15, 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 …

Read More

Categories Excel Tags excel 2013
how to disable automatic hyperlinks in excel 2013

How to Disable Automatic Hyperlinks in Excel 2013

Last Updated On May 6, 2023 by Kermit Matthews

Microsoft Excel can be a good solution for storing all types of data. One of the things that you might have decided to put into …

Read More

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

How to Stop Showing Recent Documents in Excel 2013

Last Updated On May 5, 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 …

Read More

Categories Excel Tags excel 2013
change the number of recent documents

How to Change the Number of Recent Documents in Excel 2011

Last Updated On May 14, 2023 by Kermit Matthews

Microsoft Excel has a section in one of its menus where you can see a list of the documents that you have recently edited in …

Read More

Categories Excel Tags excel 2011
click the show formulas button

How to Hide Formulas in Excel 2013

Last Updated On May 1, 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 …

Read More

Categories Excel Tags excel 2013
why excel showing formulas instead of results 2 Why is Excel Showing My Formulas Instead of Their Results?

Why is Excel Showing My Formulas Instead of Their Results?

Last Updated On May 9, 2023 by Kermit Matthews

When you enter a formula into one of your cells, it’s usually because you want to see the value that the formula creates. But Excel …

Read More

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

How to Display Cell Formulas in Excel 2013 Text Boxes

Last Updated On May 4, 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

Last Updated On May 8, 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?

Last Updated On May 7, 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

Last Updated On April 29, 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

Last Updated On May 4, 2023 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

Last Updated On May 14, 2023 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

Last Updated On April 29, 2023 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

Last Updated On May 20, 2023 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

Last Updated On May 18, 2023 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

Last Updated On May 6, 2023 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

Last Updated On May 13, 2023 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

Last Updated On May 3, 2023 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)

Last Updated On May 14, 2023 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

Last Updated On May 10, 2023 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?

Last Updated On April 26, 2023 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 strikethrough in excel 2013

How to Apply Strikethrough to a Cell in Excel 2013

Last Updated On August 16, 2023 by Kermit Matthews

While strikethrough is not something that a lot of people use, it can become really useful once you become comfortable with that type of formatting. …

Read More

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

How to Disable Excel Live Preview

Last Updated On April 25, 2023 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?

Last Updated On April 28, 2023 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

Last Updated On May 9, 2023 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

Last Updated On May 7, 2023 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

Last Updated On May 11, 2023 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

Last Updated On April 24, 2023 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

Last Updated On May 10, 2023 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

Last Updated On April 26, 2023 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

Last Updated On May 6, 2023 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

Last Updated On May 5, 2023 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

Last Updated On April 29, 2023 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

Last Updated On April 30, 2023 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

Last Updated On April 24, 2023 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

Last Updated On April 22, 2023 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

Last Updated On May 10, 2023 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

Last Updated On April 23, 2023 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

Last Updated On April 25, 2023 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

Last Updated On May 10, 2023 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

Last Updated On May 2, 2023 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

Last Updated On May 11, 2023 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

Last Updated On April 25, 2023 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

Last Updated On May 21, 2023 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
Older posts
Page1 Page2 Page3 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 2023
  • Popular
  • iPhone
  • Excel
  • Word
  • Docs
  • Sheets