Reputation
1,999
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
1 12 33
Impact
~182k people reached

Apr
25
comment Double click on format painter not working - any idea why?
Double-clicking the format painter is supposed to lock it so that it stays enabled even after you use it.
Mar
14
answered Draw multiple arrows
Mar
11
comment Excel, one cell takes a value from another but want to subtract from another cell
An even simpler way is =L27-N(L8). The N function returns 0 for a blank cell or the number for a nonblank cell.
Feb
18
comment Best data compression format available
I'm not sure if it's better than FreeArc, but I've had success with 7-Zip. 7-zip.org
Feb
12
answered Error: The Macro May Not Be Available In This Workbook Or All Macros May Be Disabled
Feb
11
comment Error: The Macro May Not Be Available In This Workbook Or All Macros May Be Disabled
When you first right click on the button and choose Assign Macro, if you look at the "Macro name" text box, it should show you what macro is currently assigned to the button.
Feb
11
comment Error: The Macro May Not Be Available In This Workbook Or All Macros May Be Disabled
Try reassigning the button to the macro.
Feb
10
awarded  Notable Question
Jan
29
answered Is it possible to have an =if equation involving text and math?
Dec
10
awarded  Popular Question
Dec
9
awarded  Notable Question
Dec
1
awarded  Famous Question
Nov
17
comment Is it possible to invert text and background colors in a PDF when printing?
@fixer1234 Thanks for bringing this to my attention. I have added a link to that page on the Internet Archive.
Nov
17
revised Is it possible to invert text and background colors in a PDF when printing?
added 222 characters in body
Nov
6
answered Excel Find+Replace lowercase after a certain character
Oct
30
comment How to add colored triangles to the corner(s) of a cell?
I don't think there is a way to do this. Excel reserves the red and green triangles as special indicators and I don't think you can override them.
Oct
23
comment Scroll to the right in excel formula entry field
@Adam Glad I could help! This really bothered me too before I figured out the F2 shortcut.
Oct
23
answered Scroll to the right in excel formula entry field
Oct
21
comment Excel - how to drag down formula while keeping horizontal cell reference continuity
@Tanukiarecool You can replace the A2 with ROW()-1. This means that the row number that the formula is in will be used as the offset (after subtracting 1 from it).
Oct
21
comment Excel - how to drag down formula while keeping horizontal cell reference continuity
@Tanukiarecool You're welcome! I see that you asked about inserting new columns. When you insert a column, if you change the $A$1 in the formula to always point to the cell directly to the left of the first column heading, it will continue to work.