Spreadsheets

By eHow Computers Editor

0 comments

Once you are finished formatting your Microsoft Excel 2007 worksheet group, you can print the worksheet group all at the same time. This is a quick way to print selected worksheets with making only a simple change to the print settings within ... more »

How to Read the News in Excel

By eHow Computers Editor

0 comments

Having direct access to news is now even more convenient than ever before. You can now read the news in Excel. You will need to change the settings in Excel the first time that you use it to read the news, but after the initial changes you should ... more »

How to Recover Corrupt Excel Files

By eHow Computers Editor

1 comments

Computer files become corrupt sometimes and Excel files are no exception. Sometimes there are reasons, like computers being turned off inappropriately, corrupt sectors on a hard drive, or viruses. Other times there is no rhyme or reason, it just ... more »

How to Reduce the Size of Excel Files

By eHow Computers Editor

0 comments

Many businesses use Excel to track their data and expenses. However, you can run into problems when files grow too big. Try reducing the size of your Excel files in different ways to eliminate your storage problems... more »

How to Refer to a Range Name in Excel

By eHow Computers Editor

0 comments

A range name is a name that is given to a group of cells within Microsoft Excel 2007. Once you have created a range name you can then reference the range name instead of the cell reference inside of a formula. Follow the steps below to find out ... more »

How to Rename a Worksheet in Excel 2003

By eHow Computers Editor

0 comments

Reasons for renaming a Microsoft Excel 2003 worksheet range from updating a title to reflect new data to user errors and misspellings. Follow these steps to rename a worksheet in Excel 2003... more »

How to Resize a Chart in Excel

By eHow Computers Editor

0 comments

A chart in Microsoft Excel 2007 can easily be resized to make the most impact to your worksheet. By resizing the chart, you can make the chart larger, smaller, wider or taller. All the content within the chart will be automatically adjusted to ... more »

How to Round a Range of Cells in Excel

By RLRhodes

0 comments

If you have a range of cells within an Excel workbook, and you want to round these numbers to a certain number of places beyond the decimal, follow these easy steps... more »

How to Select Multiple Sheets in Excel

By chinne01

0 comments

Excel spreadsheets are extremely efficient and cut your work down immensely, IF you know what you are doing and are able to utilize all of the functions that it offers. Many times you will be required to work with multiple worksheets and you will ... more »

How to Separate Cell Data in Excel

By eHow Computers Editor

0 comments

If you have some cell data in a Microsoft Excel worksheet that needs to be separated, you can do so automatically using the "Convert Text to Columns Wizard." This wizard allows you to easily separate cell content into multiple columns. A good ... more »

How to Set Printing Options in Excel

By eHow Computers Editor

0 comments

Within the "Print" dialog box in Microsoft Excel, you can set a wide variety of options so you can print your spreadsheet just how you would like to have it printed. You can set where you want to print your spreadsheet and how you want to print ... more »

How to Set Up a Mailing List in Excel

By eHow Computers Editor

0 comments

You can use Microsoft Excel to coordinate your mailing lists. Follow these steps to gather your data on a spreadsheet and prepare your labels... more »

How to Sort Information in Excel 2007

By eHow Computers Editor

0 comments

Excel 2007 provides robust tools for sorting information. For example, data can be sorted by numeric value as well as by cell and font color or cell icons that depict particular thresholds that a set of data might meet. Sorting in Excel 2007 ... more »

How to Sort Microsoft Excel Rows Alphabetically

By eHow Computers Editor

0 comments

It's hard to beat Microsoft Excel for its ability to organize data. The great part about Excel is that it doesn't take much effort to sort the data the way you want it. A few clicks and what was once a jumbled set of information is now something ... more »

How to Spell Check Multiple Worksheets in Excel

By eHow Computers Editor

0 comments

Spell checking multiple worksheets in Excel is easy and more time efficient than going through each individual worksheet with a spell check. The process is simple, and it allows you to spell check even 50 worksheets at once in no time... more »

How to Split Your Document Into Two Panes/ Excel

By chinne01

0 comments

at times you may need to work on two sections of a document at the same time. Scrolling back and forth between the two sections is nothing less than annoying. Instead, you can split your document window into two horizontal panes... more »

How to Switch to Manual Calculation in Excel

By eHow Computers Editor

0 comments

By default, Microsoft Excel 2007 is set to automatically calculate any formula that you type or insert into an Excel workbook. If you would like, you can change to manual calculation mode. This means that Excel will not perform any calculations ... more »

How to Track Weight Watcher Flex Points in Excel

By eHow Computers Editor

0 comments

Weight Watchers is one way to help you reach your ideal weight. The plan uses a point system for foods to calculate the amount of food you can eat per day. The Flex Point system gives you additional points to use as you want every week. While ... more »

How to Transform a Spreadsheet into a Web Page in Excel 2003

By eHow Computers Editor

0 comments

In a few simple steps, you can make an Excel 2003 worksheet ready for people to use or view on the Internet. Here's how to turn your spreadsheet into a Web page... more »

How to Turn Off the Office Task Pane at Startup

By triciagoss

0 comments

The Task Pane in Microsoft Office can offer lots of helpful advice and assistance. But perhaps you don’t want it to show up every time you open Word. Here are some easy steps to show you how to turn off the Task Pane at startup... more »

How to Use Scenario Manager in Microsoft Excel

By Keith Johnson

0 comments

A scenario is a Microsoft Excel spreadsheet that reflects a specific set of circumstances. Change those circumstances and you create another scenario. Use scenarios to see how different conditions will impact your bottom line... more »

How to use 10 Microsoft Windows Shortcut Keys

By Tsunami

0 comments

Top 10 list of Shortcut Key combinations that will make your Windows experience better... more »

How to Use a Basic GoTo Command

By eHow Computers Editor

0 comments

Using a basic GoTo command can make using a spreadsheet easier. If you have thousands of entries, a GoTo command is almost mandatory. After learning how to use the GoTo command, you will see how navigating a spreadsheet sheet can be as easy as 1, ... more »

How to use a Pivot Table in Excel

By Traqqer

0 comments

One of the best kept secrets in database analysis is the Pivot Table tool in Excel. Using this tool, it is extremely easy to quickly group items and perform various summary calculations. Excel’s Pivot Table have allowed college graduate ... more »

How to Use a Reference in a Different Excel Spreadsheet

By Sharon Slayton

0 comments

Learning how to share Excel spreadsheet cell references with other spreadsheets and workbooks is pretty easy with a little practice. You can even use this technique to link to spreadsheets on the web, giving you some valuable tools to enhance ... more »

Check Out All Categories

Articles in Spreadsheets