NEWS
BYTES
December 1999
Editor:
Scott Gottlieb, CPA
Assistant editor: Susan A. Maffetone, CPA
Highlighting
Excel Features
Make
a Copy That Excludes Hidden Cells in Excel 2000
When
outlining or subtotals to create a small summary of a large
set of data, you can make a copy of just the displayed cells
in the summary, excluding the detail.
First display only the summary rows or columns, and then select
all of the summary data.
On the Edit menu, click Go To, click Special, and then click
Visible cells only.
Now click the Copy button, click a cell on a blank worksheet,
and click the Paste button.
The copy includes only the summary data.
Calculate
the Amount of Time Between Two Dates in Excel 97/2000
You can simply subtract the two dates.
For example, if cell A1 contains the date 6/8/2000 and A2 contains
6/20/2000, the formula =A2-A1 calculates the number of days
between these dates (12). Be sure to use number format for the
cell where you enter this formula (click Cells on the Format
menu, click the Number tab, and then click Number under Category).
If you don't format the cell with number format, Excel assumes
the result has the same format as the cells used in the calculation,
and displays the result as a date instead of a number.
And
don’t forget to add this to your bookmark or favorites
menu to help you in visiting us monthly.
Other
issues of NewsBytes see our archives
.
