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

15h
answered Error: The Macro May Not Be Available In This Workbook Or All Macros May Be Disabled
21h
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.
1d
comment Error: The Macro May Not Be Available In This Workbook Or All Macros May Be Disabled
Try reassigning the button to the macro.
2d
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.
Oct
21
answered Excel - how to drag down formula while keeping horizontal cell reference continuity
Oct
19
revised Is there any formula which should insert time which should not auto update in the excel sheet?
clarified
Oct
19
answered Is there any formula which should insert time which should not auto update in the excel sheet?
Oct
15
answered copying bank account information into excel / google sheets, lists all info in 1 column instead of grid formation