| Similar Articles |
|---|
 |
PC Magazine
August 19, 2003
Neil J. Rubenking |
Combo Boxes in Excel I want to insert information from a combo box into an Excel spreadsheet.   |
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
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... |
CFO
April 15, 2012
Bill Jelen |
A Global Shift (of Decimals) How to move the decimal point in an array of Excel data. |
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
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 21, 2006 |
Double The Holiday Fun In Outlook? If you accidentally add U.S. holidays to Outlook 2003 twice, here's how to you reset the calendar to just show them once. |
PC Magazine
October 10, 2008
Edward Mendelson |
Microsoft Outlook: 9 Things You Didn't Know You Could Do E-mail can be such a chore some days, it's no wonder most of us don't play around with its settings or know half the tricks it can perform. Read on for a few of our favorites. |
PC Magazine
September 27, 2006 |
Force Unique Numbers in Excel Keep duplicate numbers from being inserted into a column in Microsoft Excel. |
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 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
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
August 3, 2004 |
Counting Unique Names in Excel, Reloaded How to count unique names in excel using pivot tables. |
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 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 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
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
May 4, 2005
Helen Bradley |
Demystifying Excel Macros Writing macros can be a challenge; learn the basics with our example. |
PC Magazine
October 10, 2007
Gary Berline |
Excel Tip: Cell Navigation Jump easily from one cell to a non-neighboring cell. |
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
June 2, 2008
Neil J. Rubenking |
Eight Handy Tools in Microsoft Word You Probably Don't Know About Save time and energy by using these easy features in your Word documents. |
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 1, 2007
Neil Rubenking |
Excel Formulas That Read Your Mind Understanding #REF! error markers in Excel formulas. |
PC Magazine
August 17, 2004 |
Use a Formula as a Named Range in Excel Regarding the article "The Ultimate Sum Formula in Excel"... |
PC Magazine
October 10, 2007
Neil J. Rubenking |
Removing Drop Shadow Effects in Excel To eliminate drop shadow effects you need to make sure the object handles remain visible. |
PC Magazine
July 12, 2006 |
Conditional Formatting for Plotted Points in Excel Faking conditional formatting for your plots. |
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
October 11, 2006 |
Flashing Text in Excel Make flash animation in Excel. |
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
November 30, 2005
Edward Mendelson |
Office Problems, Solved! Some of the most notorious problems and the most useful tricks with Microsoft office. |
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
September 4, 2007
Neil Rubenking |
How to Sort by Birthday in Excel How to sort through dates while avoiding leap years. |
PC Magazine
April 6, 2004
Helen Bradley |
Better Lists in Excel Excel 2003 offers some useful new tools for working with lists. |
PC World
April 25, 2001
George Campbell |
Sweet Suite Tips Get the most out of Microsoft Office and Corel WordPerfect documents with these tips... |
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
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
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
June 20, 2008
Larry Seltzer |
Outsmart Calendar Spam Spam has a tricky new mode of entry, so here's what you need to know to protect yourself. |
PC World
July 23, 2007
Preston Gralla |
Publish Your Outlook 2007 Calendar to the Web You can share your Outlook 2007 calendar with anyone by publishing it to the Web via Microsoft's Office Online service. It's free! |
PC Magazine
October 10, 2007
Neil J. Rubenking |
"Copy Only Subtotals in Excel" Revisited Multiple solutions to the same problem. |
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
December 21, 2005
Helen Bradley |
Exploring Word Toolbars Customize your Word environment with these handy toolbar options. |
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 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 1, 2006
Mark J. Brickley |
Excel Comes Alive You can add live stock data to an Excel spreadsheet. |
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
November 14, 2007
Helen Bradley |
Fast Data Entry in Excel Anytime you can enter data without having to type it yourself, you improve accuracy and save yourself effort. There are plenty of opportunities in Excel to enter data in a faster and smarter way than via the keyboard. |
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. |
