PC World Help Screen

Click on a category to see Help Screen articles, most recent first

Accounting
Bugs and fixes
Communications
Data management
Digital Helpline
General
Hardware
Internet
Linux
Macintosh
Multimedia
Networking
newbie
OS/2
Publishing and presentation
* Spreadsheet *
Viruses
Windows 9x
Windows 3.x
Windows Manager
Windows NT
Word processing

Closing All Workbooks August 2000
Restrict Cursor Movement to Unprotected Cells August 2000
Excel Charts:The Layout of the Land August 2000
Too Many Sheets? July 2000
Colour Marks the Spot July 2000
Display a Worksheet Name July 2000
Display Multiple Charts on a Single Chart Sheet July 2000
Avoid Error Displays June 2000
Unlink a chart series from its data range June 2000
Surprise, surprise! Excel can handle fractions June 2000
Zap input cells, keep formulas May 2000
To AutoSave or not to AutoSave? May 2000
Change the formatting of cell comments May 2000
Round values to the nearest fraction May 2000
Prevent row or column insertion April 2000
Referencing a sheet indirectly April 2000
Add graphics to your page header April 2000
Display thousands without zeros March 2000
Share your spreadsheets on the Web March 2000
Count autofiltered rows January 2000
Activate Cells Used in Formulas January 2000
Count Them: Four Ways to Protect Your Numbers January 2000
Sum the highest values in a range December 1999
Print selected rows in 1-2-3 November 1999
Check for repeating values in a range November 1999
Add formatting pizazz to your worksheets November 1999
Picking up where you left off October 1999
Calculating rental fees October 1999
Worried over Y2K? Now here's a Y1.9K problem October 1999
Make your dates Y2K-ready September 1999
A useful circular reference in 1-2-3 September 1999
Zap hyperlinks in Excel 2000 September 1999
Importing text is easier than ever in Excel 2000 September 1999
How to create a time sheet in Excel August 1999
Extend the power of Excel with add-ins July 1999
Really hide an Excel worksheet June 1999
Automatic list numbering June 1999
How many days are left? June 1999
Thermometer-style graphs made easy June 1999
Text and values in one cell May1999
Conditional Averages May1999
Create a linked picture May1999
Copy page setup April 1999
Sharing Shortcuts April 1999
Duplicate values in an Excel list April 1999
Too many Favorites, too little time March 1999
Alternate row shading March 1999
Lock a single cell March 1999
Display AutoFilter criteria in Excel March 1999
Countless methods for counting with Excel February 1999
The keys to dialogue boxes January 1999
How many days in the month? January 1999
When @Vlookup won't work December 1998
Navigate Excel's sheets December 1998
Round numbers December 1998
Eradicate dead links December 1998
Store custom formats in an Excel template December 1998
Create a drop-down list of possible input values November 1998
Use dummy arguments in Excel November 1998
Calculate the difference between two dates in Excel November 1998
Plagued by the Laroux virus? October 1998
Year 2000 spreadsheet resources October 1998
Convert imported values to actual values October 1998
A bug in 1-2-3? October 1998
Run old macros in Excel 97 October 1998
Join text from multiple cells September 1998
Negative time in Excel September 1998
Print a file's path in an Excel header or footer September 1998
Excel's vanishing page breaks September 1998
Spot formula errors August 1998
Hide sensitive cells August 1998
Formulate charts directly in a range August 1998
Copy Word tables to Excel July 1998
More on cell merging in Excel 97 July 1998
Merging vs centring across selection July 1998
Create a custom function to sort by cell formats July 1998
Check out spreadsheet templates June 1998
A better way to count words June 1998
Stop files from opening automatically June 1998
Put your spreadsheet on a company Web page June 1998
Locate the last cell May 1998
Simplify subscript and superscript formatting May 1998
Chart an expanding range in all versions of excel May 1998
Protect formulas and data by hiding them Apr 1998
Getting answers on the Net Apr 1998
Deleting empty worksheet rows Mar 1998
Changing values without using formulas Mar 1998
Drop zeros from averages Mar 1998
Sorting Excel dates Feb 1998
Gantt charts in Excel Feb 1998
Count words in a cell Feb 1998
Shrinking 1-2-3 Release 97's InfoBox Feb 1998
Rid Excel worksheets of outdated links Jan 1998
Moving a sheet in 1-2-3 97 Jan 1998
Inserting special characters Jan 1998
Speed Office 97 by turning off file logging Nov 1997
Delete all empty rows in a flash Nov 1997
Suppressing 1-2-3's splash screen Nov 1997
Fix messed-up menus in Excel 97 Nov 1997
Create automatic worksheet and graph title Oct 1997
Close all Excel workbooks in one step Oct 1997
Printing more than one range on a page Oct 1997
Copying formulas - oops Sep 1997
From Quicken to spreadsheet Sep 1997
Turn your worksheet sideways in 1-2-3 Sep 1997
Excel 97 hyperlinks tame large worksheets Aug 1997
Excel 97 bug update Jul 1997
Print data from two sheets on one page Jul 1997
Lost Excel passwords Jun 1997
Working with pivot tables Jun 1997
Link formulas to Web data in Quattro Pro 7.0 Apr 1997
Combo line and bar charts in Excel Apr 1997
Quick access to specific parts of large documents Apr 1997
Sort protection unavailable Apr 1997
Saving the print area setting for a workbook Apr 1997
Saving iteration information in Excel Apr 1997
Forcing new lines in workbook cells Mar 1997
Sum cumulatively in any spreadsheet Mar 1997
Clock time intervals Feb 1997
Using Excel's debug window to learn VBA Feb 1997
Timeline charts in 1-2-3 and Excel Feb 1997
Printing more than one range on a page Dec 1996
How to get copied formulas to work Dec 1996
Display the right date in Excel Dec 1996
Calculating dates, displaying minimums Nov 1996
Recording sheet names in Excel worksheets Nov 1996
Can't shift nonblank cells in Excel Nov 1996
Quicken, Excel and desktop drags Oct 1996
What counts in Excel Oct 1996
Off-line Netscape and adding Excel dates Sep 1996

Browse HelpScreen files from "August 95 to August 96"

Back to Help Screen Page