972 reputation
31324
bio website devuxer.com
location San Diego, CA
age
visits member for 5 years, 3 months
seen Nov 25 at 21:02

Dec
10
revised Firefox's spellchecker (typo-checker?) doesn't catch repeated repeated words
edited title; added 2 characters in body
Dec
10
asked Firefox's spellchecker (typo-checker?) doesn't catch repeated repeated words
Dec
10
accepted Is it possible to make Microsoft Office grid snapping less “smart”?
Dec
10
answered Excel: Find Items in one column that are not in another column
Dec
8
revised Weird mouse/keyboard freezups when using PowerPoint 2007 with IBM/Lenovo docking station
Clarified the problem; added 1 characters in body; added 10 characters in body; edited tags; edited tags; edited tags
Dec
8
answered Weird mouse/keyboard freezups when using PowerPoint 2007 with IBM/Lenovo docking station
Dec
8
asked Weird mouse/keyboard freezups when using PowerPoint 2007 with IBM/Lenovo docking station
Dec
8
answered Is it possible to make Microsoft Office grid snapping less “smart”?
Dec
8
revised Is it possible to make Microsoft Office grid snapping less “smart”?
edited tags
Dec
8
comment Is it possible to make Microsoft Office grid snapping less “smart”?
That's a great tip, but I actually want grid snapping. I just don't want it to try to snap all sides of the object to the grid when it should just be snapping the top and left.
Dec
8
comment Is it possible to make Microsoft Office grid snapping less “smart”?
I must be missing something. If I use Ctrl with the arrow keys, it just moves pixel by pixel (I get no grid snapping at all). If I use Ctrl while dragging the object with the mouse, it duplicates the object.
Dec
8
revised Is it possible to make Microsoft Office grid snapping less “smart”?
added 8 characters in body
Dec
8
asked Is it possible to make Microsoft Office grid snapping less “smart”?
Dec
7
accepted Is it possible to “unpivot” or “reverse pivot” in Excel?
Dec
7
comment Is it possible to “unpivot” or “reverse pivot” in Excel?
Ah okay, I looked it up in the help and found a back-door way to get the old Pivot Table Wizard in Excel 2007 (you need to press ALT+D+P). Now I'm able to follow your steps, and it seems to work. Thanks for your help!
Dec
7
revised Is it possible to “unpivot” or “reverse pivot” in Excel?
edited tags
Dec
7
comment Is it possible to “unpivot” or “reverse pivot” in Excel?
Dave, thanks for editing your answer, but are you sure these instructions apply to Excel 2007? I'm not seeing anything about "multiple consolidation ranges".
Dec
3
revised Is it possible to “unpivot” or “reverse pivot” in Excel?
edited tags
Dec
3
awarded  Commentator
Dec
3
comment Is it possible to “unpivot” or “reverse pivot” in Excel?
If I put Id into Row Labels and Loc1 through Loc4 into Column Labels, then click the lower-right cell (the intersection of the Grand Totals), it does create a new sheet with a table, but it's not what I want. It's basically just a copy of the regular pivot table.