<Edit> We are bringing this AMA session to a close. We will scrub through any remaining top questions in the next few days.

THANK YOU for all the great questions, looking forward to our next AMA.
<Edit/>


Hello from the Microsoft Excel team! We are very excited for our 3rd AMA. After some cool product announcements this week we thought you might have some questions for us.

We are the team that designs, implements, and tests Excel & Power BI. We have 20+ people in the room with a combined 400+ years of product knowledge. Our engineers and program managers with deep experience across the product primed and ready to answer any of your questions.

Want to see what is new in Excel, check out this recording from the Microsoft Ignite session What is new in Excel.

We'll start answering questions at 9:30 AM PST / 12:30 EDT and continue until 10:30 AM PST.

After this AMA, you may have future help type questions that come up. You can still ask these normal Excel questions in the /r/excel subreddit.

Excel resources and feature requests: Excel Community | Excel Feedback | Excel Blog

The post can be verified here on Twitter

  • the Excel Team

Comments: 4649 • Responses: 85  • Date: 

RagingNerdaholic13901 karma

open Excel file

do absolutely nothing to modify it

close Excel file

[Save changes?]

Why do you torture us like this? WHY??

MicrosoftExcelTeam2264 karma

Not sure, maybe volatile functions or an add-in / code that is running?

-Sam[Microsoft]

Clippy_Office_Asst4648 karma

Hi guys!

Do you miss me?!

MicrosoftExcelTeam2218 karma

Some days, but fortunately they let you out of the Microsoft Archives some days and we get to see you around campus. -Ben[Microsoft]

MicrosoftExcelTeam718 karma

I miss having fun with my old boss, when I'd use VBA to have you randomly do things to him while he was working. Smitty [MSFT]

MicrosoftExcelTeam595 karma

I do miss your friend the hoverbot. -Eric [Microsoft]

brbball3871 karma

Why does Excel autofit text box (resize shape to fit text) not work for new text boxes created using Office 365?

MicrosoftExcelTeam5736 karma

Oops, looks like this is a bug. Thanks for reporting, we will look at this right away - Sanjay[Microsoft]

PM_ME_AMAZON_CREDIT_2887 karma

What's the biggest mistake (or regret) thats happened within development?

MicrosoftExcelTeam7266 karma

Taking out u/Clippy_Office_Asst -Michael[Microsoft]

epicmindwarp2528 karma

Can you create an option to prevent CSV files opening and dropping the leading zeros?

MicrosoftExcelTeam1457 karma

We hear you, and are investigating making this option easier. We'd love if you could vote for this request that helps us with planning.

It is possible to do this today using the Get Data feature. Go to Data tab of ribbon -> from text/csv -> choose your file from Explorer -> click Edit to go to the Query Editor -> under Applied Steps delete Changed Type (to remove the autoformat to number). From the ribbon, press on "Close and Load". Use Get Data to load the file after that - Excel will remember to load the same transforms applied to this file in the future so it will "just work". - Urmi [Microsoft]

epicmindwarp2233 karma

Hello from the Mod Team at /r/excel!

Will you ever integrate other languages, such as python, into Excel, to complement VBA?

Also, will SQL be integrated better into Excel? The current query viewer is poor, compared to other environments.

MicrosoftExcelTeam1594 karma

Hi Mod Team, thanks for all your hard work!

Lots of options here so folks are aware.. there're several ways to use Python with Excel today already using great open source (including Pandas!) and partner solutions, and through the Microsoft Graph. We also announced ability for Excel to call out to Azure Machine Learning models that could host R or Python within them.

We're working hard to extend the programmability surface area to make sure developers can build very rich solutions that run across platforms, and have been releasing these every month.

For scripting in other languages, yes, this is something we're exploring. Would love the feedback on our User Voice site: http://excel.uservoice.com.

Thanks! - Ash (Microsoft)

MicrosoftExcelTeam280 karma

I'll let others reply on the future plans, but for the sake of completeness Excel already has two more built-in languages: a really old XLM language on macro sheets and a new and powerful M language used by Get & Transform Data. Also you can use Excel from most languages like C# or even PowerShell via interop. - Alex [MSFT]

Fishrage_1513 karma

What are your favourite examples of people using Excel for unusual things?

MicrosoftExcelTeam3930 karma

