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 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.
CFO June 15, 2012 Bill Jelen	Blank Check How to get rid of pivot table blanks without affecting calculations.
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 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 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.
PC Magazine February 3, 2004 Neil J. Rubenking	Highlight Cells Containing Formulas In designing and auditing spreadsheets, I'd like to distinguish visually between cells containing formulas and those containing values.
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 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 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?
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.
Macworld March 2001 James Bradbury	Track Your Progress with Excel Formulas and Graphs Are at Your Fingertips...
PC Magazine October 10, 2007 Neil J. Rubenking	"Copy Only Subtotals in Excel" Revisited Multiple solutions to the same problem.
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 September 21, 2004	Shuffle Numbers in Excel This is an easy way to generate a non-repeating list of random numbers.
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 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 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 August 3, 2004	Counting Unique Names in Excel, Reloaded How to count unique names in excel using pivot tables.
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 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 February 8, 2008 Neil J. Rubenking	Turn Excel Data and Charts into JPEGs Create figures or a movie from Excel charts.
PC Magazine September 21, 2004	A Subtle Bug in Excel Pivot Tables A reader discovers an unusual Excel 2003 flaw, and we have a demonstration.
PC Magazine October 10, 2007 Gary Berline	Excel Tip: Cell Navigation Jump easily from one cell to a non-neighboring cell.
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 16, 2005 Neil J. Rubenking	Patching an Excel Line Graph How to manage blank cells when graphing data.
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 April 20, 2004 Neil J. Rubenking	Another Way to Separate Address Elements Here's another approach to breaking addresses apart, but one that requires no formulas for use with Excel.
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 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 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 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 November 30, 2005 Edward Mendelson	Office Problems, Solved! Some of the most notorious problems and the most useful tricks with Microsoft office.
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 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 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?
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 September 7, 2004 Neil J. Rubenking	Inverted Printing in Word Print left-to-right and right-to-left on the same page.
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 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 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 May 18, 2005 Neil J. Rubenking	Advanced Find and Replace in Word The Find and Replace function in Microsoft Word is extremely useful, but I can't always make it work the way I want.
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 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 September 27, 2006	Force Unique Numbers in Excel Keep duplicate numbers from being inserted into a column in Microsoft Excel.
PC Magazine April 4, 2007	Making Excel Remember More Data Using excel to find linking values of data.
PC Magazine September 14, 2005 Neil J. Rubenking	Excel's Calendar Control Object How to add Calendar Control 11.0 to your spreadsheet.