| Similar Articles |
|---|
 |
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
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
April 6, 2004
Helen Bradley |
Better Lists in Excel Excel 2003 offers some useful new tools for working with lists. |
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
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
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
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 12, 2008
M. David Stone |
Those Colors Clash Matching colors between Excel 2007 and Excel 2003. |
PC Magazine
October 10, 2007
Neil J. Rubenking |
"Copy Only Subtotals in Excel" Revisited Multiple solutions to the same problem. |
PC Magazine
September 4, 2007
Neil Rubenking |
Renaming Excel Rows and Columns Excel can optionally number the columns instead of lettering them. |
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
August 1, 2007
Neil Rubenking |
Excel Formulas That Read Your Mind Understanding #REF! error markers in Excel formulas. |
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
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 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
February 8, 2008
Neil J. Rubenking |
Turn Excel Data and Charts into JPEGs Create figures or a movie from Excel charts. |
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
December 21, 2005
Ben Z. Gottesman |
Dragging a Field Trouble replicating the item "Drag That Field Again and Again" using PivotTables in Excel 2003. |
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 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
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
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. |
PC Magazine
February 14, 2007 |
Misbehaving Copy and Paste Tweaking the copy and paste options in Microsoft Word. |
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 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
Neil J. Rubenking |
Find Unique Rows in Excel Stop searching for new or special entries in Excel by telling the software to how to do the hunting and highlighting for you. |
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
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
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. |
CFO
May 15, 2012
Bill Jelen |
Keep It Secret How to make sure hidden rows in spreadsheets stay hidden. |
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
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 3, 2004 |
Counting Unique Names in Excel, Reloaded How to count unique names in excel using pivot tables. |
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
September 4, 2007
Anton Galang |
Vista Tip: Copy as Path A new feature of Vista allows users to copy folder paths. |
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
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
November 14, 2007
Sarah Pike |
Excel Tip: Rearrange Data Data is much easier to manipulate when Excel can help with the sorting. |
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? |
Macworld
March 2001
James Bradbury |
Track Your Progress with Excel Formulas and Graphs Are at Your Fingertips... |
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
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
June 18, 2008
Neil J. Rubenking |
Tech Tip: Cell Couture Tips for working with Excel. |
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
May 31, 2006 |
The Start Menu Got Way Too Wide Managing the programs in your Start Menu. |
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
June 22, 2005
Neil J. Rubenking |
Getting Rid of Unwanted Names in Outlook A while ago we changed ISPs and, consequently, e-mail addresses. Where do I have to go to delete the old address once and for all? |
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
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
May 31, 2006 |
Pick Lottery Numbers With Excel Using the LARGE() function in Excel. |
