Spreadsheets

How to Enter Data Into an Excel Cell

By eHow Computers Editor

0 comments

Creating an electronic worksheet is as easy as typing. These steps work for Microsoft Excel 97... more »

How to Explain a GoTo command

By eHow Computers Editor

0 comments

A GoTo command sounds complicated, but it is really quite easy to use. If you understand the concept of using a GPS, a GoTo command is basically the same thing. The difference of course is that a GPS navigates you around the world, whereas a GoTo ... more »

How to Export an Excel Spreadsheet

By eHow Computers Editor

0 comments

Excel is a rich spreadsheet application that includes such features as graphing tools, VBA macros, pivot tables and the ability to make basic to complex calculations. It is a common practice to create and analyze data in Excel and then export it ... more »

How to Find the Hidden Game in Excel 2000

By eHow Computers Editor

0 comments

So-called "Easter eggs," or mini-programs hidden inside software applications, are a time-honored tradition among software developers. Often, they simply list the names of the people who wrote the application. Sometimes, though, they're more ... more »

How to Format a Chart Fill in Excel

By eHow Computers Editor

0 comments

Almost any object in a Microsoft Excel 2007 chart can be filled. You can choose to fill that object with a solid color, gradient, picture or texture. The type of fill you choose can then be customized for a unique look. Keep reading to find out ... more »

How to Format a Chart Line Style in Excel

By eHow Computers Editor

0 comments

You can format almost any component of a Microsoft Excel 2007 chart. You can make a big impact on the look of your chart by formatting the line style. You can change the type and width of the line and specify what you want arrows within the chart ... more »

How to Format Excel Spreadsheets

By eHow Computers Editor

0 comments

Formatting spreadsheets in Excel can make them easier to read and more visually appealing. The tools used to format elements of spreadsheets are contained in the Format menu. Some of the items that users can format in Excel spreadsheets include ... more »

How to Format Lines in an Excel Chart

By eHow Computers Editor

0 comments

You can emphasize the information organized in your chart in Microsoft Excel 2007 by taking some time to format your lines. You can format the line color, line style and shadow for a particular line or set of lines in your chart... more »

How to Format Numbers in Excel 2003

By eHow Computers Editor

0 comments

In Microsoft Excel 2003 you can format how numbers will appear in your spreadsheet. To format how many decimal places you want, how the time and date is displayed, or how fractions, zip codes and other data appear, follow these steps... more »

How to Format Rows and Columns in Excel 2003

By eHow Computers Editor

0 comments

With the format feature in Microsoft Excel you can adjust the size of your spreadsheet's rows and columns, depending on how much information you want in each cell. All you have to do is follow these guidelines... more »

How to Format Worksheet Groups in Excel

By eHow Computers Editor

0 comments

The advantage of grouping worksheets together in Microsoft Excel 2007, is that you can format them all at the same time. This creates a uniform look to the worksheets in the group and can save you a lot of time formatting all the worksheets ... more »

How to Generate a Random Number in a Range in Excel

By eHow Computers Editor

0 comments

The "Rand" function in Microsoft Excel will automatically create random numbers for your Excel spreadsheet. You can use the "RandBetween" function to create random numbers that fall in a range that you specify. Follow the steps below to find out ... more »

How to Generate a Random Number in Excel

By eHow Computers Editor

0 comments

The "RAND" function in Microsoft Excel allows you to generate a random number in Excel in just a few minutes. By selecting the cell you want to generate a random number into, you can then use the "RAND" function to enter a random number between 0 ... more »

How to Get a Random Sample in Excel

By eHow Computers Editor

0 comments

If you have records in a Microsoft Excel 2007 spreadsheet, you can get a random sample of those records. A random sample will help you make important decisions from a smaller selection of data. Follow the steps below to learn how you can get a ... more »

How to Get Microsoft Excel Help

By eHow Computers Editor

0 comments

While there are many ways to get help with Microsoft Excel, one of the first places to check is within the software itself. Excel has a great help system that you can access within your file. With a few clicks of the mouse, you can locate the ... more »

How to Get Real Time Stock Updates in Excel

By eHow Computers Editor

0 comments

If you want to keep track of your stock prices without the risk of your boss catching you at your browser, keep track with an Excel spreadsheet. You can add live stock quotes and follow the news for your stock while appearing to crunch the ... more »

How to Get Stock Quotes in Excel

By eHow Computers Editor

0 comments

Most people use Microsoft Excel for calculation and data storage. There are other functions in Excel that are very useful but not well known. One such function is the ability to import detailed stock quotes directly into a Microsoft Excel ... more »

How to Group and Outline Excel Data

By eHow Computers Editor

0 comments

Outlining data in an Excel spreadsheet will organize the sheet and make it easier to view. Data can be collapsed so that only the summary is available or expanded to view details. Once your spreadsheet is prepared and organized, it's easy to use ... more »

How to Group Worksheets in Excel

By eHow Computers Editor

0 comments

You can group together all or some of the worksheets in a Microsoft Excel 2007 workbook. The advantage of forming worksheet groups is that you can format the worksheets all at the same time. Keep reading to find out how you can use this ... more »

How to Hide a Column or Row in Excel

By eHow Computers Editor

0 comments

If you have a Microsoft Excel workbook that contains a column or row that you want to hide, you can do this easily. With a few clicks, you can hide this column and row from view. You won't be deleting the column or row, because you can redisplay ... more »

How to Hide an Excel Worksheet so Another User Can’t Unhide It

By Melody

0 comments

There are times when you don’t want other users to see everything in a particular workbook. You don’t want someone else messing around with your formulas or even seeing your source data. So what do you do? You hide a worksheet, and you hide it ... more »

How to Hide Cell Contents in Excel

By eHow Computers Editor

0 comments

Hiding the contents of certain cells can be a great way to quickly hide contents from other users or simply to avoid printing certain cells. The cell content will still exist in the cells, but you will need to redisplay it before you can view the ... more »

How to Identify Repetitive Data in an Excel Table

By Melody

0 comments

The data I work with every day comes from multiple sources. Most often, I spend quite a bit of time formatting to get the data in a usable form. When scrolling through thousands of row looking for repetitive data, it’s easy to miss a few here ... more »

How to Import Data Tables With Dreamweaver

By liberalscribe

0 comments

The job market hasn’t had too much of a need for a web designer who is also an accountant. The two skill sets don’t cross paths too often. There is, however, a need from time to time to import spreadsheet data into a website. This may be a ... more »

How to Insert a Function in an Excel Table

By eHow Computers Editor

0 comments

A function is a written formula written by and stored within Microsoft Excel. These functions make it very easy to insert an already written formula into a selected cell quickly. You easily insert a function into an Excel table using the ... more »

Check Out All Categories

Articles in Spreadsheets