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 November 14, 2007 Sarah Pike	Word Tip: Rearrange Data Convert text to a table and sort through your data more efficiently.
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 April 15, 2012 Bill Jelen	A Global Shift (of Decimals) How to move the decimal point in an array of Excel data.
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 November 2, 2005 Neil J. Rubenking	Word Document with Linked Excel Data Linking excel data to word documents while maintaining word formatting.
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 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 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 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 June 1, 2005 M. David Stone	Listening to Office You may know you can speak text and commands to Office. But did you know Office can talk back?
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 October 10, 2007 Gary Berline	Excel Tip: Cell Navigation Jump easily from one cell to a non-neighboring cell.
PC Magazine January 20, 2004 M. David Stone	Create Columns Using Text Boxes In Word With text boxes, your graphics will stay where you put them in Microsoft Word.
CFO June 15, 2012 Bill Jelen	Blank Check How to get rid of pivot table blanks without affecting calculations.
PC Magazine February 15, 2006	Formatted Excel Date Within Text Calculate a date from some cells and then combine it with literal text in another cell.
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 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 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 December 14, 2004 Neil J. Rubenking	Copy Word Document Without Hidden Text I have a Microsoft Word document with hidden text, but when I highlight the document and paste it into a Microsoft Outlook Express e-mail, the hidden text is no longer hidden... Here's how to fix the problem...
PC Magazine August 12, 2008 Neil J. Rubenking	Checksum for a Spreadsheet Create a cell in Excel that does the equivalent of a "hash" or sum of the entire active workbook.
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 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 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 April 18, 2007	Pre-1900 Dates in Excel Sorting dates prior to 1900 in Excel.
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 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 January 31, 2007	Search Web Pages for Bold Text Change the color of text highlighted as bold on a Web page.
PC Magazine May 21, 2009 Ben Z. Gottesman	Beyond Numbers: Manipulating Text in Excel Excel is great for crunching numbers, but it's also a simple database solution for many. Luckily, with a few handy formulas, Excel can learn to crunch your alpha-bits too.
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 February 14, 2007	Misbehaving Copy and Paste Tweaking the copy and paste options in Microsoft Word.
Technology Research News January 12, 2005	Copy-and-Paste Goes Natural Researchers have built a tool that uses natural language parsing techniques to reduce the formatting that must be done when text is copied from one application, like email, and pasted into another, like an address book.
PC Magazine February 8, 2008 David Cardinal	Create Appointments Automatically Do you work on projects whose due dates or events are kept in a spreadsheet? Here are some tips to importing them into your digital planner.
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 October 11, 2006	Flashing Text in Excel Make flash animation in Excel.
PC Magazine November 30, 2005 Edward Mendelson	Office Problems, Solved! Some of the most notorious problems and the most useful tricks with Microsoft office.
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.
CRM December 5, 2011 Judith Aquino	Leads360 Introduces New Automated Text Message Capabilities Leads360 added automated text messaging to its offerings, allowing sales associates to automate the process of composing and sending text messages via the SPAM-compliant Short Message Service protocol.
PC Magazine November 30, 2005 Neil J. Rubenking	Attachments in Outlook Use HTML format to open multiple attachments at once in Outlook 2003.
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 August 2, 2006 John Brandon	Get to Know Excel Templates Making sense of data is both the purpose of Microsoft Excel and its challenge.
PC Magazine June 18, 2008 Neil J. Rubenking	Tech Tip: Cell Couture Tips for working with Excel.
PC World October 3, 2001 Jim Welp	Office XP Tips: Selecting Text, Find and Replace XP has some handy editing tricks up its sleeve...
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 World May 3, 2001	Top 5 Spreadsheet Add-Ins Avoid the pain and tedium of writing Excel formulas...
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...
AskMen.com	The Texting Age About two-thirds of all teens use text messaging, mostly due to its simplicity as well as the privacy of being able to communicate without being overheard.
PC Magazine August 12, 2008 M. David Stone	Those Colors Clash Matching colors between Excel 2007 and Excel 2003.
Macworld March 2001 James Bradbury	Track Your Progress with Excel Formulas and Graphs Are at Your Fingertips...
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.
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.