| Similar Articles |
|---|
 |
PC Magazine
November 2, 2005
Neil J. Rubenking |
A Better Watermark in Excel How to create the look of a watermark within an Excel worksheet.   |
PC Magazine
August 30, 2006 |
Make Excel Stop Shooting Blanks Sometimes when I print an Excel sheet, I end up with 10 to 12 blank pages following it. Any suggestions? |
PC Magazine
November 14, 2007
Helen Bradley |
Fast Data Entry in Excel Anytime you can enter data without having to type it yourself, you improve accuracy and save yourself effort. There are plenty of opportunities in Excel to enter data in a faster and smarter way than via the keyboard. |
PC Magazine
July 2, 2008
Neil J. Rubenking |
Eight Handy Tools in Excel You Probably Don't Know About These simple features in Excel will smarten up your spreadsheets in no time. |
PC Magazine
August 23, 2005
Neil J. Rubenking |
Automating Page Breaks in Excel In the April 12 issue, your "Row-Based Page Breaks in Excel" article showed one way to create page breaks every row. Here's an Excel macro that automates the process. |
PC Magazine
June 1, 2005
M. David Stone |
Listening to Office You may know you can speak text and commands to Office. But did you know Office can talk back? |
PC Magazine
January 18, 2005
Neil J. Rubenking |
Print a Watermark on Excel Worksheet I often create information in Microsoft Excel 2002 that needs to be used before it is complete. I would like to overlay a message such as "INCOMPLETE" in large text across an entire page. |
PC Magazine
September 7, 2004
Neil J. Rubenking |
Inverted Printing in Word Print left-to-right and right-to-left on the same page. |
PC Magazine
August 17, 2005
Neil J. Rubenking |
Protect Shared Documents I want to protect Microsoft Word and Excel files from any changes when I send them to other people. Is there some way to lock the format and content when I send them to others? |
PC Magazine
August 16, 2006 |
Letterhead Problem In Word Set separate margins set for different pages of a letter. |
PC Magazine
September 14, 2005
Neil J. Rubenking |
Excel's Calendar Control Object How to add Calendar Control 11.0 to your spreadsheet. |
PC Magazine
May 18, 2004
Neil J. Rubenking |
Another Way to Highlight Formulas Expert advice on highlighting cells containing formulas in Excel. |
PC Magazine
April 6, 2004
Helen Bradley |
Better Lists in Excel Excel 2003 offers some useful new tools for working with lists. |
Macworld
March 2001
James Bradbury |
Track Your Progress with Excel Formulas and Graphs Are at Your Fingertips... |
PC Magazine
April 20, 2005
Helen Bradley |
Outlining Your Data Use Excel's Group and Outline feature to view only as much data as you need. |
PC Magazine
April 6, 2004
Neil J. Rubenking |
Fix Excel 2003's RAND Function In December, PC Magazine reader and Excel maven Earl Takasaki brought a curious Excel bug to our attention: The RAND function in Excel 2003 may return negative numbers. |
PC Magazine
November 14, 2007
Sarah Pike |
Excel Tip: Rearrange Data Data is much easier to manipulate when Excel can help with the sorting. |
PC Magazine
January 10, 2007 |
Suppress the Reading Pane for All Outlook Folders Configuring Microsoft Outlook 2003 so it defaults to no reading pane must be made individually for each folder. |
PC Magazine
September 2, 2003
Neil J. Rubenking |
Sort Thousands of Rows Individually You can run a sort operation on each row of an Excel worksheet using a handy function. |
PC World
April 25, 2001
George Campbell |
Sweet Suite Tips Get the most out of Microsoft Office and Corel WordPerfect documents with these tips... |
PC Magazine
May 3, 2006 |
Down with Ugly Excel Charts Customize a default chart in Excel. |
PC Magazine
September 27, 2006 |
Force Unique Numbers in Excel Keep duplicate numbers from being inserted into a column in Microsoft Excel. |
PC Magazine
March 2, 2004
Neil J. Rubenking |
Transform Forced Text to Numbers in Excel One of my clients sends me Microsoft Excel files in which all the columns are in text format, even when they contain only numbers. What is the easiest way to correct the number formatting? |
PC World
October 11, 2002
John Walkenbach |
Who Knew Excel Could Do That? Ten Top Tips Make your spreadsheets work harder and give them a polished look with these nifty tricks. |
PC Magazine
June 2, 2008
Neil J. Rubenking |
Eight Handy Tools in Microsoft Word You Probably Don't Know About Save time and energy by using these easy features in your Word documents. |
PC World
February 21, 2007
Michael S. Lasky |
Six Savvy Ways to Get More Prints for Less Money Increase the efficiency of your printer and extend the page life of your ink cartridges with these sensible strategies. |
PC Magazine
March 6, 2007 |
Analyze Multiple Worksheets in Excel Combine long lists of items from about a dozen different workbooks into one Excel worksheet, without duplicating entries. |
PC World
March 2003
Lincoln Spector |
Answer Line: What Do You Do When Windows Doesn't Boot? Also: nonsensical Windows error messages; add Excel data to a Word file; print later by saving as .prn; transfer Word AutoCorrect settings. |
PC Magazine
March 16, 2004
Neil J. Rubenking |
Count Unique Names in Excel I have a list of some 900,000 names in an Excel worksheet. Most of the names have duplicates. How can I count the number of names without counting duplicate entries? |
PC Magazine
May 4, 2005
Helen Bradley |
Demystifying Excel Macros Writing macros can be a challenge; learn the basics with our example. |
PC Magazine
October 11, 2006 |
Make the Printer Default to Draft How to change default settings for printing. |
PC World
February 2001
George Campbell |
Beautify Documents With Vertical Justification Justify documents vertically, change time formats, replace invisible items... |
PC Magazine
December 30, 2003
Neil J. Rubenking |
Right-Justify Part of a Line Use tab stops to keep text aligned on both sides of your Word document. |
PC Magazine
August 2, 2006
John Brandon |
Get to Know Excel Templates Making sense of data is both the purpose of Microsoft Excel and its challenge. |
PC Magazine
November 14, 2007
Neil J. Rubenking |
Find Unique Rows in Excel Stop searching for new or special entries in Excel by telling the software to how to do the hunting and highlighting for you. |
PC Magazine
January 10, 2007 |
Copy Only Subtotals in Excel A way to copy just the results of a subtotal display to other cells in an Excel spreadsheet. |
PC Magazine
December 9, 2003
Brickley & Cutting |
Automate Long Fills In Excel It's easy to create a macro that takes the hassle out of filling large ranges in Excel. |
PC Magazine
May 17, 2006 |
Excel Filter Problem Resolved Making the count of matching items in Excel using it's Auto-Filter feature appear in the status bar at bottom left. |
PC Magazine
September 12, 2007
Neil J. Rubenking |
Avoid Printer Embarrassment Q: I'm using Microsoft Word from the Office 2000 suite... Can I remove the printer icon when I'm editing a specific file? Or configure Word to warn me before printing?... |
PC World
February 2002
George Campbell |
Word: The Write Stuff Fifteen essential tips for smarter, faster word processing -- no matter which version of Word or WordPerfect you use... |
PC Magazine
August 3, 2004 |
Convert a Tabular Word Document to Excel Is it possible to convert a Word document to an Excel spreadsheet when the Word document has columns of numbers? |
PC World
October 2004
Rebecca Freed |
All Gain, No Pain PC chores don't have to be drudgery. We show you quick and easy ways to complete six essential tasks. |
PC World
February 2003
Scott Dunn |
Windows Tips: Simplify Disk Maintenance With Custom Shortcuts Make ScanDisk and Disk Defragmenter more automatic; tile or cascade windows quickly; print a font sampler. |
PC Magazine
October 10, 2007
Neil J. Rubenking |
"Copy Only Subtotals in Excel" Revisited Multiple solutions to the same problem. |
PC Magazine
January 1, 2008
Neil J. Rubenking |
The Incredible Shrinking Excel Text Excel fonts getting a bit tiny? Here's how to keep them readable. |
PC Magazine
May 31, 2006 |
Pick Lottery Numbers With Excel Using the LARGE() function in Excel. |
PC Magazine
November 16, 2004
Neil J. Rubenking |
Copy Only Values in Excel A simple technique lets you grab just the data from a spreadsheet. |
PC Magazine
December 21, 2005
Helen Bradley |
Exploring Word Toolbars Customize your Word environment with these handy toolbar options. |
PC Magazine
May 18, 2005
Neil J. Rubenking |
Convert Blank Cells to Zeros in Excel In Excel, is there any way to select a range of cells and tell Excel to fill the blank cells with the value zero? |
PC Magazine
May 30, 2007
Neil J. Rubenking |
Curing an Outlook Free/Busy Mixup Solutions to a common Outlook problem. |
