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 18, 2008 Neil J. Rubenking	Tech Tip: Cell Couture Tips for working with Excel.
PC Magazine April 20, 2004 Neil J. Rubenking	Another Way to Separate Address Elements Here's another approach to breaking addresses apart, but one that requires no formulas for use with Excel.
PC Magazine April 6, 2004 Helen Bradley	Better Lists in Excel Excel 2003 offers some useful new tools for working with lists.
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 3, 2004	Counting Unique Names in Excel, Reloaded How to count unique names in excel using pivot tables.
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 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 August 23, 2005 Ben Z. Gottesman	Finding Hidden Columns in Excel I somehow lost several of the leftmost columns in a Microsoft Excel spreadsheet and have been unable to make them visible again. How can I get these lost columns back?
PC Magazine May 31, 2006	Pick Lottery Numbers With Excel Using the LARGE() function in Excel.
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 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 February 8, 2008 David Cardinal	Create Appointments Automatically Do you work on projects whose due dates or events are kept in a spreadsheet? Here are some tips to importing them into your digital planner.
PC Magazine September 4, 2007 Neil Rubenking	Sort on More Than Three Columns The how and why to sort data with more than three columns in Excel.
PC Magazine September 27, 2006	Force Unique Numbers in Excel Keep duplicate numbers from being inserted into a column in Microsoft Excel.
PC Magazine September 7, 2004 Helen Bradley	Mapping Your Data If your Excel presentation contains geographical data, why not display it on a map?
PC Magazine November 11, 2003 Neil J. Rubenking	Fixing an Excel Formula I have created several Excel 2000 worksheets that use the VLOOKUP formula to get information from one central worksheet. Now I need to add columns to the root worksheet.
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 April 20, 2005 Helen Bradley	Outlining Your Data Use Excel's Group and Outline feature to view only as much data as you need.
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 Magazine July 1, 2003 Neil J. Rubenking	Filtering with Excel's PivotTable Is there a way to count the number of occurrences of each name in an Excel column?
Macworld March 2001 James Bradbury	Track Your Progress with Excel Formulas and Graphs Are at Your Fingertips...
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.
The Motley Fool June 16, 2010 Nathan Alderman	Beat Back the Budget Beast! This handy spreadsheet can help you keep your money in line.
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 March 16, 2004 Neil J. Rubenking	Count Unique Names in Excel I have a list of some 900,000 names in an Excel worksheet. Most of the names have duplicates. How can I count the number of names without counting duplicate entries?
PC Magazine May 4, 2004 Neil J. Rubenking	Sorting Text in Excel Reordering words is more complicated than numbers. Here's a procedure that works.
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 May 16, 2007	How Excel Formulas Can Reference Comments How to carry non-cell data from one Excel worksheet to another.
PC Magazine September 21, 2004	A Subtle Bug in Excel Pivot Tables A reader discovers an unusual Excel 2003 flaw, and we have a demonstration.
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 September 4, 2007 Neil Rubenking	Renaming Excel Rows and Columns Excel can optionally number the columns instead of lettering them.
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?
CFO May 15, 2012 Bill Jelen	Keep It Secret How to make sure hidden rows in spreadsheets stay hidden.
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 June 22, 2005 Neil J. Rubenking	Importing Bookmarks into Firefox To import this or any other bookmark file into Firefox, first select Bookmarks \| Manage Bookmarks...
PC Magazine September 14, 2005 Ben Z. Gottesman	PivotTable Magic Exploring complex Excel data is easier with a PivotTable. Our tips show you how.
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 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 World July 18, 2007 Preston Gralla	Import Your Contacts to Gmail Add Outlook, OE, and Windows Mail contacts to your Gmail address book in two steps.
PC Magazine July 12, 2006	Conditional Formatting for Plotted Points in Excel Faking conditional formatting for your plots.
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.
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 October 14, 2003 Neil J. Rubenking	Absolute and Relative References in Excel Avoid error messages in your formulas by using the $ character to indicate cell references that should never change.
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 August 30, 2006	Make Excel Stop Shooting Blanks Sometimes when I print an Excel sheet, I end up with 10 to 12 blank pages following it. Any suggestions?
PC Magazine February 14, 2007 Sarah Pike	Explorer Columns Customize Windows Explorer to make managing your files easier.
PC Magazine December 30, 2003 Neil J. Rubenking	The Ultimate Sum Formula in Excel Here's how to set up a formula that will automatically adapt and sum all the cells above it, wherever it is placed.
PC Magazine September 21, 2004	Shuffle Numbers in Excel This is an easy way to generate a non-repeating list of random numbers.
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.
PC World December 2004 Scott Spanbauer	Where Are My E-Mail, Addresses, and Calendars? Streamline your e-mail files; move messages between apps; and stay safe with plain old text.