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 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 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 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 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.
PC Magazine June 22, 2004 Neil J. Rubenking	Get the Last Nonblank Cell in An Excel Range Creating an array formula for this task.
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 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"...
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 4, 2004 Neil J. Rubenking	Sorting Text in Excel Reordering words is more complicated than numbers. Here's a procedure that works.
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 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 September 4, 2007 Neil Rubenking	Renaming Excel Rows and Columns Excel can optionally number the columns instead of lettering them.
PC Magazine January 20, 2004 Neil J. Rubenking	Better Averages Without Extremes A better way to calculate the average of a range of cells in a spreadsheet while omitting one or more of the highest or lowest values.
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 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.
CFO May 15, 2012 Bill Jelen	Keep It Secret How to make sure hidden rows in spreadsheets stay hidden.
Macworld March 2001 James Bradbury	Track Your Progress with Excel Formulas and Graphs Are at Your Fingertips...
PC Magazine April 4, 2007	Making Excel Remember More Data Using excel to find linking values of data.
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 September 27, 2006	Force Unique Numbers in Excel Keep duplicate numbers from being inserted into a column in Microsoft 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 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 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 August 3, 2004	Counting Unique Names in Excel, Reloaded How to count unique names in excel using pivot tables.
PC Magazine October 1, 2003	Excel's Array Formulas Array formulas are a powerful addition to your Excel toolbox. We show you how to start using them.
PC Magazine May 18, 2004 Neil J. Rubenking	Another Way to Highlight Formulas Expert advice on highlighting cells containing formulas in Excel.
PC Magazine November 29, 2006	Using Excel's List Feature Setting up data in Microsoft Excel that changes daily.
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 21, 2004	Shuffle Numbers in Excel This is an easy way to generate a non-repeating list of random numbers.
PC Magazine September 14, 2005 Neil J. Rubenking	Excel's Calendar Control Object How to add Calendar Control 11.0 to your spreadsheet.
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 March 16, 2005 Helen Bradley	Conditional Formatting in Excel Make the information in your spreadsheets more accessible with formatting based on certain conditions.
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 December 14, 2004 Neil J. Rubenking	Advanced Ranking in Excel Q: I have columns of students, band instruments, and tryout scores... A: This seemingly knotty problem can be solved with a single formula...
PC Magazine April 26, 2005 Neil J. Rubenking	Another Way to Get Last Nonblank Cell Tips for getting the most out of Microsoft Excel.
PC Magazine October 28, 2003 Neil J. Rubenking	Averages Without Extremes In Excel "I have a column in Excel that contains account balances. I would like to find the average balance after throwing out the one or two highest and one or two lowest values." A solution.
CFO April 15, 2012 Bill Jelen	A Global Shift (of Decimals) How to move the decimal point in an array of Excel data.
PC World May 3, 2001	Top 5 Spreadsheet Add-Ins Avoid the pain and tedium of writing Excel formulas...
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 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 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 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 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 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 4, 2007 Neil Rubenking	How to Sort by Birthday in Excel How to sort through dates while avoiding leap years.
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 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 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 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.