This group of Excel FAQs (frequently asked questions) gives you background information on various Excel features that will help you understand how these features work.
This article covers how to use ALT - TAB Fast Switching to move between different Excel Files. ALT - TAB Fast Switching is referred to as Windows Flip in Vista.
Formatting a spreadsheet effectively can make the most important information on the spreadsheet stand out from the rest of the data. To accomplish this you can use one of the 17 AutoFormat styles available in Excel to give your spreadsheets a professional look that makes them easy to read.
In Microsoft Excel 2003 it is possible to color code the tabs of worksheets. Changing the color of worksheets tabs containing related information can make it easier to navigate through very . Or to use tab colors to differentiate between sheets containing unrelated information.
It’s a rare occasion when a spreadsheet doesn’t need a change of layout before it is finished. When this happens in Excel, with a click of the mouse you can easily add that extra column or delete those unwanted rows.
The default setting for Excel toolbars is to display them on a single row, thereby hiding many of the toolbar buttons. It is quite easy to change the default settings to show Excel toolbars on two rows, making for a easier time formatting your spreadsheet.
This article shows you how, with a click of the mouse, you can easily delete columns from Excel worksheets.
This article shows you how, with a click of the mouse, you can easily delete rows from Excel worksheets.
This article shows you how, with a click of the mouse, you can easily add columns to Excel worksheets.
This article shows you how, with a click of the mouse, you can easily add rows to an Excel spreadsheets.
The auto fill handle is a very handy feature in Excel. It allows you to quickly add commonly used data. You can customize the lists of data that can be added. This article will show you how.
To quickly copy formatting from one cell or group of cells to another part of the spreadsheet use the format painter in Excel. The format painter icon is on the formatting toolbar and it is very useful when extending a spreadsheet to accommodate new data and need to format the new cells to match the original data area.
This quick tip shows you how to find and show toolbars in Excel. Good for Excel 97 to Excel 2003.
This quick tip shows you how to turn off AutoComplete in Excel 97 - 2003 and in Excel 2007.
This quick tip shows you how to create a named range in Excel. A named range can be used to identify the cells used in charts, functions and formulas. Using named ranges is often easier to use than trying to identify the cell references needed for a formula.
"What if" questions involve changing the data used in Excel formulas to give different answers. Asking "What if" questions are very useful in business when planning new projects. Cost projections for different scenarios can be quickly created and the results compared.
The Undo and Redo commands are wonderful features in Excel spreadsheets. You can undo errors easily or have Excel redo a specific formatting on a different area of the spreadsheet, saving you time.
Excel formulas are one of the most useful features of the program. Formulas can be as simple as adding two numbers or can be complex calculations needed for high end business projections. Once you learn the basic format of creating a formula, Excel does all the calculations for you.
The Chart Wizard in Excel was designed to make the process of creating charts or graphs a very simple procedure. Make choices pertaining to your particular data in four different screens of the Chart Wizard, and your chart is created for you.
Headers and footers are used to add the same information on every page of the spreadsheet without actually typing the information on each page. Headers and footers often contain company information as well as the date, time and filename of the spreadsheet.
Number formatting in Excel spreadsheets is used to change the look of the numbers in the cell. The most common formatting options are currency, comma, date, accounting and percent, although there are more options available.
The Excel SUM function is probably the most often used function in Excel spreadsheets. The AutoSUM button on the Standard toolbar makes it easy to quickly sum columns or rows of adjacent data without actually typing in the cell references.
Microsoft Excel is an electronic spreadsheet program that people use for storing, organizing and manipulating data. The types of data that Excel can use includes numbers, text and formulas. Formulas are used to perform basic mathematical operations, calculating repayment plans for loans or mortgages, and to find the average, maximum, or minimum values in a specified range of data.
What is a spreadsheet program? This article explains what an electronic spreadsheet is, when you might use one, and some of the features common to all spreadsheet programs