| Similar Articles |
 |
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 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 3, 2004 Neil J. Rubenking |
Separate Address Elements In Excel I have an extensive Excel spreadsheet with company names and addresses. The city, state, and ZIP code information are combined into one cell. Is there a way this data can be split into three cells?  |
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 February 14, 2007 |
Numbers With Superscripts in Excel You can format each digit of a number with a different color within an Excel cell, but for the purpose of calculations, the formatting doesn't make any difference.  |
PC Magazine September 4, 2007 Neil Rubenking |
How to Sort by Birthday in Excel How to sort through dates while avoiding leap years.  |
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 March 16, 2005 Helen Bradley |
Conditional Formatting in Excel Make the information in your spreadsheets more accessible with formatting based on certain conditions.  |
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.  |
CFO June 15, 2012 Bill Jelen |
Blank Check How to get rid of pivot table blanks without affecting calculations.  |
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 May 4, 2004 Neil J. Rubenking |
Sorting Text in Excel Reordering words is more complicated than numbers. Here's a procedure that works.  |
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 September 27, 2006 |
Force Unique Numbers in Excel Keep duplicate numbers from being inserted into a column in Microsoft Excel.  |
AskMen.com Bernie Alexander |
The Significance Of Zip Codes How zip codes have evolved and what the digits mean.  |
PC Magazine July 19, 2005 Neil J. Rubenking |
Inserting an Address Bar Code in Word In Microsoft Word 2003, is there a way to get the address bar code on a letter for use with a windowed envelope?  |
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 February 1, 2006 |
Halves, Quarters, Eighths, Sixteenths in Excel Translating units without error in Excel.  |
PC Magazine July 12, 2006 |
Conditional Formatting for Plotted Points in Excel Faking conditional formatting for your plots.  |
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 August 1, 2007 Neil Rubenking |
Excel Formulas That Read Your Mind Understanding #REF! error markers in Excel formulas.  |
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 Magazine April 4, 2007 |
Making Excel Remember More Data Using excel to find linking values of data.  |
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 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 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 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 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 January 18, 2005 Neil J. Rubenking |
Easier Excel Fractions Regarding the PC Magazine tip about fractions in Microsoft Excel, there's another way to enter fractions directly that will both preserve the actual value of the number and autoformat the cell with a fraction format.  |
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 November 14, 2007 Sarah Pike |
Excel Tip: Rearrange Data Data is much easier to manipulate when Excel can help with the sorting.  |
CFO September 1, 2012 Bill Jelen |
An Average Solution How to create a prediction of sales in Excel using a moving average and a trend line.  |
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 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 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...  |
PC Magazine September 16, 2003 Helen Bradley |
15 Great Excel Tips Microsoft Excel is jam-packed with functions that perform a range of handy calculations and tests. We take a look at 15 Excel functions you may not know about and show you some clever ways to put them to work on your data.  |
The Motley Fool June 8, 2010 Nathan Alderman |
Make Your Checkbook Work for You Hate math? This easy, automated checkbook crunches numbers for you.  |
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 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 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 May 18, 2004 Neil J. Rubenking |
Find, Format, Replace Expert advice on Microsoft Word's Find and Replace for format, not text.  |
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?  |
PC Magazine August 14, 2008 Neil J. Rubenking |
Can't Enter Dates in Excel Solutions to Excel date problems  |
PC Magazine April 6, 2004 Helen Bradley |
Better Lists in Excel Excel 2003 offers some useful new tools for working with lists.  |
PC Magazine February 16, 2005 Neil J. Rubenking |
Problem with Excel Time Comparison How to build a formula in Microsoft Excel that produces a different answer based on time.  |
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 7, 2004 Helen Bradley |
Mapping Your Data If your Excel presentation contains geographical data, why not display it on a map?  |