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 April 6, 2004 Helen Bradley	Better Lists in Excel Excel 2003 offers some useful new tools for working with lists.
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 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 November 2, 2005 Neil J. Rubenking	A Better Watermark in Excel How to create the look of a watermark within an Excel worksheet.
PC Magazine June 18, 2008 Neil J. Rubenking	Tech Tip: Cell Couture Tips for working with Excel.
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	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 September 4, 2007 Neil Rubenking	Renaming Excel Rows and Columns Excel can optionally number the columns instead of lettering them.
PC Magazine November 16, 2005 Neil J. Rubenking	Import Over 256 Columns in Excel How to a list of more than 256 items into excel.
PC Magazine August 1, 2007 Neil Rubenking	Excel Formulas That Read Your Mind Understanding #REF! error markers in Excel formulas.
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 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 December 21, 2005 Ben Z. Gottesman	Dragging a Field Trouble replicating the item "Drag That Field Again and Again" using PivotTables in Excel 2003.
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 September 7, 2004 Neil J. Rubenking	Inverted Printing in Word Print left-to-right and right-to-left on the same page.
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 August 16, 2006	Letterhead Problem In Word Set separate margins set for different pages of a letter.
PC Magazine August 3, 2004	Counting Unique Names in Excel, Reloaded How to count unique names in excel using pivot tables.
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 14, 2007 Sarah Pike	Word Tip: Rearrange Data Convert text to a table and sort through your data more efficiently.
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 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 April 6, 2005 M. David Stone	Partial Label Pages Printing partial page of labels in Word 2003.
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 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 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 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 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 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 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 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 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, 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 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 May 16, 2007 Helen Bradley	Analyze Data in a Cinch Excel 2007 boasts a host of new feature. Among those is PivotTable a neat and useful new way to look at your data.
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 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 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 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 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 World November 2004 Woody Leonhard	Take Command: Make Office Work Your Way Tips on several Word tools and functions, password-protecting new documents automatically, and more.
PC Magazine May 4, 2005 Neil J. Rubenking	Control Rounding in Excel I have an Excel spreadsheet for my small business that I use to figure employee payroll. What formula can I use so that Excel will always round across the columns so they add correctly?
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 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 August 17, 2004	Use a Formula as a Named Range in Excel Regarding the article "The Ultimate Sum Formula in Excel"...
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 September 14, 2005 Ben Z. Gottesman	PivotTable Magic Exploring complex Excel data is easier with a PivotTable. Our tips show you how.
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.