Spreadsheets

How to Adjust Chart Fonts in Excel

By eHow Computers Editor

0 comments

When a chart is created in Microsoft Excel 2007 it uses rather boring unformatted text for the copy that appears in relation to the chart. You can change this text by adjusting the chart fonts. This allows you to choose a different font, size, ... more »

How to Align Text in Excel Cells

By eHow Computers Editor

0 comments

Use the Alignment option in Excel to specify the horizontal and vertical alignment of your row and column labels. These steps work with Microsoft Excel 97... more »

How to Apply a Chart Layout in Excel

By eHow Computers Editor

0 comments

After you have created your Microsoft Excel 2007 chart from your workbook, you may decide that you want to change the layout of the chart. Excel offers several different layouts that you can apply to each type of charts. Follow the steps below to ... more »

How to Calculate Fixed-Declining Depreciation Using Excel

By eHow Computers Editor

0 comments

Depreciation of an asset is its decrease in value due to wear and tear. Every piece of equipment you use in your home or business depreciates over time. Fixed-declining depreciation decreases in value at a constant rate, and Microsoft Excel can ... more »

How to Calculate the Future Value of an Investment Using Excel

By eHow Computers Editor

0 comments

Using Microsoft Excel to calculate the future value of a potential investment is a relatively simple task once you have learned the required formula's syntax. Follow these easy steps while inputting your own criteria. You will soon learn how to ... more »

How to Change Appearance in Excel 2007

By eHow Computers Editor

0 comments

Microsoft Excel 2007 introduced a number of changes to the popular spreadsheet program. Now, not only can you analyze and manage data, but you can make it look just the way you want. Adopt a signature style to share your information or adopt new ... more »

How to Change Default Colors in Excel

By eHow Computers Editor

0 comments

The default color for fonts in an Excel spreadsheet is black while the default background color is white. However, there are many colors to select from and the user can also modify the appearance of these colors. There are several methods one can ... more »

How to Change Default Fonts in Excel

By eHow Computers Editor

0 comments

The default font for Excel spreadsheets is usually Arial, with the size set at 10. However, there are other options for fonts that will make worksheets appear bolder and more readable. The user can change the font attributes for a cell or a group ... more »

How to Change Interval of Category Axis in an Excel Chart

By eHow Computers Editor

0 comments

When you create a chart, Microsoft Excel 2007 sets the interval of the category axis. You can change this to reflect the interval you want to be represented in between each tick mark... more »

How to Change Interval of Value Axis in an Excel Chart

By eHow Computers Editor

0 comments

When a Microsoft Excel 2007 chart is first created, Excel determines the intervals of the value, or "Y" axis. You can customize the look of your chart by changing the interval of the value axis... more »

How to Change the Chart Type in Excel

By eHow Computers Editor

0 comments

Once you have created a chart in Microsoft Excel 2007, you may change your mind about the type of chart you have chosen. Instead of recreating your chart, you can simply change the chart type of the existing chart. The steps below will show you ... more »

How to Change the Color of Excel Gridlines

By triciagoss

0 comments

Gridlines can help make your Excel spreadsheet easier to read. While the default color of Excel gridlines is black, you can change the gridline color of any worksheet by following these simple steps... more »

How to Change the Display of Axes in Excel

By eHow Computers Editor

0 comments

The way information is displayed on the primary horizontal and vertical axes of a chart can be customized in Microsoft Excel 2007. You can choose to have your data show up on a certain side of the axis or be displayed in a certain amount. Follow ... more »

How to Change the Font in an Excel Header or Footer

By triciagoss

0 comments

You can make your Excel spreadsheet look much more professional by adding headers and footers. And you can make your header or footer really stand out by changing the font... more »

How to Check for Circular References in Excel

By eHow Computers Editor

0 comments

A circular reference happens when a formula refers to the cell in which it resides. If this happens, the formula will fail to find a result and will enter the result of "0" into the document. You can check for and fix these errors by using the ... more »

How to Clean up Excel Data

By dahawe

0 comments

Using Excel can be easy or a real pain, and sometimes the difference is how the data is organized. If you are able to set up the data yourself, you have more control (see related articles). Often, though, we are handed a spreadsheet and told to ... more »

How to Convert Measurements in Excel

By eHow Computers Editor

0 comments

For complex spreadsheets where many calculations must be performed, unit conversions may need to be done before they can be used. If you have measurements that were taken in one unit, you can change the units of that measurement into the units ... more »

How to Copy an Excel Chart to Word

By eHow Computers Editor

0 comments

You can use the "Paste Special" command in Microsoft Word 2007 to paste a copied Microsoft Excel 2007 chart into a word document. With this option you can create a linkable chart in Word that will update when the original Excel chart is changed. ... more »

How to Copy Cell Contents Without Borders in Microsoft Excel

By Naz Ir

0 comments

When you copy and paste cell contents in Excel, you will end up copying the borders as well. Read on to learn how to copy cell contents without borders in Microsoft Excel... more »

How to Create a 3D Chart in Excel

By eHow Computers Editor

0 comments

Any chart that has been created in Microsoft Excel 2007 can be turned into a 3D chart. This process allows you to specify the type of bevel, depth, contour and surface of the 3D effect you apply to the chart. Follow the steps below to find out ... more »

How to Create a Chart in Excel 2007

By eHow Computers Editor

0 comments

Excel 2007 provides robust tools for creating effective, dynamic charts to visually represent otherwise stagnant data. The new Office 2007 Ribbon makes accessing these charting functions even easier and more efficient... more »

How to Create a Conditional Formula in Excel 2007

By eHow Computers Editor

0 comments

When a user first experiments with the conditional formulas in Excel 2007, it can seem foreign. What does true and false have to do with a spreadsheet where number reign supreme? However, conditional formulas are actually quite simple once a ... more »

How to Create a Consistency File

By how2beu

0 comments

Need to keep track of some things, habits, or events that need to occur on a regular basis? I developed a file that helps you keep track of things like new habits, new daily rituals, and certain things you need to be reminded of. Inspired by ... more »

How to Create a Constant in Microsoft Excel

By Keith Johnson

0 comments

Are you frequently using the same value in your Microsoft Excel spreadsheet? If so, then it’s time to create a constant. A constant is a name that represents a value that doesn't change--and creating one is simple... more »

How to Create a Mirrored Image in Excel

By eHow Computers Editor

0 comments

Microsoft Excel software works great as a spreadsheet but many people don't know it has a wonderful editor that allows you to bring in an object and manipulate it as needed. Excel allows you to mirror an image for photos, iron ons, special front ... more »

Check Out All Categories

Articles in Spreadsheets