One of my favorites support requests contained a business justification of "this issue is delaying the space shuttle launch". -Ben[Microsoft]

MicrosoftExcelTeam900 karma

I used it to calculate a nice curve for the top of the fence I built in my back yard. I plotted the natural heights of the posts, and then did a 5th order polynomial fit, and then adjusted the fence height to that curve. -Jeff[Microsoft]

semicolonsemicolon326 karma

Pics or it didn't happen ...

seven3true186 karma

For real. This needs to be seen.

MicrosoftExcelTeam826 karma

Ok, ok. I can get you a pic of the fence tomorrow (I don't typically carry around pics of my fence on my phone). I might still have the spreadsheet I used. -Jeff[Microsoft]

MicrosoftExcelTeam557 karma

Someone once did an AC/DC video: https://www.youtube.com/watch?v=Vs2XUffK-1w Smitty [MSFT]

MicrosoftExcelTeam452 karma

Tracking of pinewood derby results, complete with finish line sensors pushing data directly into Excel spreadsheet :-) -- Alex [MSFT]

MicrosoftExcelTeam287 karma

Here are a few examples from the Excel Blog. I love the Excel RPG! Creative users of Excel - Carlos [Microsoft]

MicrosoftExcelTeam164 karma

Middle school STEM Education using real-time data streaming to Excel! https://www.microsoft.com/en-us/education/education-workshop/ -Johnnie[Microsoft]

ZachDamnit1274 karma

Why can't the auto-scientific notation default be disabled?

MicrosoftExcelTeam889 karma

I know that it can be frustrating entering values and having this happen. We are investigating what we can do to make this better.  You can help by Voting for this issue. For now, you can select a range and format as text prior to entering the bar codes / id numbers. -Eric [Microsoft]

Croemato957 karma

Hey guys,

Is there a way to key into a cell with the writing prompt at the end of the text already in there, so you can add on to it instead of overwriting it?

Edit: Glad there's more people like me.

MicrosoftExcelTeam1686 karma

Yes you can, using F2 shortcut.

Olaf (Microsoft)

Creative_Deficiency836 karma

Always been curious, why do column width and row height use different units for measurements, with the pixels in parenthesis? What even are the units? If you want a cell to be square or any certain ratio, you need to do it based on the pixels.

MicrosoftExcelTeam483 karma

It's complicated. The units for column width are characters. Row heights are in points. Here's a good article about how Excel determines column widths. - Steve [Microsoft]

indonemesis755 karma

Is it true that the Excel logo is an X (and a small L) instead of an E, to avoid this?

MicrosoftExcelTeam892 karma

The Excel logo has been an X and an L longer than these other products have been around. -Eric[Microsoft]

seven3true689 karma

When are we going to be able to play Doom on Excel?

MicrosoftExcelTeam613 karma

As soon as we track down that copy of Excel 95 someone took to "check something really quick" :-) - Alex [MSFT]

MicrosoftExcelTeam539 karma

In order to get Couath / Collab working, we had to deprioritize playing Doom in Excel. Maybe an Add-in will be made? - Michael [Microsoft]

mdr-fqr87454 karma

Thanks for doing the AMA. I have a question about a VERY simple yet useful feature that magically disappeared for recent versions.

I have 2 spreadsheets open side by side. I highlight several cells and get the 'sum' of the numbers, which shows in the bottom Status bar. I click onto the second spreadsheet to type that number. The sum in the Status bar below disappears from the first spreadsheet.

This used to never happen and whatever I had highlighted would remain in the taskbar at the bottom while I clicked the other spreadsheet. This would help me transfer new data from one spreadsheet to another, but now I need to manually add a =sum() in the first spreadsheet so that it shows it physically.

WHY!?!

MicrosoftExcelTeam282 karma

Are you on Windows? Open your first file. Then open a separate Excel process by going to Start > Run and type excel /x Then open the second file. Let me know if it works! -Dave [Microsoft]

derekcanmexit429 karma

How large is the Excel team compared to the other product teams (ie. Word, PowerPoint, Access, etc.)?

MicrosoftExcelTeam1803 karma

We are the XL team ;-)

fisch09416 karma

Have you ever considered integrating excel formulas into other Microsoft Office tables? Whenever I work on a table in OneNote or Word I find myself wanting to type =sum()

