Similar Articles |
|
PC Magazine May 18, 2004 Neil J. Rubenking |
Another Way to Highlight Formulas Expert advice on highlighting cells containing formulas in Excel. |
PC Magazine March 16, 2005 Helen Bradley |
Conditional Formatting in Excel Make the information in your spreadsheets more accessible with formatting based on certain conditions. |
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 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 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 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 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 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 July 12, 2006 |
Conditional Formatting for Plotted Points in Excel Faking conditional formatting for your plots. |
PC Magazine March 1, 2006 |
Default Double-Spacing in Word Configure Microsoft Word 2003 to double-space automatically. |
PC Magazine October 19, 2004 Neil J. Rubenking |
Excel Converts Fractions to Dates How to enter numeric fractions such as 3/16 or 5/9 in Excel, without having them converted to dates such as March 16 and May 9. |
PC Magazine December 1, 2009 Neil J. Rubenking |
Conditional Formatting in Excel Excel's conditional formatting can make spreadsheets a lot easier to interpret - -changing the text color in a cell. |
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. |
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 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 Magazine May 18, 2004 Neil J. Rubenking |
Find, Format, Replace Expert advice on Microsoft Word's Find and Replace for format, not text. |
PC Magazine February 16, 2005 Neil J. Rubenking |
Problem with Excel Time Comparison How to build a formula in Microsoft Excel that produces a different answer based on time. |
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 March 2, 2004 Neil J. Rubenking |
Word Formatting Changes Mysteriously When I select a portion of a document in Word 2002 and apply a formatting command like Indent, Word applies the format to the whole document. How do I stop this from happening? |
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 November 30, 2004 Neil J. Rubenking |
Small Pictures Become Huge Documents in Word A number of readers are mystified by a file-size anomaly in Microsoft Word. |
PC Magazine February 15, 2006 |
Formatted Excel Date Within Text Calculate a date from some cells and then combine it with literal text in another cell. |
PC Magazine October 10, 2007 Neil J. Rubenking |
"Copy Only Subtotals in Excel" Revisited Multiple solutions to the same problem. |
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 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 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 June 1, 2005 Neil J. Rubenking |
Eliminate Formatting in Outlook Or Outlook Express Whether you reply or copy/paste, cleaning up formatting in HTML-based e-mail messages can be tough. Here are some tips. |
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. |
CFO June 15, 2012 Bill Jelen |
Blank Check How to get rid of pivot table blanks without affecting calculations. |
PC Magazine July 13, 2004 M. David Stone |
Controlling Word Formats How to turn off unwanted Word template behavior. |
PC Magazine November 16, 2005 Neil J. Rubenking |
Watch for Registry Changes Even when you use RegEdit, some parasites will reinstate the RegEdit value. Windows XP may be able to trap and catch the code that is preventing complete removal. |
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 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 October 1, 2003 |
Excel's Array Formulas Array formulas are a powerful addition to your Excel toolbox. We show you how to start using them. |
PC Magazine January 20, 2004 Neil J. Rubenking |
Better Averages Without Extremes A better way to calculate the average of a range of cells in a spreadsheet while omitting one or more of the highest or lowest values. |
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 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 August 3, 2004 |
Staying in Style If you happen to like using styles, you'll be happy to learn that Microsoft Word 2003 gives you a way to work more easily with those who tend to ignore them. |
PC Magazine October 10, 2007 Gary Berline |
Excel Tip: Cell Navigation Jump easily from one cell to a non-neighboring cell. |
PC Magazine February 1, 2006 |
Halves, Quarters, Eighths, Sixteenths in Excel Translating units without error in Excel. |
PC Magazine November 2, 2005 Neil J. Rubenking |
Word Document with Linked Excel Data Linking excel data to word documents while maintaining word formatting. |
Macworld March 2001 Jeff Carlson |
Documents to Go Professional Edition Edit Word and Excel Files on Your Palm... |
Chemistry World November 10, 2006 Victoria Gill |
Healing Threads Spun From Living Cells Researchers have successfully made microthreads from polymers containing living cells, using a technique called electrospinning. These biologically active threads could be formed into medical scaffolds, to deliver cells directly to tissue and promote healing. |
PC World May 3, 2001 |
Top 5 Spreadsheet Add-Ins Avoid the pain and tedium of writing Excel formulas... |
CFO May 15, 2012 Bill Jelen |
Keep It Secret How to make sure hidden rows in spreadsheets stay hidden. |
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 August 1, 2007 Neil Rubenking |
Tricky Word Formatting Tips The best way to change formatting in isolated areas of Word documents. |
Chemistry World May 12, 2008 Simon Hadlington |
'Super-yeast' tackles unnatural proteins Researchers in the US have engineered yeast cells to produce large amounts of proteins containing unnatural amino acids (UAAs) - a feat that has previously only been possible with bacteria. |