Microsoft is making Excel’s formulas easier
theverge.com
Microsoft is making Excel’s formulas easier
1–10 of 141 posts
Re: Microsoft is making Excel’s formulas easier
#2My current #1 wish for Excel formula entry: Please let me use [Tab] and [Enter] in the formula bar without trying to commit the change!
I like to format my formulas with multiple lines and indentation, but to do that I have to hold down [Alt] and mash the spacebar like a caveman.
I am happy with the new features I've been seeing. LAMBDA() and the new TEXT functions are nifty.
Re: Microsoft is making Excel’s formulas easier
#3Sounds great, but I hope they bring this feature to the local versions of Excel too. Using feature exclusivity to lure people into digital serfdom isn't cool.
Re: Microsoft is making Excel’s formulas easier
#4Great. Can they fix the autocorrect so it doesn't mangle gene names? https://www.nature.com/articles/d41586-021-02211-4
Re: Microsoft is making Excel’s formulas easier
#5My current #1 wish for Excel formula entry: Please let me use [Tab] and [Enter] in the formula bar without trying to commit the change! I like to format my formulas with multiple lines and indentation, but to do that I have to hold down [Alt] and mash the spacebar like a caveman. I am happy with the new features I've been seeing. LAMBDA() and the new TEXT functions are nifty.
And [Home] without jumping to select column A, and the arrow keys should work consistently instead of sometimes moving the cursor and sometimes inserting a cell selection.
Re: Microsoft is making Excel’s formulas easier
#6Is writing a headline as if it were promotional marketing copy just a reflex? I don't think that The Verge is owned by Microsoft (I could be wrong), but otherwise I don't get the tone.
edit: maybe that tone is necessary to convince people that this is a story at all.
Re: Microsoft is making Excel’s formulas easier
#7Is writing a headline as if it were promotional marketing copy just a reflex? I don't think that The Verge is owned by Microsoft (I could be wrong), but otherwise I don't get the tone. edit: maybe that tone is necessary to convince people that this is a story at all.
Advertorial content is essentially a press release written by the business and passed off to friendly, connected journalists. Sometimes they only cut it for length and don't even change the headline.
Re: Microsoft is making Excel’s formulas easier
#8Is writing a headline as if it were promotional marketing copy just a reflex? I don't think that The Verge is owned by Microsoft (I could be wrong), but otherwise I don't get the tone. edit: maybe that tone is necessary to convince people that this is a story at all.
[deleted]
Re: Microsoft is making Excel’s formulas easier
#9My current #1 wish for Excel formula entry: Please let me use [Tab] and [Enter] in the formula bar without trying to commit the change! I like to format my formulas with multiple lines and indentation, but to do that I have to hold down [Alt] and mash the spacebar like a caveman. I am happy with the new features I've been seeing. LAMBDA() and the new TEXT functions are nifty.
I use Option-Enter (on Mac, which is probably Alt-Enter on Windows) to insert line breaks in formulas:
Re: Microsoft is making Excel’s formulas easier
#10My current #1 wish for Excel formula entry: Please let me use [Tab] and [Enter] in the formula bar without trying to commit the change! I like to format my formulas with multiple lines and indentation, but to do that I have to hold down [Alt] and mash the spacebar like a caveman. I am happy with the new features I've been seeing. LAMBDA() and the new TEXT functions are nifty.
> Please let me use [Tab] and [Enter] in the formula bar without trying to commit the change
Exactly, there should be a contextual difference between editing in the cell directly or via the formula bar, when in the formula bar tab and enter should insert a tab or new line. Comment/Ctrl Enter (committing the change) or Escape (reverting the change) should be the only way to exit the formula bar via the keyboard.