MicrosoftExcelTeam420 karma

Word has some basic formula capabilities ...

-Sam[Microsoft]

beyphy358 karma

Do you guys have a preference internally between A1 and R1C1?

Also, what new features are you most excited to introduce into Excel that you're able to talk about?

MicrosoftExcelTeam250 karma

Depends on what you mean by "preference". Internally, references are parsed to just row and column numbers, and so the distinction between R1C1 and A1 goes away. It's only when parsing formulas or displaying them back to the user that A1 versus R1C1 applies. -Jeff[Microsoft]

MicrosoftExcelTeam189 karma

We recently announced Insights and new data types coming to Excel beginning late this year. Insights helps identify trends from data in your worksheet as a starting place for exploration. New data types like stocks and demographics will also be added to Excel for easier analysis. More information can be found here:

https://techcommunity.microsoft.com/t5/Resources-and-Community/What-is-new-in-Excel-Ignite-2017-announcements/m-p/117029#M131 -Jen [Microsoft]

beyphy7 karma

Ah I see. I meant when you have to write a worksheet formula, or a formula in VBA, do you have a preference between A1 and R1C1?

MicrosoftExcelTeam19 karma

I personally always use A1, as it is the default. The only advantage I can think of for the R1C1 format is the ability to specify relative position. For instance, R[0]C[-1] refers to the cell in the same row and one column to the left of your current cell. But really, I pretty much never use R1C1. -Jeff[Microsoft]

charonpdx288 karma

When will the Mac version get multiprocessor support?

MicrosoftExcelTeam260 karma

Thanks for the question - we are actively working on this, but you can add your vote to support it anyway on Excel.UserVoice.com.
- Steve [Microsoft]

MicrosoftExcelTeam226 karma

Thank you for all your great questions, we are out of time for now.

We really love doing AMA's and will look forward to the next one. We will make sure to check back and try and answer your questions.

The Microsoft Excel Team

Let me share some useful links that might help you.
RedditExcel CommunityExcel What Is NewExcel FeedbackExcel Help
Excel Support
Excel Training
Excel Blog

jfjeschke164 karma

1. Any plans for Cortana?
2. What are the major changes in Excel 2019?
3. Have you guys seen this?

Thank you, appriciate the AMA

MicrosoftExcelTeam861 karma

  1. it is a great idea (a partner already created a prototype).
  2. We have not fully locked the feature list yet, but we will post it to our Excel Blog as soon as we do

  3. Yes, have you seen this

swankydoodoo145 karma

What's the best way for me to become the 'Excel Guy' at work?

MicrosoftExcelTeam636 karma

1. do vlookup and pivots
2. ????
3. profit as the Excel Guy

-Sam[Microsoft]

MicrosoftExcelTeam102 karma

I'm betting if you make sure to mention your love of Excel in every conversation you have at work you will quickly become the "Excel Guy". Most people I have found who become the expert at work find out how to create useful spreadsheets that get shared around the office. O r they help others use automation to avoid tedious repetitive tasks. -Ben[Microsoft]

MicrosoftExcelTeam5 karma

I learned a lot about Excel charts from reading Jon Peltier's blog: https://peltiertech.com/ - Alex [MSFT]

MicrosoftExcelTeam4 karma

Excel Training  You can also use our Take a Tour template (File-> New) and of course /r/excel - Sanjay[Microsoft]

mrmariomaster135 karma

What is the most amazing thing you've done with Excel?

MicrosoftExcelTeam311 karma

At a different Job during my 2nd and 3rd year in University, I used Excel and Geographical Information Systems (GIS software) to detect and prove fraud. The calculations within Excel took 10 minutes because of how large the workbooks were. – Michael [Microsoft]

MicrosoftExcelTeam283 karma

A long time ago, not very far away, I analyzed my Halo 2 data in Excel and it was popular for 15 mins.

-Sam[Microsoft]

MicrosoftExcelTeam162 karma

In a prior life, I did a stint as an analyst within a corporate Fraud Investigation Unit. Using Excel, we identified a conflict of interest situation where an employee of the accounts payable department was hiring a family member for work. We found this by using a combination of Text and Lookup functions (INDEX/MATCH/VLOOKUP) comparing addresses and phone numbers between employees and vendors. This resulted in the employee getting fired and having to pay back multiple thousands of dollars back to the company. It wasn’t necessarily a very complex workbook, but it had a significant impact. -Carlos [Microsoft]

