MagPortal.com   Clustify - document clustering
 Home  |  Newsletter  |  My Articles  |  My Account  |  Help 
Similar Articles
PC Magazine
May 18, 2004
Neil J. Rubenking
Another Way to Highlight Formulas Expert advice on highlighting cells containing formulas in Excel. mark for My Articles similar articles
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. mark for My Articles similar articles
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. mark for My Articles similar articles
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? mark for My Articles similar articles
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? mark for My Articles similar articles
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. mark for My Articles 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. mark for My Articles similar articles
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. mark for My Articles similar articles
PC Magazine
July 12, 2006
Conditional Formatting for Plotted Points in Excel Faking conditional formatting for your plots. mark for My Articles similar articles
PC Magazine
March 1, 2006
Default Double-Spacing in Word Configure Microsoft Word 2003 to double-space automatically. mark for My Articles similar articles
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. mark for My Articles similar articles
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. mark for My Articles similar articles
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. mark for My Articles similar articles
CFO
April 15, 2012
Bill Jelen
A Global Shift (of Decimals) How to move the decimal point in an array of Excel data. mark for My Articles similar articles
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. mark for My Articles similar articles
PC Magazine
May 18, 2004
Neil J. Rubenking
Find, Format, Replace Expert advice on Microsoft Word's Find and Replace for format, not text. mark for My Articles similar articles
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. mark for My Articles similar articles
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. mark for My Articles similar articles
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? mark for My Articles similar articles
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? mark for My Articles similar articles
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. mark for My Articles similar articles
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. mark for My Articles similar articles
PC Magazine
October 10, 2007
Neil J. Rubenking
"Copy Only Subtotals in Excel" Revisited Multiple solutions to the same problem. mark for My Articles similar articles
Macworld
March 2001
James Bradbury
Track Your Progress with Excel Formulas and Graphs Are at Your Fingertips... mark for My Articles similar articles
PC Magazine
November 30, 2005
Edward Mendelson
Office Problems, Solved! Some of the most notorious problems and the most useful tricks with Microsoft office. mark for My Articles similar articles
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. mark for My Articles similar articles
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. mark for My Articles similar articles
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. mark for My Articles similar articles
PC World
April 25, 2001
George Campbell
Sweet Suite Tips Get the most out of Microsoft Office and Corel WordPerfect documents with these tips... mark for My Articles similar articles
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. mark for My Articles similar articles
CFO
June 15, 2012
Bill Jelen
Blank Check How to get rid of pivot table blanks without affecting calculations. mark for My Articles similar articles
PC Magazine
July 13, 2004
M. David Stone
Controlling Word Formats How to turn off unwanted Word template behavior. mark for My Articles similar articles
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. mark for My Articles similar articles
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... mark for My Articles similar articles
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? mark for My Articles similar articles
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. mark for My Articles similar articles
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. mark for My Articles similar articles
PC Magazine
September 7, 2004
Neil J. Rubenking
Inverted Printing in Word Print left-to-right and right-to-left on the same page. mark for My Articles similar articles
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. mark for My Articles similar articles
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. mark for My Articles similar articles
PC Magazine
October 10, 2007
Gary Berline
Excel Tip: Cell Navigation Jump easily from one cell to a non-neighboring cell. mark for My Articles similar articles
PC Magazine
February 1, 2006
Halves, Quarters, Eighths, Sixteenths in Excel Translating units without error in Excel. mark for My Articles similar articles
PC Magazine
November 2, 2005
Neil J. Rubenking
Word Document with Linked Excel Data Linking excel data to word documents while maintaining word formatting. mark for My Articles similar articles
Macworld
March 2001
Jeff Carlson
Documents to Go Professional Edition Edit Word and Excel Files on Your Palm... mark for My Articles similar articles
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. mark for My Articles similar articles
PC World
May 3, 2001
Top 5 Spreadsheet Add-Ins Avoid the pain and tedium of writing Excel formulas... mark for My Articles similar articles
CFO
May 15, 2012
Bill Jelen
Keep It Secret How to make sure hidden rows in spreadsheets stay hidden. mark for My Articles similar articles
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. mark for My Articles similar articles
PC Magazine
August 1, 2007
Neil Rubenking
Tricky Word Formatting Tips The best way to change formatting in isolated areas of Word documents. mark for My Articles similar articles
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. mark for My Articles similar articles