Spreadsheets

How to Create an Legal Size Word Document

By Katie OConnor

0 comments

If you've never created a legal-sized document before, the whole process may seem like a mystery. Once you get the hang out it though, you'll be printing documents in many sizes!.. more »

How to Edit a Pasted Printscreen Command on an Excel Sheet

By JBELLEVI

1 comments

Editing in Excell or any program can be tricky! Follow these simple steps and you will be able to edit any print screen for Excell!.. more »

How to excel with Excel (and the ASAP Utilities add-on)

By David Sarokin

0 comments

The Excel spreadsheet program is typical Microsoft -- amazingly powerful, totally dominant in the marketplace, and not even *close* to being user-friendly. If you just want to add up a few columns of numbers, fine. But for more sophisticated ... more »

How to Filter Data in a Microsoft Excel Worksheet

By mar1965

2 comments

This article shows you how to filter data in Microsoft Excel, especially if you have a worksheet with many columns and hundreds or even thousands of rows. The article assumes that your table/data has a clear set of headings (preferably only a ... more »

How to fix the "C:\Documents.xls' could not be found." error in MS Excel

By nethopperz

2 comments

When opening any Excel spreadsheet by double clicking the file, Excel successfully opens, but so does the following error: "'C\Documents.xls' could not be found. Check the spelling of the filename, and verify that the file location is ... more »

How to Organize Your Wine Collection

By RainMaker

0 comments

So you've built up a satisfying selection of wines, but are losing track of what's what, and where? Here's how to bring order back to the chaos... more »

How to Print Continuing Row and Column Headings for an Excel Worksheet

By eHow Computers Editor

2 comments

If your spreadsheet spans multiple pages, you can tell Excel to print column and row headings at the top of each page. These steps work with Microsoft Excel 97... more »

How to Protect Excel Cells From Modification

By eHow Computers Editor

2 comments

Protect cells if you want people to look at your work, but you don't want to risk their messing up your formulas. These steps work with Microsoft Excel 97... more »

How to Set Up a Microsoft My Office Online Account

By Diane Dilov-Schultheis

0 comments

If you have Microsoft Office on your computer, you should become part of the Office Online community. It is free and provided by Microsoft to assist you in keeping your Microsoft Office up to date and more. When you sign up you will be able to ... more »

How to Split a Column of Data in MS Excel

By Melody

0 comments

There are occasions when you need to split a column of data into two or more columns. Here’s how to do it... more »

How to Ungroup Worksheets in Excel

By eHow Computers Editor

0 comments

After you have formatted all the worksheets in a Microsoft Excel 2007 group, you may want to ungroup some or all of the worksheets. This is an easy process that requires you to ungroup the worksheets by using the sheet tabs to indicate which ... more »

How to Add Headers and Footers to Excel Documents

By eHow Computers Editor

1 comments

What page is that? Those days are over; headers and footers in your Excel report remove this problem. Add page numbers, file names, and the date to the top or bottom of each spreadsheet page. These steps work with Microsoft Excel 97... more »

How to Calculate Straight-Line Depreciation Using Microsoft Excel

By eHow Computers Editor

0 comments

Microsoft Excel has many useful functions that make a person or business more productive. One such function is the calculation of straight-line depreciation. Basic accounting knowledge and a working knowledge of Microsoft Excel are all that it ... more »

How to Calculate the Internal Rate of Return Using Excel

By eHow Computers Editor

0 comments

Internal rate of return, useful information when you're choosing investments, is one financial calculation that is simplified by Microsoft Excel. To find it, you compare the positive and negative cash flows from a proposed investment and ... more »

How to Create a Message Box in Excel VBA

By Keith Johnson

0 comments

Most programming languages have some way to communicate with users. In Excel VBA, that way is the message box. The message box is a dialog box you can customize to give warnings, information and instructions to anyone using your program. And ... more »

How to Create an Input Box in Excel VBA

By Keith Johnson

0 comments

There’s no way around it: If you want to add interactivity to your Excel VBA programs, you have to use input boxes. Input boxes request and store data from users--and here's how you create one... more »

How to Decide When to Use a Spreadsheet

By eHow Computers Editor

0 comments

Although you can use a spreadsheet to set up tables of just textual information, its real usefulness lies in its ability to calculate formulas - and recalculate them automatically when values change. Spreadsheets are great for budgets, financial ... more »

How to Fill Blank Cells in a Data Table in MS Excel

By Melody

2 comments

Daily users of Excel often work with large tables of data. Excel’s functionality can be impaired or limited by blank cells within data. The solution is to fill blank cells with zeros. If the table is small, typing zeros in blank cells is easy ... more »

How to Find the Number That Appears Most Frequent in a Column in Excel

By harleymilo

1 comments

The mode of a set of data is the value in the set that occurs most often. Find out what is the most popular item in an Excel column using a filter... more »

How to Insert a Row or Column in an Excel Spreadsheet

By eHow Computers Editor

0 comments

You don't have to redo the whole spreadsheet if you left out a row or column. Just use the Excel Insert command. These steps are intended for Microsoft Excel 97... more »

How to Sort Linked Sheets in Excel Without Screwing up the Linked Data

By Melody

5 comments

Excel is a super tool! Of course, being of the finance profession, I guess I'm a bit biased as I simply could not function without Excel. A fellow eHow member requested this article and here's my shot at it ..... more »

How to Update Microsoft Office

By Diane Dilov-Schultheis

0 comments

Anyone using Microsoft Office on their system should have the newest available updates installed. Keeping your software updated will ensure its reliability. You can get Microsoft Office updates for the following products: * Microsoft Office ... more »

How to Use the Pivot Table Wizard in Excel

By eHow Computers Editor

0 comments

A pivot table is an interactive worksheet table that quickly summarizes large amounts of data. You can rotate table rows and column headings around the core data area to give a different view of the information (for example, one view might show ... more »

How to Add a Background Color or Pattern to Excel Cells

By eHow Computers Editor

0 comments

Adding color to highlight your column labels or your totals can make your worksheet easier to read and use. Use the Patterns option to add background color and patterns to your worksheet. These steps work with Microsoft Excel 97... more »

How to Add a Header and Footer in Excel

By eHow Computers Editor

0 comments

Excel is commonly used in workplaces and schools and also in many homes for personal information. When printing Excel files, it is helpful when the pages have a header or footer to help you identify the documents. Follow these steps to add both a ... more »

Check Out All Categories

Articles in Spreadsheets