Feedback by UserVoice

Nice Brian

My feedback

  1. 718 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Nice Brian commented  · 

    100% agree. if you asked 1000 users when they copied and pasted in Excel, did they actually WANT to copy and paste the cell borders, formatting, conditional format rules, etc, 999 of them would say they did not. This has been Excel default behaviour for DECADES and it's truly appalling. Paste values should be default, paste formats should be an option you have to select!!!

    Nice Brian supported this idea  · 
  2. 840 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Nice Brian commented  · 

    Wow. I just learned that "Center Across Selection" exists! Thanks! Personally I'd like to see Merged cells destroyed entirely.

    Nice Brian supported this idea  · 
  3. 1,070 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks again for all the passion on this issue – we hear you and we’ll get someone on the team to dig in to the issue. I’ve seen a few related sub-issues while scanning over the comment section for this one, so we may reach out to a few of you for clarifications. Thanks again for all the votes, and keep them coming for the issues you care about!

    John, Excel

    Nice Brian supported this idea  · 
  4. 1,110 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Huge progress update toward historical data! We have released our preview of the StockHistory function! https://support.microsoft.com/en-us/office/stockhistory-function-1ac8b5b3-5f62-4d94-8ab8-7504ec7239a8

    However, this is only available to our Beta Channel at the moment, so when it is rolled out to General Availability, I will be sure to update the status to completed.

    If you are able to use the feature in preview and have feedback, please send-a-frown for us to review.

    —Kaycee Reineke
    Excel PM

    An error occurred while saving the comment
    Nice Brian commented  · 

    Not sure why you want to limit yourself just to MSN Money for your stock prices? You could pull in prices from literally any website with a small amount of VBA and a webquery connection.

  5. 3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Nice Brian commented  · 

    Turn it off then?

  6. 235 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Nice Brian commented  · 

    I used to get this a lot. For me it was always in conditional formatting, someone's copied cells from another workbook that were conditionally formatted with a formula, and that formula linked to the workbook they copied the cells from.

    Now I just don't ever use conditional formatting, and do all my colouring-in using VBA macros. Voila, the problem slowly but surely went away.

    I agree though, I spent days if not weeks tracking down these "broken links" which Excel wanted to warn me about EVERY. SINGLE. TIME. I opened one of the affected workbooks, but kept their actual location a secret!

    Nice Brian supported this idea  · 
  7. 569 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Nice Brian supported this idea  · 
  8. 516 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks for the suggestion Jessica. We’ve got a few other suggestions on the site that are similar with scientific notation, etc. We’ll take a look at this area, and pay special attention to any cases that get a lot of votes. So please keep the votes coming to help us do a good job at prioritizing asks like this!

    Cheers,
    John [MS XL]

    An error occurred while saving the comment
    Nice Brian commented  · 

    I regularly open text files or .CSV files with addresses in. Sometimes the first line of the address is something like "1-1" or "2/3". This is a very common way of writing apartment numbers in the UK. Excel "helpfully" converts these values to "1-Jan" and "2-Mar", and it's infuriatingly difficult to convert them back again. IN our CRM system we have hundreds of customers whose address is 1-1, apartment 12 or something, but on our system it now says they live at the 1st of January. It would be great if users could disable this "date sensing" feature, or at least require it to have a year in the number before it attempts to convert to a date. This is an old feature from I think before Excel '97, I don't think it really helps anyone these days.

    Nice Brian supported this idea  · 

Feedback and Knowledge Base