Spreadsheets

By SeventhSibling

2 comments

You can add a comment to an Excel formula. This is different than adding a comment to a cell. The comment added to a formula can be considered, for example, as a note to explain the meaning of the results of a formula. A formula comment does ... more »

How to Add a Picture to an Excel Comment Box

By SeventhSibling

0 comments

You can use text in a comment box to annotate an Excel cell, but have you ever considered using a picture? A picture says a thousand words!.. more »

How to Basics of Microsoft Excel

By SeventhSibling

1 comments

A spreadsheet is a rectangle table or grid used to present columns of categories, usually for financial purposes. Excel is a spreadsheet application whose files are referred to as Workbooks. An Excel workbook has one or more worksheets. ... more »

How to Calculate Age Using Excel

By SeventhSibling

0 comments

If you need to know the age of something and you have a start date, there is a formula you can use in Excel to calculate the age in year, month, and day format... more »

How to Calculate, Interpret, and Understand the Index of Dissimilarity

By Paul McDaniel

0 comments

The index of dissimilarity is an indicator of just how much one group is spatially segregated from another group. It is used frequently by population geographers and demographers. The index of dissimilarity is the standard measure of segregation ... more »

How to Change the Shape of an Excel Cell Comment

By SeventhSibling

0 comments

You can use comment boxes in Excel to annotate a cell. The comment box, by default, is a yellow rectangle. To give your Excel file some pizzazz, you can change the shape of the comment box... more »

How to Create a Drop-Down List in an Excel Cell

By SeventhSibling

0 comments

Providing a drop-down pick list of suitable responses ensures consistency in data. Learn how to create a drop down list to click on the desired response and have it automatically inserted into the cell... more »

How to Create a Dropdown List in an Excel Spreadsheet

By Melody

5 comments

I love a dropdown box, especially in a spreadsheet. When creating a form to be used by a variety of people, it’s most helpful to simplify things as much as possible. Even the easy task of entering a month can be complicated by the variety of ... more »

How to Create a Top 10 List in Excel

By dahawe

1 comments

Excel is a handy program to use in many ways. One way you can use this program is to answer common business questions such as, “What customers provided the most revenue for my company this year?”, and “Who are my top ten clients?” Creating a “Top ... more »

How to Create Labels with Different Addresses in Microsoft Word

By MidniteWriter

2 comments

It is fairly straightforward to create labels in your computer using Microsoft Word if they contain all the same data. In most cases, however, we need to create a list with different addresses or other information. This will get you headed in ... more »

How to display fractions with MS exel 2002

By Tweek45

0 comments

How to display fractions with Excel.. more »

How to Easily Navigate an Excel Spreadsheet

By dahawe

0 comments

If you are like a lot of Excel users, you learn a few basic moves and ways of getting the job done, and then you just get too busy to learn more...but now there is another answer - E-How articles. A person can learn a few basic navigation tips in ... more »

How to E-mail an Excel report

By dahawe

0 comments

How many times have you wanted to send an Excel report to a business associate or co-worker, and you end up sending them the entire spreadsheet as an attachment? Have you seen how big these spreadsheets can get? You might also want to hide some ... more »

How to Find Free Alternatives to Installing Microsoft Office Applications

By Virginia DeBolt

7 comments

An eHow user asked for an article explaining how to install Microsoft Office products for free. Sadly, it's not possible to get Microsoft products free. But there are alternatives that are just as good... more »

How to Fit an Excel Sheet on One Page

By triciagoss

0 comments

It can be frustrating when you are trying to print out a spreadsheet from Excel and it prints on several pages. Rather than tape them together for a huge, barely manageable worksheet, follow these tips to print your Excel spreadsheet on one page ... more »

How to import data from a txt file to a Excel file.

By alexleeyy

1 comments

You have a text file which have some data you want to copy to a Excel file.But when you just simple use "Copy" and "Paste" you find that the format isn't what you want... more »

How to Include Voice Confirmation With Excel Data Entry

By SeventhSibling

0 comments

Microsoft Excel 2003 comes with a nifty text to speech tool where you can hear Excel speak what you type. Intended as a proofing tool, this feature can be fun to try... more »

How to Merge Cells in Excel

By eHow Computers Editor

0 comments

While you are working within a Microsoft Excel spreadsheet you may find the need to merge two or more cells together to form one cell. This is often done if you need to add a heading or title to a row, column or section of your Excel spreadsheet. ... more »

How to Navigate Excel Worksheets Using the Keyboard

By SeventhSibling

1 comments

To get around in a worksheet, you can just click your mouse to select a cell. But there are also keyboard buttons to jump you to a specific location... more »

How to Open Microsoft 2007 Files From Microsoft 2003

By SeventhSibling

0 comments

Sharing Microsoft Office 2007 Word, Excel, or PowerPoint files with someone using Microsoft 2003 can cause compatibility issues. The recipient of the file may not be able to open the file. There are two remedies. The creator of the Office 2007 ... more »

How to Preview an Excel Worksheet before Printing

By SeventhSibling

0 comments

You can preview an Excel worksheet before you print it to see what it looks like. That way, you can determine if you need to adjust the margins, portrait or landscape layout, or page breaks if the worksheet is large. One way to make adjusts is ... more »

How to Print Mailing Labels from Excel XP: Master Mail Merge!

By RainMaker

0 comments

Mail Merge is Microsoft's software for printing formatted addresses -- in form letters, on envelopes, on labels, and so on -- from address lists that you've built in Excel, Access, SQL, or other Microsoft Office software. \r\n Mail Merge is a ... more »

How to Print Selected Areas of an Excel Worksheet

By eHow Computers Editor

0 comments

Sometimes you only want to print part of a spreadsheet, particularly if you're working with a large one. These steps work with Microsoft Excel 97... more »

How to Print the Gridlines of an Excel Worksheet

By eHow Computers Editor

0 comments

When you work within Microsoft Excel, there are gridlines that separate your rows and columns into cells. These light gray lines keep the data organized and easy to read. When you go to print your Excel spreadsheet, it will be printed by default ... more »

How to Remove Unwanted Spaces from an Excel Data List

By dahawe

0 comments

You know how sometimes you get stuck using data you have no control over? Happens a lot, especially in business situations. Knowing how to "scrub" data (removing inaccuracies, inconsistencies, and errors) in data is a must if you want ... more »

Check Out All Categories

Articles in Spreadsheets