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 August 17, 2005 Neil J. Rubenking	Excel Times Two I have a two-monitor system. It should be like Internet Explorer or Microsoft Word, where you can have multiple windows open at the same time. Is this option available in Excel?
PC Magazine April 18, 2007	Pre-1900 Dates in Excel Sorting dates prior to 1900 in Excel.
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 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 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 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 2, 2005 Neil J. Rubenking	Word Document with Linked Excel Data Linking excel data to word documents while maintaining word formatting.
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 August 12, 2008 M. David Stone	Those Colors Clash Matching colors between Excel 2007 and Excel 2003.
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 February 8, 2008 Neil J. Rubenking	Turn Excel Data and Charts into JPEGs Create figures or a movie from Excel charts.
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 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 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 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 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 May 16, 2007	How Excel Formulas Can Reference Comments How to carry non-cell data from one Excel worksheet to another.
Macworld March 2001 James Bradbury	Track Your Progress with Excel Formulas and Graphs Are at Your Fingertips...
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 August 14, 2008 Neil J. Rubenking	Can't Enter Dates in Excel Solutions to Excel date problems
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 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 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 January 31, 2007 Helen Bradley	Introducing Excel 2007 Along with its new interface, Microsoft Excel 2007 offers several subtle improvements to those spreadsheet tools you use every day.
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 May 18, 2004 Neil J. Rubenking	Another Way to Highlight Formulas Expert advice on highlighting cells containing formulas in Excel.
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 1, 2005 Neil J. Rubenking	Annoying Office Clipboard When I copy cells in Microsoft Excel, after the second copy action in a worksheet the clipboard panel pops up on the right and shrinks the visible portion of my worksheet. How can I disable this feature?
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 December 20, 2006	Excel Color-Coding for the Color-Blind An Excel macro to use only colors a color-blind person can differentiate.
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 September 4, 2007 Neil Rubenking	How to Sort by Birthday in Excel How to sort through dates while avoiding leap years.
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 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 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 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 October 10, 2007 Neil J. Rubenking	"Copy Only Subtotals in Excel" Revisited Multiple solutions to the same problem.
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.
PC Magazine October 11, 2006	Flashing Text in Excel Make flash animation in Excel.
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 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 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 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 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 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 October 10, 2007 Gary Berline	Excel Tip: Cell Navigation Jump easily from one cell to a non-neighboring cell.
PC Magazine January 12, 2005 Helen Bradley	Going in Style You know how useful styles are for formatting Word documents; did you know they're available in Excel as well?
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 May 17, 2006	Excel Filter Problem Resolved Making the count of matching items in Excel using it's Auto-Filter feature appear in the status bar at bottom left.