| Similar Articles |
|---|
 |
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
June 22, 2005
Ben Z. Gottesman |
Viewing Excel Attachments in Outlook Lately, when I try to launch Excel attachments from Outlook, Excel starts but the file won't load... The problem--and the solution--is in Excel... |
PC Magazine
August 12, 2008
M. David Stone |
Those Colors Clash Matching colors between Excel 2007 and Excel 2003. |
PC Magazine
February 8, 2008
Neil J. Rubenking |
Turn Excel Data and Charts into JPEGs Create figures or a movie from Excel charts. |
PC Magazine
February 17, 2004
Neil J. Rubenking |
Save a Multipage Image in Excel What do you do when you want to grab a screen image, but some of the data you want is off-screen? |
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? |
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 4, 2007
Anton Galang |
Vista Tip: Copy as Path A new feature of Vista allows users to copy folder paths. |
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
October 14, 2003
Neil J. Rubenking |
Make a Default Custom Footer in Excel We show you how to customize your default workbook template to add specialized selections to the header and footer lists. |
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
April 18, 2007 |
Pre-1900 Dates in Excel Sorting dates prior to 1900 in Excel. |
PC Magazine
October 11, 2006 |
Flashing Text in Excel Make flash animation in Excel. |
PC Magazine
October 1, 2003
Neil J. Rubenking |
Blocked by Phantom Administrator When I select Internet Options from Internet Explorer's Tools menu, I get a message that reads, "This operation has been canceled due to restrictions in effect on this computer. Please contact your system administrator." |
PC Magazine
July 13, 2004 |
Update an Excel Menu How to add the new Excel 2003 List submenu to an outdated custom menu bar. |
CFO
December 1, 2010
Marie Leone |
Total Trouble The older generation of Excel users remembers how potentially dangerous this Microsoft snag can be. |
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 20, 2007 |
Save Time With Heading Functions in Excel Making custom applications for Excel is easier than you think. Read on to learn 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
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 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
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
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
July 13, 2005
Neil J. Rubenking |
Wrong Dialogs Appear One of our readers discovered a technique for adding Move To Folder or Copy To Folder options to the context menu. It turns out, however, that this technique has an unwanted side effect. |
PC Magazine
May 18, 2004
Neil J. Rubenking |
Another Way to Highlight Formulas Expert advice on highlighting cells containing formulas 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. |
Wall Street & Technology
March 14, 2008
Cory Levine |
Excel Still Fastest and Most Flexible Trade Capture System Traders are sticking to Excel because it empowers them to create new structured products without relying on the support of the IT organization, says TABB Group. |
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. |
IndustryWeek
March 1, 2009
John Teresko |
Bookshelf: Fundamentals of Forecasting Using Excel Involved with forecasting? Kenneth Lawrence's new book is designed to help readers with the tools to analyze their data, develop forecasting models and present the results in Excel. |
Wall Street & Technology
March 19, 2007
Ivy Schmerken |
Capital Markets Firms Can Run Spreadsheets on a Server With Microsoft's New Excel Services Responding to Wall Street firms' compliance concerns over spreadsheets in Excel 2007, Microsoft is now offering firms the ability to run Excel Services on a server. |
Macworld
March 2001
James Bradbury |
Track Your Progress with Excel Formulas and Graphs Are at Your Fingertips... |
CFO
May 15, 2012
Bill Jelen |
Keep It Secret How to make sure hidden rows in spreadsheets stay hidden. |
PC World
December 17, 2001
John Fontana |
Exposing Excel's Dirty Little Secret Spreadsheet could potentially reveal confidential data, but Microsoft says the problem is only one of perception... |
PC Magazine
September 16, 2003
M. David Stone |
Side by Side by Windows My monitor offers high resolution (1,600-by-1,200) to show easily the full width of two Microsoft Word pages side by side. Is there a way to make Word automatically arrange the windows side by side? |
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
September 13, 2006 |
Side-by-Side Instances of Windows Explorer Tiling Windows explorer for easier viewing. |
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? |
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
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
May 16, 2007 |
How Excel Formulas Can Reference Comments How to carry non-cell data from one Excel worksheet to another. |
PC Magazine
October 10, 2007
Neil J. Rubenking |
"Copy Only Subtotals in Excel" Revisited Multiple solutions to the same problem. |
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 19, 2010
Edward Mendelson |
10 Excellent Tips for Microsoft Excel 2010 Excel is, without a doubt, one of the most powerful, complex, and tricky desktop apps ever designed. Mastering Office 2010's spreadsheet app can take years; fortunately, we've got 10 very cool shortcuts to Excel mastery. |
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
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. |
The Motley Fool
April 9, 2009
Christopher Barker |
Survival Trumps Profit for Shippers Excel Maritime moves a little closer to safe harbor. |
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. |
The Motley Fool
August 13, 2008
Christopher Barker |
A Shipper Made to Excel Dry bulk shipper Excel Maritime charges full steam ahead. |
The Motley Fool
November 15, 2007
Toby Shute |
Secrets of the Sea Dry-bulk shipper Excel Maritime's third-quarter report is lacking disclosures to investors in several key areas. |
PC Magazine
August 14, 2008
Neil J. Rubenking |
Can't Enter Dates in Excel Solutions to Excel date problems |
