| Similar Articles |
|---|
 |
PC Magazine
May 16, 2007 |
How to Use Superscripts in MS Access Data fields in a Microsoft Access database aren't associated to any font in particular. Here's how you can make the necessary changes to the program's font.   |
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
July 12, 2006 |
Conditional Formatting for Plotted Points in Excel Faking conditional formatting for your plots. |
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
August 30, 2006 |
Problem Merging Zip Codes That Start with 0 Making Microsoft Office 2003 Small Business allow zip codes that begin with 0. |
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
September 14, 2005
Neil J. Rubenking |
Sharps, Flats, and Naturals in Word How to ease the process of entering unique symbols or characters into your word documents. |
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
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
February 1, 2006 |
Halves, Quarters, Eighths, Sixteenths in Excel Translating units without error in Excel. |
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
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
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. |
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
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 4, 2007 |
Making Excel Remember More Data Using excel to find linking values of data. |
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
October 19, 2004
Neil J. Rubenking |
Excel Fails to Store Credit Card Numbers When entering numeric data over 15 digits long, prefix the data with a single quote ('). This forces Excel to treat the data as text. |
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. |
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
September 7, 2004
Neil J. Rubenking |
Asterisk Foils VLOOKUP Here's why Excel's first-column search function trips over a little star and what to do. |
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
September 27, 2006 |
Force Unique Numbers in Excel Keep duplicate numbers from being inserted into a column in Microsoft Excel. |
PC Magazine
August 31, 2005
Helen Bradley |
Performing Lookups In Excel If you need to pull information out of spreadsheets in Excel, use the VLOOKUP function. |
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
January 1, 2008
Neil J. Rubenking |
The Incredible Shrinking Excel Text Excel fonts getting a bit tiny? Here's how to keep them readable. |
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
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
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
May 16, 2007 |
How Excel Formulas Can Reference Comments How to carry non-cell data from one Excel worksheet to another. |
PC Magazine
December 9, 2003 |
Super-Superscripts in Word Need to use superscripts on superscripts in Microsoft Word 2002? Here's how. |
PC Magazine
September 4, 2007
Helen Bradley |
Making Choices in Excel Vlookups can easily return data from even very large tables. |
PC World
February 2001
George Campbell |
Beautify Documents With Vertical Justification Justify documents vertically, change time formats, replace invisible items... |
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. |
CIO
May 3, 2010
Joab Jackson |
Going Global? Check Your Software for Unicode Characters Ensuring business systems support Unicode characters can ease entry for U.S. companies into global markets. |
Unix Insider
March 2001
Cameron Laird & Kathryn Soraiz |
More than just English It's time to move beyond English -- if you haven't already. All of the major scripting languages can handle alphabets for most of the world's other languages... |
