Similar Articles |
|
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 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 April 4, 2008 Sarah Pike |
Copying Multiple Paragraphs into One Cell There's an easy way to avoid having paragraph breaks split text among cells in Excel. |
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 November 28, 2007 Kyle Monson |
Adding Thousands Separators in Word In Microsoft Excel we can format numbers so they display using the thousands separator for accounting or currency. |
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 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. |
Macworld August 17, 2007 Jeffery Battersby |
Pages '08 Apple's new Pages '08 is a very good word processing and page layout program with dozens of new features and enhancements, but, it is still missing key features -- and has one bug that may prevent you from taking the plunge. |
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 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 November 30, 2004 Neil J. Rubenking |
Ampersands in Excel Headers Here's the trick for inserting characters that double as control codes in the Microsoft spreadsheet. |
PC Magazine February 8, 2008 Neil J. Rubenking |
Turn Excel Data and Charts into JPEGs Create figures or a movie from Excel charts. |
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 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 November 1, 2006 |
A Sorting Problem in Word Organizing your text so Word can sort it properly. |
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 11, 2007 Neil J. Rubenking |
Automating Paste Unformatted in Word 2003 An old but favorite keyboard shortcut and how to custom build it. |
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? |
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 November 14, 2007 Sarah Pike |
Word Tip: Rearrange Data Convert text to a table and sort through your data more efficiently. |
PC Magazine February 3, 2004 Neil J. Rubenking |
Mail Merge Formatting Problem I prepare bills using Office XP. An Excel spreadsheet serves as my database, and I use Word's Mail Merge feature to print the bills. |
PC Magazine February 14, 2007 |
Misbehaving Copy and Paste Tweaking the copy and paste options in Microsoft Word. |
Macworld May 15, 2007 Kirk McElhearn |
Ulysses 1.5 The best way to look at this program is through the eyes of those who work with text alone and don't necessarily need any kind of formatting. |
PC Magazine August 1, 2007 Neil Rubenking |
Tricky Word Formatting Tips The best way to change formatting in isolated areas of Word documents. |
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 October 11, 2006 |
Left- and Right-Align on One Line I use Microsoft Word from Office XP. I would like to know how I can left-align and right-align separate pieces of text in the same sentence; for instance, in a resume. |
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 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 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 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 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? |
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 World July 13, 2007 Michael Lasky |
Supercharge Acrobat Reader Customize your PDF viewer to make it work better for you. |
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 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. |
CFO May 15, 2012 Bill Jelen |
Keep It Secret How to make sure hidden rows in spreadsheets stay hidden. |
PC Magazine October 11, 2006 |
Flashing Text in Excel Make flash animation in Excel. |
CFO December 1, 2010 Marie Leone |
Total Trouble The older generation of Excel users remembers how potentially dangerous this Microsoft snag can be. |
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 18, 2007 |
Replace Formatting With Codes How to find and replace hidden HTML code. |
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 June 20, 2007 |
Save Time With Heading Functions in Excel Making custom applications for Excel is easier than you think. Read on to learn how. |
PC World January 3, 2007 Christopher Null |
DataViz Documents To Go Premium Edition 9 This suite is the best way to edit files on your Palm, but the latest version adds few new tricks. |
Linux Journal April 13, 2006 Bruce Byfield |
OOo Off the Wall: Combining Documents with OOo Before you ask for a Reveal Codes feature in OpenOffice.org Writer like the one in WordPerfect, try learning how to use the tools already offered in Writer. |
PC Magazine September 4, 2007 Neil Rubenking |
Renaming Excel Rows and Columns Excel can optionally number the columns instead of lettering them. |
PC Magazine January 20, 2009 Edward Mendelson |
iWork '09 iWork '09 gives Apple a lot to boast about. The new version easily outclasses Microsoft Office as the suite of choice for home, student, and some, but certainly not all, business users. |
PC Magazine May 4, 2004 |
Microsoft Office: 106 Tips & Tricks With every version of the Microsoft Office suite, Microsoft refines an already mature set of applications and adds many handy features. |
PC Magazine November 29, 2006 |
Word Won't Check Spelling If Word won't spell-check text, either the text itself is defined as the wrong language or you've accidentally told Word not to spell-check it. |
PC Magazine August 12, 2008 M. David Stone |
Those Colors Clash Matching colors between Excel 2007 and Excel 2003. |
PC Magazine June 21, 2006 |
Deleting Duplicate Rows In Excel In Excel, how do I delete rows that are duplicates -- that is, rows that match in multiple columns like Last Name, First Name, House Number, and Street Name? |