- Robert F. Ryan, MBA, CPA is an independent business consultant, educator, writer and finance leader in a Fortune 50 multinational company. He has a passion for simplicity, quality, efficiency and a unique ability to explain things to people so they understand quickly and thoroughly. He's worked with spreadsheets extensively for almost thirty years including VisiCalc, Lotus 1-2-3 and Excel.
Monthly Archives: September 2010
Copying Formats, Part 1: Cells & Columns Using Paste Special
Have you ever had a situation where you wanted to make the format of particular cells or columns identical to another cell or column? I encounter this situation somewhat frequently, and when I do, I use Excel’s format copying feature. … Continue reading
Hiding and Unhiding Using the Grouping Feature
In last week’s blog, I mentioned there was a little plus sign above Column C in the sheet named “List” in the file that accompanied that blog, as shown here: Please click this link to open the Excel 2007 … Continue reading
Posted in Excel Grouping
Leave a comment
Packing for Vacation Using PivotTables
While PivotTables can certainly be used to summarize numerical information, they can also be used to organize non-numerical information. Case in point: packing for vacation. I used to have a vacation packing list in Word, but I found I needed … Continue reading
Posted in Excel PivotTables
1 Comment