MicrosoftExcelTeam111 karma

That's a tough one. I built an interactive mapping tool for a large shipping company that used shapes to map which ships were in which berths/when, and how big they were. Smitty [MSFT]

bugginryan90 karma

VLookup or Index Match?

MicrosoftExcelTeam243 karma

INDEX/MATCH - Once you get used to it, you can write them almost as fast as VLOOKUP, and the combination is more powerful/efficient. Smitty [MSFT]

fisch0955 karma

I know it's not the intended purpose of excel, but excel games made otherwise boring days behind my desk wonderful. So thank you for that.

What excel features both built-in or not do you wish more people knew about/or knew how to use?

MicrosoftExcelTeam56 karma

I love seeing what kind of creative things people come up with in Excel! It makes learning it so much more fun.

For features, mine is PivotTables, especially creating table relationships with the Data Model. Smitty [MSFT]

MyStatAccount35 karma

Thanks for making such an awesome tool! I use it every day. A couple questions:

  • What are the most interesting or strange uses of Excel you've seen?

  • What feature or function would make the biggest difference in peoples lives if only they knew it existed?

  • Any chance of an update to the VBA editor? I'm not talking anything crazy, but line numbers for reference would be nice. I maintain lots of old spreadsheets, so I won't be transitioning away from VBA anytime soon unfortunately.

MicrosoftExcelTeam50 karma

Thank you for your comments! Answers to your questions below:

  1. We have a few answers for this question already here

  2. My personal favorite is the new Get & Transform (aka Power Query) functionality, I think this would make a huge difference. We know from our research, that a lot of time is spent cleaning and shaping data before being able to analyze it, Get & Transform makes this super easy. You can learn more here. Other key ones include PivotTables, Conditional Formatting, and a handful of functions (e.g. IF, TEXTJOIN, INDEX/MATCH/VLOOKUP)

  3. We love VBA, and we appreciate the broad user base, and impact it continues to have in the world. That said, we have nothing to announce in this space right now. For more context here is a link to an in-depth perspective about VBA and how we think about extensibility in general See VBA.

Carlos [Microsoft]

Watalemon18 karma

Will there be another revamp to the user interface for Excel like what we saw from 2003 to 2007? Also any plans to incorporate big data analysis tools into Excel?

MicrosoftExcelTeam16 karma

We continue to evaluate complexity vs simplicity for our interfaces and users are most welcome to request new changes through our user voice site.

For Big data analysis , we would point towards our new Get and Transform functionality that should easily help you analyze your big data.

boondoggie423 karma

Why is the print button hidden in the File screen? Why isn't it on the Home toolbar, or next to the Save icon at the very top?

MicrosoftExcelTeam8 karma

You can add the Print button (or any other button) by customizing the Quick Access Toolbar (that little area near the save icon). Click on the little down-arrow on the right of the QAT in the most recent versions, or right-click on the QAT to customize it. Check out: https://support.office.com/en-us/article/Customize-the-Quick-Access-Toolbar-43fff1c9-ebc4-4963-bdbd-c2b6b0739e52

To explain the reasoning, when we re-organized the commands into the Ribbon, the idea was that we would put the document-level actions into the File space, and not into the Ribbon (including Home). - Charlie [Microsoft]

Jbrookes93 karma

Hello team!

Will it ever be possible to include VBA functionality in the collaborative Excel Online version?

When building sheets for clients who use workbooks in a collaborative nature it is very restrictive as no VBA function will work.

Thanks!

MicrosoftExcelTeam3 karma

You can use JavaScript API's. Check out ScriptLab, which is an add-in that lets you work with them directly in Excel: https://appsource.microsoft.com/en-us/product/office/wa104380862 As it stands now, we're at about 1/3 parity with current VBA methods and procedures, and the team is working hard to add more all the time. Smitty [MSFT]

semicolonsemicolon3 karma

