Similar Articles |
|
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 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 February 17, 2004 Neil J. Rubenking |
Save a Multipage Image in Excel What do you do when you want to grab a screen image, but some of the data you want is off-screen? |
Macworld August 16, 2007 Rob Griffiths |
Numbers '08 Numbers '08 is a strong entry for Apple in the spreadsheet arena, especially for those who find Excel's feature set overwhelming. |
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 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. |
Macworld March 2001 James Bradbury |
Track Your Progress with Excel Formulas and Graphs Are at Your Fingertips... |
PC Magazine November 30, 2005 Edward Mendelson |
Office Problems, Solved! Some of the most notorious problems and the most useful tricks with Microsoft office. |
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? |
Macworld July 18, 2007 Greg Miller |
Live Interior 3D 1.2 This 3-D interior design program is aimed at consumers who want to refurnish or remodel a room, office, kitchen, or other interior space. |
PC Magazine May 30, 2007 Helen Bradley |
Design Your House Designing a house is easier than you think. With new software from companies like Punch Software you can design your own home. |
PC Magazine August 23, 2005 Ben Z. Gottesman |
Finding Hidden Columns in Excel I somehow lost several of the leftmost columns in a Microsoft Excel spreadsheet and have been unable to make them visible again. How can I get these lost columns back? |
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 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 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 February 1, 2006 |
Halves, Quarters, Eighths, Sixteenths in Excel Translating units without error in Excel. |
This Old House December 2006 Amy R. Hughes |
French Doors with Vintage Flair Bring the outside in and create breezy transitions between interior rooms with old windowed doors. |
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 January 12, 2005 Neil J. Rubenking |
Mysterious Four-Year Error in Excel I have an Excel 2002 workbook with records from the past ten years. |
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 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 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 September 26, 2007 Helen Bradley |
Give Your Charts a Makeover Sift through the pages of The New York Times and you'll notice that the charts used to illustrate the stories don't look like typical Excel offerings. |
This Old House C.J. Hughes |
Old House, New Space When this family outgrew their home, they decided to add on rather than move on -- improving the place's awkward floor plans in the process. |
PC Magazine January 31, 2007 Helen Bradley |
Introducing Excel 2007 Along with its new interface, Microsoft Excel 2007 offers several subtle improvements to those spreadsheet tools you use every day. |
PC Magazine September 21, 2004 |
A Subtle Bug in Excel Pivot Tables A reader discovers an unusual Excel 2003 flaw, and we have a demonstration. |
This Old House Megan Baker |
Why Barns are Red and More Paint Color Cues The stories behind certain hues associated with the American landscape. |
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 November 16, 2005 Mendelson & Dragan |
Microsoft Office 12 Beta 1: Extreme Makeover Office 12 will be the biggest update to Microsoft's flagship office suite in ten years. Find out just how big the changes will be. |
PC Magazine December 22, 2004 M. David Stone |
Exploring Document Properties Take advantage of a little-known Word feature to make dealing with files much easier. |
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 Magazine August 3, 2004 |
Counting Unique Names in Excel, Reloaded How to count unique names in excel using pivot tables. |
National Gardening |
Landscaping 101 We wish we could tell you that creating a landscape was a sure-fire proposition, as easy as "one-two-three." The truth is that home landscaping that really works and pleases its owners is the product of a fair amount of time and attention. |
PC Magazine November 16, 2005 Neil J. Rubenking |
Import Over 256 Columns in Excel How to a list of more than 256 items into excel. |
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. |
This Old House Tom Peterson |
Grand Prize Winners: Search for America's Best Remodel 2014 How did one of your fellow readers earn our awe -- and a $5,000 prize? Well, first he had to "retire" so he could work on the house full-time. |
PC Magazine December 29, 2005 Mendelson & Dragen |
StarOffice 8.0 StarOffice 8.0 has everything you need to make the break from Microsoft Office... Openoffice.org 2.0... Microsoft Office 12... Microsoft Word 12... Microsoft Excel 12... Microsoft Outlook 12... Microsoft PowerPoint 12... Microsoft Access 12... etc. |
PC Magazine May 18, 2004 Neil J. Rubenking |
Another Way to Highlight Formulas Expert advice on highlighting cells containing formulas in Excel. |
This Old House Pete Goode |
Screening Rooms Screened porches don't have to be ordinary, as these three distinctive designs demonstrate. |
The Motley Fool June 16, 2010 Nathan Alderman |
Beat Back the Budget Beast! This handy spreadsheet can help you keep your money in line. |
The Motley Fool June 8, 2010 Nathan Alderman |
Make Your Checkbook Work for You Hate math? This easy, automated checkbook crunches numbers for you. |
CFO April 15, 2012 Bill Jelen |
A Global Shift (of Decimals) How to move the decimal point in an array of Excel data. |
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? |
Macworld January 2001 Tom Negrino |
Get It Together Take Charge of Your Life with Microsoft Office 2001's New Suite of Programs... |
PC Magazine October 10, 2007 Gary Berline |
Excel Tip: Cell Navigation Jump easily from one cell to a non-neighboring cell. |
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? |
This Old House Josh Garskof |
Simple Kitchen Makeovers You don't have to start over to give your kitchen a face-lift. Here's a rundown of options for simple upgrades. |
PC Magazine April 6, 2004 Helen Bradley |
Better Lists in Excel Excel 2003 offers some useful new tools for working with lists. |
PC Magazine June 1, 2008 Neil J. Rubenking |
Easy Date and Time Entry in Excel Cut down data entry time in a flash with handy Excel tricks. |
PC World July 25, 2006 Robert Luhn |
78 Ways to Make Software Do More With these tips and tools, your everyday applications -- from Office to IE, Firefox to ZoneAlarm -- can become faster, more powerful, and easier to use. |