3 ms·

:) I’m kinda both proud and ashamed. I’ve also hated the ergonomics of the formula bar for years, but never tried to do anything about it. I’ll bet I find more

:) I’m kinda both proud and ashamed. I’ve also hated the ergonomics of the formula bar for years, but never tried to do anything about it. I’ll bet I find more weird corner cases with this hot key. My first attempt didn’t handle the autocomplete, and that was a big letdown until I found the workaround. I’m sure I’ll run into something else as well.

snthpy 4y ago
Sorry I'm on my phone right now so can't test this out so what does this do exactly? I just have my formula bar set at 3 lines and F2 edits in the formula box always. I find that works well for me. What frustrations do you have with the default setup?
- function_seven 4y ago
  I like to do multi-line formulas and use indentation as well. To insert a newline you have to press [Alt]+[Enter]. To indent you can’t use [Tab], so you have to manually space it out. My script swaps the [Enter] key behavior so regular pressing inserts the newline and Alt+Enter commits the formula. It also converts a Tab press to 4 spaces (rather than focusing away from the bar)
snthpy 4y ago
Also, are you aware of the new Advanced Formula Environment? https://youtu.be/yIAl1XbuVzU https://youtu.be/yIAl1XbuVzU
- function_seven 4y ago
  I wasn’t until last week. Pony_Sheared linked me to it https://news.ycombinator.com/item?id=34178234 https://news.ycombinator.com/item?id=34178234 I downloaded it but haven’t had a chance to tinker.
cfiggers 4y ago
In return, as a token of my gratitude, I give you a script that allows horizontal scrolling in Excel with Shift + Mousewheel (bafflingly not a default in Excel, even though that's becoming standard almost everywhere else): ; Excel horizontal scroll with Shift + Mousewheel #IfWinActive, ahk_exe EXCEL.EXE +WheelUp:: SetScrollLockState, On SendInput {Left} SetScrollLockState, Off Return +WheelDown:: SetScrollLockState, On SendInput {Right} SetScrollLockState, Off Return #if
- function_seven 4y ago
  I just added it. Yes, thank you, this works great.

snthpy 4y ago

Sorry I'm on my phone right now so can't test this out so what does this do exactly? I just have my formula bar set at 3 lines and F2 edits in the formula box always. I find that works well for me. What frustrations do you have with the default setup?

function_seven 4y ago
I like to do multi-line formulas and use indentation as well. To insert a newline you have to press [Alt]+[Enter]. To indent you can’t use [Tab], so you have to manually space it out. My script swaps the [Enter] key behavior so regular pressing inserts the newline and Alt+Enter commits the formula. It also converts a Tab press to 4 spaces (rather than focusing away from the bar)

snthpy 4y ago

Also, are you aware of the new Advanced Formula Environment? https://youtu.be/yIAl1XbuVzU https://youtu.be/yIAl1XbuVzU

function_seven 4y ago
I wasn’t until last week. Pony_Sheared linked me to it https://news.ycombinator.com/item?id=34178234 https://news.ycombinator.com/item?id=34178234 I downloaded it but haven’t had a chance to tinker.

cfiggers 4y ago

In return, as a token of my gratitude, I give you a script that allows horizontal scrolling in Excel with Shift + Mousewheel (bafflingly not a default in Excel, even though that's becoming standard almost everywhere else): ; Excel horizontal scroll with Shift + Mousewheel #IfWinActive, ahk_exe EXCEL.EXE +WheelUp:: SetScrollLockState, On SendInput {Left} SetScrollLockState, Off Return +WheelDown:: SetScrollLockState, On SendInput {Right} SetScrollLockState, Off Return #if

function_seven 4y ago
I just added it. Yes, thank you, this works great.