Spreadsheets

Articles in Spreadsheets

By triciagoss 0 comments
You can make your Excel spreadsheet look much more professional by adding headers and footers. One way to make your header or footer really stand out is by inserting a graphic. Here’s how!.. more »
By Faith Lawless 0 comments
If you are responsible for putting together an Excel document for your company, there is a great way to spruce it up by adding the company logo to the header or footer. It’s very easy to do and in the end it may impress your boss too... more »
By eHow Computers Editor 0 comments
By inserting hyperlinks into Microsoft Excel, you can link documents on your hard drive, web pages and other spreadsheets to your excel document. Hyperlinks are also a great way to cite the source of data. Once you know how to insert hyperlinks, ... more »
By eHow Computers Editor 0 comments
Microsoft Excel has many excellent features that enable a user to make their mathematical and financial calculations with ease. Some issues arise that the basic functions of Excel cannot optimize. This is where the Excel solver add-in comes in. ... more »
By dahawe 0 comments
In my recent article, How to Create a Simple Macro In Excel, I outlined the steps to automate a repetitive task. The problem is, sometimes it is hard to recall the key that you set up to activate it. This article shows how to create a new button ... more »
By eHow Computers Editor 0 comments
When you copy and paste a formula to a new location in a Microsoft Excel 2007 workbook, then it will change that formula to refer to the current column or row. You can make the cell reference absolute so Excel does not change the cell reference ... more »
By eHow Computers Editor 0 comments
Spreadsheets are handy programs to have. You can use them to for an address book, check registers, budgets and to keep track of work you do. They are handier than word processors since you can easily add or rearrange columns and rows. Follow the ... more »
By eHow Computers Editor 0 comments
Microsoft Excel is an easy program to use to make time lines. Excel allows users to create, edit, personalize, save and print whatever kind of time line you need. Time lines make helpful study aides for students and are useful in business meetings... more »
By triciagoss 0 comments
A watermark can be added to a document to add security, specify information or simply give the document a more polished and professional appearance. While you cannot create an actual watermark in Excel, you can mimic a watermark with a graphic ... more »
By eHow Computers Editor 0 comments
Range names are a name that you have previously assigned a group of cells in Microsoft Excel 2007. If you have several range names in your workbook, you will want to manage those names so you can easily add, filter, edit or delete those range ... more »
By eHow Computers Editor 0 comments
You can create workbooks for almost any need and Excel makes it easy. Say you have made a workbook in Excel for your boss and now he wants it modified. You now have to add more columns and rows, additional data, and change many other items. It ... more »
By eHow Computers Editor 0 comments
Worksheets and workbooks are two different things in Excel. A workbook is a file made up of worksheets. A worksheet is a spreadsheet. It's like having a notebook for any subject--one page is a worksheet--all the pages are a workbook. To modify a ... more »
By alexleeyy 0 comments
For instance, we have finished a EXCEL workbook,but want to modify the one (colum), such as: we want to add each data in colum A plus 8, on this issue, we naturally think of the use of the formula, when you use the input A1 = A1 +8, you will get ... more »
By triciagoss 0 comments
The Microsoft Office Assistant can be a very handy tool. The Office Assistant offers tips, advice and help all while looking very cute! These steps will show you how to modify your Office Assistant... more »
By eHow Computers Editor 0 comments
After you have created a chart in Microsoft Excel 2007, it will be placed in the middle of the workbook you used to create it. You will most likely want to move this chart to another location in your workbook. Find out how you can move a chart in ... more »
By eHow Computers Editor 0 comments
You often create worksheets--or spreadsheets--and then find that you want the data displayed in a different way. You could create a new worksheet in the format you want; alternatively you can move the data around until you get the desired effect. ... more »
By eHow Computers Editor 0 comments
When you are editing an Excel spreadsheet, you may want to move information inside your Excel spreadsheet to a different location within the same spreadsheet. You can do this by either moving the content of a cell or multiple cells or moving a ... more »
By eHow Computers Editor 0 comments
Excel is an electronic spreadsheet application that has been designed as a tool for analyzing data. It can be used to perform simple tasks and complex calculations. There are several methods for performing calculations in Excel... more »
By eHow Computers Editor 0 comments
Once the magic of Excel spreadsheets is uncovered, it's hard to imagine living without it. Just about any kind of data can be stored in a workbook and manipulated to suit any need. Calculations that once took several minutes to complete by hand ... more »
By Melody 0 comments
People, I call on you to lay down your mouses … or mice rather, and take up the keyboard! Operate more efficiently, save time, and even amaze your friends and cube mates with these tricks. Actually, performing any of these actions may not ... more »
By eHow Computers Editor 0 comments
When you copy data from some sources into a spreadsheet, it will put all the data in the same cell rather than putting each word into separate cells. You need to know what to do with this data in order to get into columns. This is when you will ... more »
By eHow Computers Editor 0 comments
Before you print your Microsoft Excel spreadsheet, it is important that you preview what the spreadsheet will look like once it is printed. By using "Print Preview" you can see what the spreadsheet will look like printed and be able to make some ... more »
By chinne01 0 comments
Sometimes Excel can be a bit tricky for those who are not used to it. Because of the way that Excel is programmed, you can find yourself one click away from an error message... more »
By eHow Computers Editor 0 comments
Microsoft Office's program Excel comes bundled in Office Suite or as a stand-alone software product. It's a powerful spreadsheet program used mainly in business. Excel spreadsheets have several basic print options in all versions of the program... more »
By eHow Computers Editor 0 comments
There will be times when you need to display only a portion of your Excel 2003 spreadsheet to make your point. Follow these steps to print selected areas of your spreadsheet... more »