how to center text in a column in Excel 2010

How to Center Text in a Column in Excel 2010

Information in adjacent cells in a spreadsheet can become difficult to read if there isn’t a lot of white space between each cell. One way to combat this problem, however, is by centering text inside of a cell. This will create an equal amount of white space to the left and right of the data… Continue Reading How to Center Text in a Column in Excel 2010

how to show zero decimal places in excel 2010

How to Stop Showing Decimal Places in Excel 2010

People use Microsoft Excel for a number of different reasons, so there are often times where something that is correct for one user is not correct for another. One specific area of contention is the number of decimal places that you need to use for your numbers. While two decimal places might be ideal for… Continue Reading How to Stop Showing Decimal Places in Excel 2010

how to display cell values instead of ###### symbols in Excel 2010

Why Is Excel Showing ###### Instead of a Number?

An Excel spreadsheet is a convenient way to organize and store data. The grid structure makes it easy to locate a specific bit of data so that you can use it in whatever way you need. But occasionally the value in a cell might be replaced by a series of ###### symbols and you can’t… Continue Reading Why Is Excel Showing ###### Instead of a Number?

how to change the cell color in Excel 2013

How to Change the Color of a Cell in Excel 2013

Large spreadsheets are generally pretty difficult to read, whether you are looking at them on a screen or as a printed document. There are a number of different ways to make spreadsheets easier to read, but perhaps one of the simplest and most effective choices is to add color to rows containing data of a… Continue Reading How to Change the Color of a Cell in Excel 2013

how to sort alphabetically in excel 2010

How to Alphabetize a Column in Excel 2010

Last updated: January 19, 2017 There are many reasons to learn how to alphabetize in Excel, but it is such an important and versatile part of the program that it will undoubtedly make your experience in Excel more enjoyable. The ability to automatically sort text columns, as well as numbers, dates, or monetary amounts, will… Continue Reading How to Alphabetize a Column in Excel 2010

how to sort by date in excel 2010

How to Sort by Date in Excel 2010

Arbitrarily searching for data in Microsoft Excel 2010 can be very time consuming, especially when the fields that you need to locate are not listed anywhere near each other. Fortunately you can easily sort data in Excel by ascending or descending values to make it easier to locate the data you need. This sorting method… Continue Reading How to Sort by Date in Excel 2010

how to exit full screen view in excel 2010

How to Exit Full Screen View in Excel 2010

Excel 2010 has a number of different view options that are meant to make the spreadsheet easier to work with in specific situations. One of the view options is “Full Screen” and it will change the Excel window so that your spreadsheet is taking up the entirety of your screen. This is helpful if you… Continue Reading How to Exit Full Screen View in Excel 2010

how to scale a page in excel 2010

How to Scale a Page in Excel 2010

Page scaling in Microsoft Excel 2010 is something that is mostly beneficial when you need to print. Adjusting the scaling will not affect the appearance of your spreadsheet on the screen, but rather when you send the spreadsheet to your printer. If you are sharing a document with someone that you know will be printing… Continue Reading How to Scale a Page in Excel 2010

how to subtract in excel 2010

How Do You Subtract in Excel 2010?

If you are new to using Excel, then you might not be aware of exactly how powerful a program it actually is. You can use a variety of different formulas to compare and perform mathematical functions on the values that you enter into a cell, allowing you to gain more insight into the data that… Continue Reading How Do You Subtract in Excel 2010?

how to remove cell formatting in excel 2013

Removing Cell Formatting in Excel 2013

Large Excel files can be difficult to read, especially when they contain a lot of data, only some of which might be relevant to a particular situation. A simple way to make important data stand out is to change the way it looks. Whether this involves changing the color of a cell, adding a border,… Continue Reading Removing Cell Formatting in Excel 2013