Feedback by UserVoice

corey

My feedback

  1. 3,660 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Good news! We’ve started working on this suggestion, and we’re currently testing the improved scrolling experience in our lab. It will allow you to stop partway through the row or column. The sheet will no longer need to snap to the top and left edge of the cells. Since scrolling is such a fundamental and highly used action in Excel, it may take a while to get it right. We hope to have it ready within a few months, but can’t provide an exact target date just yet. Thanks again for all your support and patience for this long awaited improvement.

    We’ll post an update here when we start rolling it out for you to try. It will be made available to Office Insiders first. Here’s how you can join – https://insider.office.com/en-us/join/windows.

    Thanks – Steve [Microsoft Excel]

    An error occurred while saving the comment
    corey commented  · 

    @Futski - Yeah... at least this issue is probably simpler in Excel desktop apps (just use/toggle the appropriate OS UI stuff), since this isn't an issue (scroll wheel vs ctrl+scroll wheel) in most other Windows apps... I have no idea how this is done on Macs.

    With Web apps like Sheets, there's all the UI interactions with different web browsers on the presentation side (IE5???) vs the HTML presentation stuff.

    An error occurred while saving the comment
    corey commented  · 

    I just happened to be playing around in Google Sheets. And it's pretty Excel "feature-compliant" too in this area.
    FWIW, someone has asked about Google Sheets being able to do smooth scrolling:
    https://support.google.com/docs/thread/10891334?hl=en

    corey supported this idea  · 
    An error occurred while saving the comment
    corey commented  · 

    Scroll bars are supposed to move the "window" over the document, or at least, that's how Windows apps have behaved for so long.

    Why the view port window in Excel is bound to cells, causing the scroll bars to act as if you're moving the cursor around, seems silly. Especially without an option to toggle the behavior.

    Moving the scroll bars is not the same behavior as moving the cursor around the document with cursor keys, clicks in the document, etc.

    Word, IE, Edge, etc. certainly don't bind the scroll bars in this fashion.

  2. 631 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks for all your support of this request. We are taking a close look at this along with the related requests about maintaining leading zeros when entering values in cells, and to stop changing values to scientific notation.

    We know these are important issues, so thanks for all the comments and votes.

    Steve [Microsoft Excel]

    An error occurred while saving the comment
    corey commented  · 

    It seems like way back in the day (Excel 4/5/7), there WAS an interactive dialog much like Access had for doing the same thing. But someone in Excel world decided that was "too complicated", and that aspect got removed. I remember it distinctly... (Excel 95?). So we're left with the default behaviors and assumptions we still bang our heads on our desks against left in, with no obvious way to tweak them.

    And IIRC the settings for specific sources could also be saved, like in Access, too.

    I think this data import is still being done via ODBC. so adding a SCHEMA.INI file might help for specific data sources/files, but not in the general sense. (google to read up more on ODBC and schema.ini).

    I've started using Power Query (Excel 2010, 2013) where possible, to get back the interactive specificity back in my hands as well as sane and expected default conversions, and also to be able to save things for reuse.

    ExcelDevs, perhaps redirect the old way to secretly import the data through Power Query now instead of ODBC directly?

    Oh, Power Query is easier to use (e.g., its Ribbons) in Excel 2010/13 compared to how it has been integrated into the Data Tools ribbons in Excel 2016+.

    corey supported this idea  · 
    An error occurred while saving the comment
    corey commented  · 

    hmm. while not convenient, I got around this (for my needs) by using Powershel with Epplus.dll. Epplus works on excel file format directly, leaves formatting control to the developer instead of the "helpful" defaults Excel applies (that can't be overridden easily if at all). Avoids kludges like template spreadsheets (not talking about .xslt files), and is amenable to running on a server to boot.

  3. 1,315 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks for the support and the detailed discussion around this suggestion. We understand that there are some advantages and disadvantages with both MDI (multi-document interface) and SDI (single-document interface), and we currently do not have plans to revert to MDI. We do want to improve the experience with SDI so you can get your work done efficiently, and this post has helped toward that goal.

    Some of the specific issues mentioned are addressed as follows:
    – Stability: This has been a focus over the past several years, and the monthly releases in 2020 have been among the most reliable ever in terms of avoiding crashes.
    - Screen space – while it won’t get all the space back, you can minimize the ribbon to save some space. It only shows when needed.
    - Navigation between workbooks: you can use CTRL+F6, SHIFT+CTRL+F6, CTRL+TAB or SHIFT+CTRL+TAB to switch to the next workbook. …

    An error occurred while saving the comment
    corey commented  · 

    The one really big thing for me that sucks about MDI is that the full file path for a given workbook is not considered the "file name". Sometimes I need to work with a local copy I maintain of a shared document. With MDI, opening both my version and the common version at once in the same Excel instance will of course fail on the second one opened - "can only have one document named X open" or whatever the exact error is. So SDI lets me have both open, and I do want them separate, in two different windows entirely (both docs pull data from a database; I usually want to refresh the data in one and see the diffs between the two).

    At least in Excel 2010, I can right-click on my Excel shortcut in the task bar (win7, win10) and open a new instance of Excel to open up the other version of the workbook in, thus working around MDI. That gives me enough flexibility. Haven't upgraded (home or work) to Excel 2016, so...

    Sorry to rain a bit on the "MDI vs SDI" parade.

    Now, being able to pick two docs in two different instances to sync the scrolling on...that might be cool/useful in some cases, when it just seems easier to visually compare rather than write a bunch of vlookup formulae between the two that I'd have to remove later.

    An error occurred while saving the comment
    corey commented  · 

    yes, I think Ars Technica/slashdot/soylentnews has a story today that all the old support info for Windows 7, Office 2010, et al will be going bye bye. hope those blogs, fora etc are in the Wayback Machine!

    corey supported this idea  · 
  4. 1,555 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks very much for your votes. And to those who took the time to fill in the survey, thank you! This is a brief update to let y’all know that we’ve started work on this feature request along with the one on changing numbers to scientific notation.

    - Urmi [Msft]

    An error occurred while saving the comment
    corey commented  · 

    wayyy back in the day (excel 5? 97?) the data importer worked much more like in Access. Iirc, it was possible to define import specs and use those. I'm sure someone decided to make this all 'simpler', but its been a pain point for some time. At least one can sort of do the same with the text to columns functionality (if your text imported/pasted right...).

    at least Powerquery/PowerBI makes more useful observations and formatting/styles when it imports data, if there is schema info available from the source.
    So maybe PowerQuery/PowerBI is a mire right way to hold Excel, as it were...

Feedback and Knowledge Base