How to Display Cell Formulas in Excel 2013 Text Boxes
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 …
Excel
How-to guides and tutorials to help you perform specific tasks and use the Microsoft Excel spreadsheet application.
How to Hide Scroll Bar Excel 2013 Guide
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 …
Where is the Formula Bar in Excel 2013?
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 …
How to Add a Hyperlink to a Picture in an Excel 2013 Spreadsheet
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 …
How to Make All Letters Capital in Excel 2013
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 …
How to Delete a Text Box in Excel 2013
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 …
How to Remove Fill Color in Excel Text Box in Microsoft Excel 2013
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 …
How to Add a Title in Excel 2013
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 …
How to Hide Cells in Excel 2013
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 …
How to Save an Excel Chart as an Image in Excel 2016
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 …
How to Set Row 1 to Print on Every Page – Excel 2016
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 …
How to Remove Page Breaks in Excel 2013
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 …
How to Center Worksheet Horizontally in Excel (and Vertically, Too)
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 …
The Complete Guide to Optimizing a Page for Printing in Excel 2013
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 …
How Do You Fill a Cell With Color in Excel 2013?
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 …
How to Disable Excel Live Preview
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 …
Why Is Excel Cutting Off Text When Printing My Spreadsheet?
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 …
Fill Cells With Consecutive Numbers in Excel 2013 Automatically and Quickly
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 …
How to Stop Excel from Zooming When I Scroll My Mouse Wheel
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 …
How to Format Money Without the Dollar Sign in Excel 2013
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 …
How to Print Excel Without Lines in Microsoft Office 2013
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 …
How to Use the Excel 2010 Fit to Page Option
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 …
How to Format UPC Codes in Excel
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 …
How to Remove Underline in Excel 2013 Hyperlinks
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 …
How to Select Cells in Excel 2013
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 …
How to Change the Excel Cell Shading Color in Excel 2010
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 …
How to Change the Default Font in Excel 2013
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 …
How to Set the Print Area – Excel 2013
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 …
How to Copy a Column in Excel for Office 365
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 …
How to Crop Image in Excel 2013
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 …
How to Remove Strikethrough in Excel 2013
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 …
How to Enable Macros in Excel 2013
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 …
How to Change a Tab Name in Excel 2016
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 …
How to Print First Row on Every Page – Excel 2010
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 …
How to Print Excel Sheet in A4 Size in Excel 2013
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 …
How to Remove Percentage in Excel 2013
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 …
How to Print Without Column Letters and Row Numbers in Excel 2013
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 …
How to Turn Off Formula AutoComplete in Excel 2013
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 …
Where is the Developer Tab in Excel 2007?
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 …
How to Print an Empty Grid in Excel 2013
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 …
How to Unhide Columns in Excel 2016
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 …
How to Freeze a Row in Excel
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 …
How to Delete a Comment in Excel for Office 365
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 …
How to Switch the Format for a Whole Column in Excel for Office 365
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 …
How to Group Rows in Excel for Office 365
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 …
How to Open the Watch Window in Microsoft Excel for Office 365
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 …
How to Stop a Picture from Printing in Excel for Office 365
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 …
How to Sum a Column in Excel
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 …
How to Make an Exponent in Excel
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 …
How to Set the Height or Width of a Picture in Inches in Excel 2013
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 …