|
|
|
|
 |
Welcome to 123XLSX.com's Tips for using Microsoft Excel 2000 section.
Because there have been several releases of Microsoft Excel over the years with differing menu, ribbon, functionality and features. In an effort to help you make the most out of your version of Microsoft Excel, we have compiled a list of Tips and Tricks into several categories which are listed in the right hand menu.
To find tips which will help you get the most out of Microsoft Excel and improve your efficiency in creating documents and publications, select the category that applies to your version of Microsoft Excel.
If you have any further questions concerning Microsoft Excel, working with Excel spreadsheets, Excel macros or Excel Dashboard Reports or would like to learn more about 123XLSX.com, out products and services, please contact our Customer Services Department. Our service and support staff are on hand to assist you with any and all questions that you might have.
Questions from across all categories include:
|
 |
|
|
|
| How can I copy and paste Formulas from a range of cells without changing absolute or relative references using Microsoft Excel 2000? |
|
|
|
|
|
To copy and paste Formulas from a range of cells without changing absolute or relative references using Microsoft Excel 2000:- Select the range of cells containing the formulas and press Ctrl while holding down the H key.
- In the Find what box, type the .= sign.
- In the Replace with box, type the # sign to change the formulas to text.
- Click Replace All and then click Close.
- Copy and paste the selected cells to the new location.
- Repeat steps 1 through 3, reversing the # and = signs to change the text to formulas.
- Excel copies and pastes your selected formulas from the range of selected cells without changing absolute or relative references.
|
|
|
|
|
|
| How can I enter the current time into a workbook cell using Excel 2000? |
|
|
|
|
|
To automatically get the current time in a workbook cell using Microsoft Excel 2000:
- Select a cell in your workbook and press CTRL while holding down the SHIFT key.
- In the formula field enter =NOW ().
- To get a formula that calculates the current time, right mouse click the cell and select Format.
- Change the format of the cell containing the NOW formula to h:mm in the Type box.
- Click OK. Excel applies the current time to the cell with the selected time format settings..
|
|
|
|
|
|
| How can I set the default chart type using Microsoft Excel 2000? |
|
|
|
|
|
To set the default chart type using Microsoft Word 2000:
- Select a chart sheet or select an embedded chart.
- Right mouse click on chart.
- From the Chart menu select the chart type you want from the list.
- Click Set as default chart.
- Click OK. Excel sets the chart type as the default chart.
|
|
|
|
|
|
|
|
|
