Similar Articles

Browse Main Topics:

Business
Computers & Electronics
Education & Reference
Entertainment & Leisure
Family & Home
Finance & Investment
Health
Internet
Pets & Animals
Science & Technology
Society, Politics & Culture
Sports & Recreation

Similar Articles

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 Magazine December 20, 2006	Excel Color-Coding for the Color-Blind An Excel macro to use only colors a color-blind person can differentiate.
PC Magazine May 4, 2005 Helen Bradley	Demystifying Excel Macros Writing macros can be a challenge; learn the basics with our example.
PC Magazine May 18, 2004 Neil J. Rubenking	Another Way to Highlight Formulas Expert advice on highlighting cells containing formulas in Excel.
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 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 1, 2008 Edward Mendelson	Word Macros: Beyond the Basics Once you've begun recording and using Microsoft Word macros, you may encounter keyboard and mouse actions that don't translate into working macros.
PC Magazine January 31, 2007	Recheck Spelling in Word A computer won't automatically ignore you when you say "ignore all," but you can create a macro so that it will.
PC Magazine April 19, 2006	Blinking Labels In Access Write your own Visual Basic code to use this outdated text property.
PC Magazine May 16, 2007	How Excel Formulas Can Reference Comments How to carry non-cell data from one Excel worksheet to another.
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 14, 2005 Neil J. Rubenking	Excel's Calendar Control Object How to add Calendar Control 11.0 to your spreadsheet.
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 April 20, 2004 Helen Bradley	Conditionally Executing Macro This Excel code will run properly even when the value in a cell is greater than zero.
PC World June 2005 Michael S. Lasky	Take the Drudgery Out of Typing, via AutoCorrect Microsoft calls the AutoCorrect function in Office 2000 and later the proofreader over your shoulder... The Non-Macro 'Macro'...
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 August 17, 2005 Neil J. Rubenking	Excel Times Two I have a two-monitor system. It should be like Internet Explorer or Microsoft Word, where you can have multiple windows open at the same time. Is this option available in Excel?
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 April 18, 2007	Pre-1900 Dates in Excel Sorting dates prior to 1900 in Excel.
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 October 11, 2006	Whip a Recorded Macro into Shape Making Word Macro do what you want.
PC Magazine August 13, 2008 Sarah Pike	Troubleshooting Word Macros Fixing macros that are stuck or not executing.
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 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 November 2, 2005 Neil J. Rubenking	Word Document with Linked Excel Data Linking excel data to word documents while maintaining word formatting.
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 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 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 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 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 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.
Macworld March 2001 James Bradbury	Track Your Progress with Excel Formulas and Graphs Are at Your Fingertips...
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 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 September 4, 2007 Neil Rubenking	Renaming Excel Rows and Columns Excel can optionally number the columns instead of lettering them.
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 September 7, 2004 Neil J. Rubenking	Inverted Printing in Word Print left-to-right and right-to-left on the same page.
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 13, 2005 Helen Bradley	Declaring Variables in Excel All variables in Visual Basic must be set with a DIM statement or you will get an error. To make the example work, you need to add the following statements.
PC Magazine June 20, 2007	Setting Up Indent Styles in MS Word The easiest way to custom set the indent features in Microsoft Word.
PC Magazine January 18, 2006 M. David Stone	Changing the Format for Inserting Photos Insert photos into Microsoft Word already formatted the way you like them.
PC Magazine November 25, 2003	Text That Doesn't Print Use a special font option in Word to make text appear on the screen but disappear when the document is printed.
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 September 27, 2006	Force Unique Numbers in Excel Keep duplicate numbers from being inserted into a column in Microsoft Excel.
PC Magazine November 25, 2003	Joining Columns that Include Dates Our Excel merge tip works with any two columns of data, but the formula changes a bit when you're working with dates.
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 13, 2005 Neil J. Rubenking	Custom Highlight Colors in Word I review detailed medical documents and like to highlight important sections with different colors. Is there a way to change the shades of the highlight colors in Word 2003?
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 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 May 21, 2009 Ben Z. Gottesman	Beyond Numbers: Manipulating Text in Excel Excel is great for crunching numbers, but it's also a simple database solution for many. Luckily, with a few handy formulas, Excel can learn to crunch your alpha-bits too.