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 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 August 12, 2008 M. David Stone	Those Colors Clash Matching colors between Excel 2007 and Excel 2003.
PC Magazine June 1, 2005 Neil J. Rubenking	Annoying Office Clipboard When I copy cells in Microsoft Excel, after the second copy action in a worksheet the clipboard panel pops up on the right and shrinks the visible portion of my worksheet. How can I disable this feature?
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 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 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 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 Magazine September 4, 2007 Anton Galang	Vista Tip: Copy as Path A new feature of Vista allows users to copy folder paths.
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 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 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?
PC Magazine October 10, 2007 Neil J. Rubenking	"Copy Only Subtotals in Excel" Revisited Multiple solutions to the same problem.
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 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 November 2, 2005 Neil J. Rubenking	Word Document with Linked Excel Data Linking excel data to word documents while maintaining word formatting.
PC Magazine April 18, 2007	Pre-1900 Dates in Excel Sorting dates prior to 1900 in Excel.
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.
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 February 17, 2004 Helen Bradley	Add Images to Excel Projects Put pictures and graphics in your charts to make visual data more compelling.
PC Magazine December 14, 2004 Neil J. Rubenking	Excel's Custom Formats Q: The user wanted to format a cell in Excel so that if its value is positive, it is formatted with the Accounting format and looks like this: "$ 456 "... A: To create your custom format, first format one cell with the Accounting format...
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 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.
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 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 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 November 14, 2007 Sarah Pike	Excel Tip: Rearrange Data Data is much easier to manipulate when Excel can help with the sorting.
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 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 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 May 3, 2006	Down with Ugly Excel Charts Customize a default chart in Excel.
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 October 3, 2001 Jim Welp	Office XP Tips: Selecting Text, Find and Replace XP has some handy editing tricks up its sleeve...
PC Magazine August 3, 2004	Divide and Contact in Outlook Express How to divide a big contact list (about 150 members) into smaller lists in Microsoft Outlook Express.
Home Theater June 17, 2009	Managed Copy Will Be Mandatory in Blu-ray Managed Copy, until now an option in the Blu-ray disc format, will become a requirement next year.
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 May 4, 2005 Neil J. Rubenking	A Better Way to List a Folder's Contents in Word This technique for putting the list of a folder's contents into Word is indeed quite a bit easier than switching to the command prompt, especially if you skip the step of saving the document as a text file. How?
PC Magazine May 18, 2005 Neil J. Rubenking	Advanced Find and Replace in Word The Find and Replace function in Microsoft Word is extremely useful, but I can't always make it work the way I want.
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 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 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 November 2, 2005 Neil J. Rubenking	A Better Watermark in Excel How to create the look of a watermark within an Excel worksheet.
Macworld December 2001 Joseph Schorr	Mesa 3 Mesa 3, a full-blown spreadsheet program for OS X, lets you build a budget, map out complex statistical data, and produce presentation-quality reports. But how does Mesa measure up to Microsoft Excel when it comes to slicing and dicing your numeric data? Not very well, unfortunately...
PC Magazine September 4, 2007 Neil Rubenking	Renaming Excel Rows and Columns Excel can optionally number the columns instead of lettering them.
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 November 30, 2004 Neil J. Rubenking	Putting the List of a Folder's Contents into Word A little command-prompt magic saves you from copying individual filenames.
PC Magazine October 11, 2006	Flashing Text in Excel Make flash animation in 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 February 14, 2007	Misbehaving Copy and Paste Tweaking the copy and paste options in Microsoft Word.