Similar Articles |
|
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. |
PC Magazine March 16, 2005 Neil J. Rubenking |
Row-Based Page Breaks in Excel I have extracted information from a database that now forms extremely long lists in Excel. |
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 11, 2006 |
Make the Printer Default to Draft How to change default settings for printing. |
PC Magazine February 1, 2010 M. David Stone |
Repeat Rows and Columns in Multipage Excel Documents If your Excel table is longer than one page, it's often helpful to repeat the header row at the top of every page. |
PC World February 21, 2007 Michael S. Lasky |
Six Savvy Ways to Get More Prints for Less Money Increase the efficiency of your printer and extend the page life of your ink cartridges with these sensible strategies. |
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 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 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 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 April 20, 2005 Neil J. Rubenking |
Insert Alternate Blank Rows in Excel I have an Excel report that fills about 1,000 rows. I want to insert a blank row between each of these rows. Obviously, I know how to insert a row one at a time, but is there a quicker way to do this? |
PC Magazine September 12, 2007 Neil J. Rubenking |
Avoid Printer Embarrassment Q: I'm using Microsoft Word from the Office 2000 suite... Can I remove the printer icon when I'm editing a specific file? Or configure Word to warn me before printing?... |
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 April 6, 2005 M. David Stone |
Partial Label Pages Printing partial page of labels in Word 2003. |
PC Magazine April 5, 2006 |
What To Do With PRN Files Unless you have access to the printer the file was referenced to, or an identical one, there's not much you can do with the PRN file. |
Information Today May 30, 2013 |
Ingram Expands Publisher Services With Life Print Program Ingram Content Group, Inc. announced the launch of its Life Print program, a comprehensive solution for publishers to manage the complete life cycle of print books. |
PC World October 2002 Scott Dunn |
Windows Tips: Quick and Easy Ways to Master Windows Printing Print faster and smarter by tweaking Windows' printer settings; get more control over the Windows print queue. |
PC Magazine February 3, 2004 Bruce Brown |
Panasonic KX-P7305 If you're truly on a tight budget, why would you even consider the most expensive of eight printers, all of which deliver roughly equal quality output, especially one slower than most others on our performance tests? |
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? |
CIO November 19, 2010 David F. Carr |
Five Things CIOs Need to Know About Mobile Printing As mobile devices become more capable, travelling executives are looking to be able to print from them. Finding a solution can be complicated, but there are possible workarounds. |
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 February 2, 2005 Neil J. Rubenking |
Custom Envelopes in Word Is there any way that I can type the word "Attention" on the lower left of the envelope with Microsoft Word? |
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 September 16, 2003 Neil J. Rubenking |
Printing Wide Web Pages Many Web pages are too wide to print on 8.5-by-11 (or A4) paper, resulting in the right sides of pages being cut off. An easy solution is to install a free PDF utility such as PDF995, which adds a simulated printer to your system. Then print the PDF from Acrobat using the Shrink to Fit option. |
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 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 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 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 7, 2009 M. David Stone |
Print Currently Selected Text in Microsoft Word How to print multiple non-contiguous selection in Word. |
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 April 6, 2004 Helen Bradley |
Better Lists in Excel Excel 2003 offers some useful new tools for working with lists. |
PC Magazine August 17, 2004 |
Use a Formula as a Named Range in Excel Regarding the article "The Ultimate Sum Formula in Excel"... |
D-Lib September 2006 Bonita Wilson |
Preserving Information, Not Formats Dealing with materials that have existed solely in digital format is easier than contemplating what to do with print materials for which there is no longer space or budget available for maintenance. |
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 World October 2004 Lincoln Spector |
How Do I Share a Printer on My Small Network? Give multiple PCs on your home network access to one printer... Add options to the right-click menu... Sort IE favorites... |
PC Magazine April 19, 2006 M. David Stone |
Buying Guide: Dedicated Photo Printers If you have a digital camera and you want the freedom to print your own photos, even if it's moments after you take them, a dedicated photo printer is the way to go. |
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 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 World March 2003 Lincoln Spector |
Answer Line: What Do You Do When Windows Doesn't Boot? Also: nonsensical Windows error messages; add Excel data to a Word file; print later by saving as .prn; transfer Word AutoCorrect settings. |
PC Magazine August 3, 2004 |
Counting Unique Names in Excel, Reloaded How to count unique names in excel using pivot tables. |
PC Magazine August 16, 2006 M. David Stone |
Buying Guide: Color Lasers for Small Offices With prices for color lasers coming down and starting at just $300, any small office can afford one. |
PC Magazine August 16, 2006 |
Letterhead Problem In Word Set separate margins set for different pages of a letter. |
Search Engine Watch November 21, 2005 Gary Price |
A (Non-controversial) Alternative to Google Print While Google Print has stirred up a hornet's nest of controversy, another company has been offering online book search capabilities for years -- and with the blessings of publishers. |
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 18, 2004 Neil J. Rubenking |
Another Way to Highlight Formulas Expert advice on highlighting cells containing formulas in Excel. |
Macworld March 2001 James Bradbury |
Track Your Progress with Excel Formulas and Graphs Are at Your Fingertips... |
Search Engine Watch May 4, 2005 Gary Price |
Going Under Cover with Book Search Tools Google, Amazon and others offer really useful 'search inside the book' tools, but they're not always the easiest features to use. Here's a closer look at getting the most from online book search services. |
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 May 16, 2007 |
How Excel Formulas Can Reference Comments How to carry non-cell data from one Excel worksheet to another. |