Thanks so much for doing this AMA. Have you guys thought of a way to restructure the sheet-to-sheet navigation on workbooks with multiple worksheets to be able to more easily view all of the worksheets and jump to them (I'm thinking like about the way in Windows you have that neat-o cascading windows view using a the WindowsKey-Tab combination)?

MicrosoftExcelTeam4 karma

Thanx for the question! Btw, have you considered trying our "Window View" functionality...https://support.office.com/en-us/article/View-two-or-more-worksheets-at-the-same-time-1DEED3DA-A297-4260-98AA-A7B2D90C81AB?

thanx, Prash[Microsoft]

MicrosoftExcelTeam1 karma

I think you are on the Mac? If so, open your files. Then go to Window>Arrange>Horizontal. Then press Command, ~ to move focus between the files. Let us know if it works! -Dave [Microsoft]

Munkadunk6673 karma

When can the Mac versions natively support multi users? I know the online version does, but can we see this functionality come through on Office 360, or Dropbox? My business relies on a few guys using the same spreadsheet a lot and one sheet in particular uses macros once a week to update it. Seeing live updates would help us not move away from Excel. We'd really hate to! Thanks!

MicrosoftExcelTeam3 karma

We have great news about this. It's coming soon, and the latest Insiders Fast preview allows you to work together on the same workbook already. You can read more about the update here - Major update to Office for Mac. -Steve [Microsoft]

charonpdx3 karma

Their standard answer for “when will the Mac version support…” (anything) is “we’re working on it!”

Im old enough to remember when the Mac version got all the good features first. Sad that it’s basically forgotten now.

MicrosoftExcelTeam3 karma

I work on the Excel for Mac team and we are definitely listening to customer feedback and getting all features built into Mac Excel. You can opt into the Insiders Program, and get the Fast Insiders update which has all the new features from UserVoice with status of "Started". So it's definitely getting a lot better and very soon! -Sangeeta [Microsoft]

MicrosoftExcelTeam2 karma

To see how coauthoring works in Excel for Mac, you can opt into the Insiders Program, and get the Fast Insiders update. Please remember to send us your feedback by clicking on the Smiley-face button near the top corner of the app. -Steve [Microsoft]

charonpdx2 karma

Can you get multiprocessor support in the Fast Insiders builds soon? Not being able to use the 16 threads available on my Mac Pro in a DATA CALCULATING app, over 20 years after multiprocessing became common on Mac OS/Mac OS X/OS X/macOS, is ridiculous. (And 12 years since it became standard on every new Mac sold.)

MicrosoftExcelTeam2 karma

Please see the question regarding multi-threaded calculation - Steve [Microsoft]

MyStatAccount3 karma

What's the weirdest bug you've had to fix?

MicrosoftExcelTeam13 karma

I did not personally fix this one, but Excel 2007 displaying 850*77.1 as 100000 was as weird as they come. - Alex [MSFT]

epicmindwarp2 karma

What was the reason behind the bug? Seems like something to do with a short?

MicrosoftExcelTeam5 karma

The error was in assembly module with IIRC AX register being used instead of AH, so, in essence, you are correct. - Alex [MSFT]

jklacy32 karma

When do you plan on providing active directory authentication to Azure Data Warehouse?

MicrosoftExcelTeam2 karma

We're working on this! It'll show up in Excel through 'Get and Transform Data' in the future, you'll probably see it in Power BI first.

Excel10x2 karma

Any new features for Data Analytics??

MicrosoftExcelTeam2 karma

Take a look at this session from Ignite, we covered some of the new analytics capabilities there.

user6991 karma

What are the plans for introducing new functionality to non 365 versions of Excel? It seems like some of the new functions are available in Excel 2016 for 365 but not in the retail/OEM 2016.

MicrosoftExcelTeam2 karma

New features are continually added to Office 365 subscriptions and perpetual versions of Office (e.g., Office 2010, Office 2013, and Office 2016) receive bug fixes and security patches but no new features. We recently announced another version of perpetual, Office 2019, will be released in the coming year which will have additional features beyond Office 2016. This feature set will be announced closer to the release. -Jen [Microsoft]

cobaltcollapse1 karma

How often do you guys call something excellent?

MicrosoftExcelTeam1 karma

Everything is either "excellent!" or "bogus!" -Jeff[Microsoft]

yimenfu1 karma

Are there any plans to scale the computing power to be able to handle big data analytics? (to a similar scale of databases and competitor products like Alteryx)

MicrosoftExcelTeam1 karma

Yes! We already have capabilities in this area - take a look at what you can do through Power Query / 'Get and Transform Data' and Power Pivot. Excel and Power BI are certainly planning more investment for analytics so stay tuned...

MicrosoftExcelTeam1 karma

Have you tried farming out your computations to HPC: https://blogs.office.com/en-us/2010/02/08/calculating-excel-models-on-an-hpc-cluster/ ? - Alex [MSFT]

ChernobylPrize1 karma

Are there any plans to change how the clipboard is handled? It would be nice if making a small change to a cell didn't empty the clipboard.

MicrosoftExcelTeam3 karma

Great News! Earlier this year we made the "Keep the Copy" feature available to Office 365 users. Now most edits in Excel don't remove the copy marquee. -Eric[Microsoft]

schaumann1 karma

Hey guys, I LOVE Excel and have been using it since '97! If you were to look back to Excel '97, what's your biggest "I can't believe this feature didn't exist back then" in comparison to today's version?

MicrosoftExcelTeam2 karma

Mine is definitely big grid; 65,536 x 256 is so limiting. - Alex [MSFT]

MicrosoftExcelTeam1 karma

'95 for me! I'd have to go with be PivotTable relationships with the Data Model. It essentially replaces what I used to spend hours a week on in Access or SQL Server. Smitty [MSFT]

kbouser1 karma

How much of Charles Simonyi is still in the current code base of Excel? We have heard so much about his "hungarian notation" and such. Are there traces of his ideas still lurking in modern Excel code?

MicrosoftExcelTeam2 karma

Well, we certainly still use Hungarian notation. Other than that, I haven't noticed his alias in the code at all. -Jeff[Microsoft]

kitikitish1 karma

What's for dinner?

MicrosoftExcelTeam5 karma

Waffles. They are grid-shaped. - Michael [MSFT]

MicrosoftExcelTeam3 karma

=Dinner("pasta","sauce","meatballs","parmesan")

-Sam[Microsoft]

monkeymania1 karma

Everytime I open a .xlsm file, my formula settings are switched to calculate manually. Why? When I go back to a normal .xlsx file, the setting is stuck on manual (until I go and change it back).

I'd love to know if this was intentional, and if so for what reason? And (most importantly) if I can do anything about it. Thank you!

MicrosoftExcelTeam2 karma

The setting is saved with the file, if you switch it back to automatic and save it should stay in automatic. But because it is a Macro file it could be there is some code that sets it back to manual. See this support document for more info.

joecarter931 karma

In future versions of excel will there be the option to use Multiple Document Interface (MDI) instead of Single Document Interface (SDI) ? I have a very complex model that a consultant developed for us in Excel 2007 that no longer opens correctly when our organization switched to Excel 2013. The macros developed for it relied on the MDI and the switch to SDI stopped them from working.

I have seen other many other users with the same type of issue, but so far there has not been many answers or support on this issue.

MicrosoftExcelTeam2 karma

Thanx for the question Joe! As it stands, there are no known plans to introduce MDI, that said feel free to add your vote on https://excel.uservoice.com/.

You may also want to consider reviewing "Consideration for VBA code" in the following article https://msdn.microsoft.com/en-us/vba/excel-vba/articles/programming-for-the-single-document-interface-in-excel

thanx, Prash[Microsoft]

sweet-tuba-riffs1 karma

How in tarnation can I apply the same pattern of formulas to each row or culumn?

MicrosoftExcelTeam1 karma

Could you elaborate? Filling right, filling down, or ctrl-entering might be the answer, but I would need to understand more details of what you're trying to do. -Jeff[Microsoft]

DanDierdorf1 karma

Thank you for keeping keyboard shortcuts, though these do seem to be less and less user friendly with each major upgrade. When designing the interface, please try to make all major choices easy to use with keyboard only. (Fonts and colors, etc. are fine for mouse work).

MicrosoftExcelTeam2 karma

Keyboard shortcuts are very important and we don't make changes lightly, so please let us know specifically which shortcuts have become less user-friendly so we can understand your comment better. - Steve [Microsoft]

IAmNotAVector1 karma

Hi Guys! Thanks for doing this AMA. My question is are there any features that you wish Excel had but it doesn’t yet or aren’t possible to include?

MicrosoftExcelTeam2 karma

Yes, we love all the features users as us on UserVoice. Good news is that we are working very hard to include them.