HackerFriction Feedback

Products · Product

Microsoft Excel

Raised as a usability problem by 520 people on Hacker News over 20 years (2007–2026), in 388 threads.

Ranked by people · period

No issue was raised by at least 3 people in 3 threads this year.

  1. 1
    Opening CSVs silently alters identifiers, wasting hours of fixingUnreviewed

    32 people in the last 5 years · 25 threads

  2. 2
    Spreadsheets are hard to read, audit or track changes inUnreviewed

    8 people in the last 5 years · 8 threads

  3. 3
    Localized function names break formulas across language versionsUnreviewed

    8 people in the last 5 years · 8 threads

  4. 4
    Typed values silently become dates, and the original entry is lostUnreviewed

    7 people in the last 5 years · 7 threads

  5. 5
    CSV files open incorrectly in some locales unless the separator changesUnreviewed

    6 people in the last 5 years · 5 threads

  6. 6
    Spreadsheets are error prone and hide formulas from othersUnreviewed

    5 people in the last 5 years · 3 threads

  7. 7
    Copy, cut and paste behave against the user's intentUnreviewed

    5 people in the last 5 years · 4 threads

  8. 8
  9. 9
    Mac keyboard shortcuts differ from Windows and frustrate usersUnreviewed

    3 people in the last 5 years · 3 threads

  10. 10
    Advanced features are undiscoverable without tutorialsUnreviewed

    3 people in the last 5 years · 3 threads

  11. 11
    Ribbon is cluttered and shortcut key hints are hard to followUnreviewed

    3 people in the last 5 years · 3 threads

  12. 12
    Setting up pivot tables properly takes a while and is hardUnreviewed

    3 people in the last 5 years · 3 threads

  13. 13
    Dragging, copying and cutting treat formula references differentlyUnreviewed

    3 people in the last 5 years · 3 threads

  14. 14
    Mouse-and-keyboard design makes cells hard to use on a phoneUnreviewed

    3 people in the last 5 years · 3 threads

  1. 1
    Opening CSVs silently alters identifiers, wasting hours of fixingUnreviewed

    84 people since the beginning · 61 threads

  2. 2
    Spreadsheets are hard to read, audit or track changes inUnreviewed

    23 people since the beginning · 21 threads

  3. 3
    Typed values silently become dates, and the original entry is lostUnreviewed

    23 people since the beginning · 21 threads

  4. 4
    CSV files open incorrectly in some locales unless the separator changesUnreviewed

    21 people since the beginning · 19 threads

  5. 5
    Spreadsheets are error prone and hide formulas from othersUnreviewed

    17 people since the beginning · 14 threads

  6. 6
    Localized function names break formulas across language versionsUnreviewed

    16 people since the beginning · 15 threads

  7. 7
    Data silently truncated or reformatted, so changes go unnoticedUnreviewed

    8 people since the beginning · 8 threads

  8. 8
    Editing charts takes many clicks and is tediousUnreviewed

    7 people since the beginning · 7 threads

  9. 9
    Copy, cut and paste behave against the user's intentUnreviewed

    7 people since the beginning · 6 threads

  10. 10
    Mac keyboard shortcuts differ from Windows and frustrate usersUnreviewed

    6 people since the beginning · 6 threads

  11. 11
    Advanced features are undiscoverable without tutorialsUnreviewed

    6 people since the beginning · 6 threads

  12. 12
  13. 13
    Pressing F1 for help gives unhelpful resultsUnreviewed

    6 people since the beginning · 4 threads

  14. 14
    Setting up pivot tables properly takes a while and is hardUnreviewed

    5 people since the beginning · 5 threads

  15. 15
    VLOOKUP takes minutes on a few hundred thousand recordsUnreviewed

    5 people since the beginning · 4 threads

  16. 16
    Viewing data requires the editor and opens in the last edited stateUnreviewed

    4 people since the beginning · 4 threads

  17. 17
    Ribbon is cluttered and shortcut key hints are hard to followUnreviewed

    4 people since the beginning · 4 threads

  18. 18
    Formula syntax needs several intermediate steps to get resultsUnreviewed

    4 people since the beginning · 4 threads

  19. 19
    Scrolling thousands of rows in Excel Online is laggyUnreviewed

    4 people since the beginning · 4 threads

  20. 20
    Dragging, copying and cutting treat formula references differentlyUnreviewed

    4 people since the beginning · 4 threads

  21. 21
    Arrow keys sometimes insert cell references and sometimes move the cursorUnreviewed

    3 people since the beginning · 3 threads

  22. 22
    Named ranges pile up, so others can't tell what they refer toUnreviewed

    3 people since the beginning · 3 threads

  23. 23
    Tracking ranges and cross-sheet references is hard in large workbooksUnreviewed

    3 people since the beginning · 3 threads

  24. 24
    Familiar shortcuts stopped working after upgrading to 2007Unreviewed

    3 people since the beginning · 3 threads

  25. 25
    Cells are too easy to change by accident, causing mistakesUnreviewed

    3 people since the beginning · 3 threads

  26. 26
    Menus are hard to navigate and find commands inUnreviewed

    3 people since the beginning · 3 threads

  27. 27
    Animated text input and cell transitions make the sheet feel slowUnreviewed

    3 people since the beginning · 3 threads

  28. 28
    Lookup formulas are hard to use and offer no easier interfaceUnreviewed

    3 people since the beginning · 3 threads

  29. 29
    Autocomplete silently corrupts entered data, such as gene namesUnreviewed

    3 people since the beginning · 3 threads

  30. 30
    Sluggish UI and slow load times on macOSUnreviewed

    3 people since the beginning · 3 threads

  31. 31
    Non-technical users can't combine tables in Power Query without expertsUnreviewed

    3 people since the beginning · 3 threads

  32. 32
    Search is now just an icon, requiring an extra click before typingUnreviewed

    3 people since the beginning · 3 threads

  33. 33
    Mouse-and-keyboard design makes cells hard to use on a phoneUnreviewed

    3 people since the beginning · 3 threads

Every issue, all time, most people first

  1. Opening CSVs silently alters identifiers, wasting hours of fixingUnreviewed

    84 people since 2012, in 15 different years · 2 this year

    2007: 0 people2008: 0 people2009: 0 people2010: 0 people2011: 0 people2012: 1 person2013: 4 people2014: 3 people2015: 2 people2016: 5 people2017: 2 people2018: 3 people2019: 4 people2020: 21 people2021: 11 people2022: 5 people2023: 6 people2024: 13 people2025: 7 people2026: 1 person
    20072026
    Something wrong here?
  2. Spreadsheets are hard to read, audit or track changes inUnreviewed

    23 people since 2013, in 11 different years · 2 this year

    2007: 0 people2008: 0 people2009: 0 people2010: 0 people2011: 0 people2012: 0 people2013: 2 people2014: 0 people2015: 0 people2016: 3 people2017: 3 people2018: 1 person2019: 1 person2020: 3 people2021: 2 people2022: 3 people2023: 0 people2024: 2 people2025: 2 people2026: 1 person
    20072026
    Something wrong here?
  3. Typed values silently become dates, and the original entry is lostUnreviewed

    23 people since 2013, in 11 different years · none this year

    2007: 0 people2008: 0 people2009: 0 people2010: 0 people2011: 0 people2012: 0 people2013: 2 people2014: 0 people2015: 2 people2016: 1 person2017: 2 people2018: 1 person2019: 1 person2020: 4 people2021: 4 people2022: 4 people2023: 1 person2024: 0 people2025: 2 people2026: 0 people
    20072026
    Something wrong here?
  4. CSV files open incorrectly in some locales unless the separator changesUnreviewed

    21 people since 2013, in 12 different years · none this year

    2007: 0 people2008: 0 people2009: 0 people2010: 0 people2011: 0 people2012: 0 people2013: 1 person2014: 1 person2015: 1 person2016: 4 people2017: 1 person2018: 2 people2019: 1 person2020: 4 people2021: 1 person2022: 0 people2023: 3 people2024: 3 people2025: 1 person2026: 0 people
    20072026
    Something wrong here?
  5. Spreadsheets are error prone and hide formulas from othersUnreviewed

    17 people since 2011, in 11 different years · none this year

    2007: 0 people2008: 0 people2009: 0 people2010: 0 people2011: 1 person2012: 0 people2013: 3 people2014: 1 person2015: 1 person2016: 0 people2017: 0 people2018: 1 person2019: 1 person2020: 3 people2021: 1 person2022: 2 people2023: 2 people2024: 1 person2025: 0 people2026: 0 people
    20072026
    Something wrong here?
  6. Localized function names break formulas across language versionsUnreviewed

    16 people since 2009, in 9 different years · 1 this year

    2007: 0 people2008: 0 people2009: 1 person2010: 0 people2011: 0 people2012: 0 people2013: 2 people2014: 0 people2015: 0 people2016: 0 people2017: 1 person2018: 0 people2019: 3 people2020: 1 person2021: 1 person2022: 4 people2023: 1 person2024: 0 people2025: 4 people2026: 0 people
    20072026
    Something wrong here?
  7. Data silently truncated or reformatted, so changes go unnoticedUnreviewed

    8 people since 2013, in 6 different years · none this year

    2007: 0 people2008: 0 people2009: 0 people2010: 0 people2011: 0 people2012: 0 people2013: 1 person2014: 1 person2015: 0 people2016: 1 person2017: 0 people2018: 0 people2019: 0 people2020: 0 people2021: 3 people2022: 1 person2023: 1 person2024: 0 people2025: 0 people2026: 0 people
    20072026
    Something wrong here?
  8. Editing charts takes many clicks and is tediousUnreviewed

    7 people since 2013, in 7 different years · 1 this year

    2007: 0 people2008: 0 people2009: 0 people2010: 0 people2011: 0 people2012: 0 people2013: 1 person2014: 0 people2015: 0 people2016: 1 person2017: 0 people2018: 0 people2019: 1 person2020: 1 person2021: 1 person2022: 0 people2023: 0 people2024: 1 person2025: 0 people2026: 1 person
    20072026
    Something wrong here?
  9. Copy, cut and paste behave against the user's intentUnreviewed

    7 people since 2012, in 5 different years · 2 this year

    2007: 0 people2008: 0 people2009: 0 people2010: 0 people2011: 0 people2012: 1 person2013: 0 people2014: 0 people2015: 0 people2016: 0 people2017: 0 people2018: 0 people2019: 0 people2020: 0 people2021: 1 person2022: 0 people2023: 1 person2024: 2 people2025: 0 people2026: 2 people
    20072026
    Something wrong here?
  10. Mac keyboard shortcuts differ from Windows and frustrate usersUnreviewed

    6 people since 2016, in 5 different years · 1 this year

    2007: 0 people2008: 0 people2009: 0 people2010: 0 people2011: 0 people2012: 0 people2013: 0 people2014: 0 people2015: 0 people2016: 1 person2017: 0 people2018: 0 people2019: 0 people2020: 0 people2021: 2 people2022: 0 people2023: 1 person2024: 1 person2025: 0 people2026: 1 person
    20072026
    Something wrong here?
  11. Advanced features are undiscoverable without tutorialsUnreviewed

    6 people since 2009, in 5 different years · 1 this year

    2007: 0 people2008: 0 people2009: 1 person2010: 0 people2011: 0 people2012: 0 people2013: 0 people2014: 0 people2015: 0 people2016: 0 people2017: 0 people2018: 1 person2019: 1 person2020: 0 people2021: 0 people2022: 0 people2023: 0 people2024: 2 people2025: 0 people2026: 1 person
    20072026
    Something wrong here?
  12. Accidental Enter leaves formula editor and triggers unparseable-formula errorsUnreviewed

    6 people since 2019, in 3 different years · none this year

    2007: 0 people2008: 0 people2009: 0 people2010: 0 people2011: 0 people2012: 0 people2013: 0 people2014: 0 people2015: 0 people2016: 0 people2017: 0 people2018: 0 people2019: 1 person2020: 0 people2021: 0 people2022: 4 people2023: 0 people2024: 1 person2025: 0 people2026: 0 people
    20072026
    Something wrong here?
  13. Pressing F1 for help gives unhelpful resultsUnreviewed

    6 people since 2015, in 3 different years · none this year

    2007: 0 people2008: 0 people2009: 0 people2010: 0 people2011: 0 people2012: 0 people2013: 0 people2014: 0 people2015: 1 person2016: 0 people2017: 4 people2018: 0 people2019: 0 people2020: 0 people2021: 1 person2022: 0 people2023: 0 people2024: 0 people2025: 0 people2026: 0 people
    20072026
    Something wrong here?
  14. Setting up pivot tables properly takes a while and is hardUnreviewed

    5 people since 2017, in 3 different years · none this year

    2007: 0 people2008: 0 people2009: 0 people2010: 0 people2011: 0 people2012: 0 people2013: 0 people2014: 0 people2015: 0 people2016: 0 people2017: 2 people2018: 0 people2019: 0 people2020: 0 people2021: 0 people2022: 0 people2023: 2 people2024: 1 person2025: 0 people2026: 0 people
    20072026
    Something wrong here?
  15. VLOOKUP takes minutes on a few hundred thousand recordsUnreviewed

    5 people since 2016, in 3 different years · none this year

    2007: 0 people2008: 0 people2009: 0 people2010: 0 people2011: 0 people2012: 0 people2013: 0 people2014: 0 people2015: 0 people2016: 1 person2017: 0 people2018: 0 people2019: 1 person2020: 0 people2021: 3 people2022: 0 people2023: 0 people2024: 0 people2025: 0 people2026: 0 people
    20072026
    Something wrong here?
  16. Viewing data requires the editor and opens in the last edited stateUnreviewed

    4 people since 2013, in 4 different years · none this year

    2007: 0 people2008: 0 people2009: 0 people2010: 0 people2011: 0 people2012: 0 people2013: 1 person2014: 0 people2015: 0 people2016: 0 people2017: 0 people2018: 0 people2019: 0 people2020: 1 person2021: 1 person2022: 0 people2023: 0 people2024: 1 person2025: 0 people2026: 0 people
    20072026
    Something wrong here?
  17. Ribbon is cluttered and shortcut key hints are hard to followUnreviewed

    4 people since 2014, in 4 different years · none this year

    2007: 0 people2008: 0 people2009: 0 people2010: 0 people2011: 0 people2012: 0 people2013: 0 people2014: 1 person2015: 0 people2016: 0 people2017: 0 people2018: 0 people2019: 0 people2020: 0 people2021: 1 person2022: 1 person2023: 1 person2024: 0 people2025: 0 people2026: 0 people
    20072026
    Something wrong here?
  18. Formula syntax needs several intermediate steps to get resultsUnreviewed

    4 people since 2013, in 4 different years · none this year

    2007: 0 people2008: 0 people2009: 0 people2010: 0 people2011: 0 people2012: 0 people2013: 1 person2014: 0 people2015: 0 people2016: 0 people2017: 0 people2018: 0 people2019: 0 people2020: 1 person2021: 1 person2022: 1 person2023: 0 people2024: 0 people2025: 0 people2026: 0 people
    20072026
    Something wrong here?
  19. Scrolling thousands of rows in Excel Online is laggyUnreviewed

    4 people since 2013, in 4 different years · none this year

    2007: 0 people2008: 0 people2009: 0 people2010: 0 people2011: 0 people2012: 0 people2013: 1 person2014: 0 people2015: 0 people2016: 0 people2017: 0 people2018: 1 person2019: 1 person2020: 0 people2021: 0 people2022: 1 person2023: 0 people2024: 0 people2025: 0 people2026: 0 people
    20072026
    Something wrong here?
  20. Dragging, copying and cutting treat formula references differentlyUnreviewed

    4 people since 2021, in 3 different years · 1 this year

    2007: 0 people2008: 0 people2009: 0 people2010: 0 people2011: 0 people2012: 0 people2013: 0 people2014: 0 people2015: 0 people2016: 0 people2017: 0 people2018: 0 people2019: 0 people2020: 0 people2021: 1 person2022: 2 people2023: 0 people2024: 0 people2025: 0 people2026: 1 person
    20072026
    Something wrong here?
  21. Arrow keys sometimes insert cell references and sometimes move the cursorUnreviewed

    3 people since 2021, in 4 different years · 1 this year

    2007: 0 people2008: 0 people2009: 0 people2010: 0 people2011: 0 people2012: 0 people2013: 0 people2014: 0 people2015: 0 people2016: 0 people2017: 0 people2018: 0 people2019: 0 people2020: 0 people2021: 1 person2022: 1 person2023: 0 people2024: 0 people2025: 1 person2026: 1 person
    20072026
    Something wrong here?
  22. Named ranges pile up, so others can't tell what they refer toUnreviewed

    3 people since 2016, in 3 different years · none this year

    2007: 0 people2008: 0 people2009: 0 people2010: 0 people2011: 0 people2012: 0 people2013: 0 people2014: 0 people2015: 0 people2016: 1 person2017: 0 people2018: 0 people2019: 0 people2020: 1 person2021: 0 people2022: 1 person2023: 0 people2024: 0 people2025: 0 people2026: 0 people
    20072026
    Something wrong here?
  23. Tracking ranges and cross-sheet references is hard in large workbooksUnreviewed

    3 people since 2012, in 3 different years · none this year

    2007: 0 people2008: 0 people2009: 0 people2010: 0 people2011: 0 people2012: 1 person2013: 0 people2014: 0 people2015: 0 people2016: 0 people2017: 0 people2018: 0 people2019: 0 people2020: 0 people2021: 1 person2022: 0 people2023: 0 people2024: 0 people2025: 1 person2026: 0 people
    20072026
    Something wrong here?
  24. Familiar shortcuts stopped working after upgrading to 2007Unreviewed

    3 people since 2012, in 3 different years · none this year

    2007: 0 people2008: 0 people2009: 0 people2010: 0 people2011: 0 people2012: 1 person2013: 0 people2014: 0 people2015: 0 people2016: 0 people2017: 0 people2018: 0 people2019: 1 person2020: 0 people2021: 0 people2022: 0 people2023: 1 person2024: 0 people2025: 0 people2026: 0 people
    20072026
    Something wrong here?
  25. Cells are too easy to change by accident, causing mistakesUnreviewed

    3 people since 2014, in 3 different years · none this year

    2007: 0 people2008: 0 people2009: 0 people2010: 0 people2011: 0 people2012: 0 people2013: 0 people2014: 1 person2015: 0 people2016: 0 people2017: 1 person2018: 0 people2019: 0 people2020: 0 people2021: 0 people2022: 0 people2023: 0 people2024: 0 people2025: 1 person2026: 0 people
    20072026
    Something wrong here?
  26. Animated text input and cell transitions make the sheet feel slowUnreviewed

    3 people since 2020, in 3 different years · none this year

    2007: 0 people2008: 0 people2009: 0 people2010: 0 people2011: 0 people2012: 0 people2013: 0 people2014: 0 people2015: 0 people2016: 0 people2017: 0 people2018: 0 people2019: 0 people2020: 1 person2021: 0 people2022: 1 person2023: 0 people2024: 0 people2025: 1 person2026: 0 people
    20072026
    Something wrong here?
  27. Lookup formulas are hard to use and offer no easier interfaceUnreviewed

    3 people since 2015, in 3 different years · none this year

    2007: 0 people2008: 0 people2009: 0 people2010: 0 people2011: 0 people2012: 0 people2013: 0 people2014: 0 people2015: 1 person2016: 0 people2017: 0 people2018: 0 people2019: 1 person2020: 0 people2021: 0 people2022: 1 person2023: 0 people2024: 0 people2025: 0 people2026: 0 people
    20072026
    Something wrong here?
  28. Autocomplete silently corrupts entered data, such as gene namesUnreviewed

    3 people since 2021, in 3 different years · 1 this year

    2007: 0 people2008: 0 people2009: 0 people2010: 0 people2011: 0 people2012: 0 people2013: 0 people2014: 0 people2015: 0 people2016: 0 people2017: 0 people2018: 0 people2019: 0 people2020: 0 people2021: 1 person2022: 0 people2023: 0 people2024: 0 people2025: 1 person2026: 1 person
    20072026
    Something wrong here?
  29. Sluggish UI and slow load times on macOSUnreviewed

    3 people since 2014, in 2 different years · none this year

    2007: 0 people2008: 0 people2009: 0 people2010: 0 people2011: 0 people2012: 0 people2013: 0 people2014: 1 person2015: 0 people2016: 0 people2017: 2 people2018: 0 people2019: 0 people2020: 0 people2021: 0 people2022: 0 people2023: 0 people2024: 0 people2025: 0 people2026: 0 people
    20072026
    Something wrong here?
  30. Non-technical users can't combine tables in Power Query without expertsUnreviewed

    3 people since 2019, in 2 different years · none this year

    2007: 0 people2008: 0 people2009: 0 people2010: 0 people2011: 0 people2012: 0 people2013: 0 people2014: 0 people2015: 0 people2016: 0 people2017: 0 people2018: 0 people2019: 1 person2020: 0 people2021: 0 people2022: 2 people2023: 0 people2024: 0 people2025: 0 people2026: 0 people
    20072026
    Something wrong here?
  31. Search is now just an icon, requiring an extra click before typingUnreviewed

    3 people since 2019, in 2 different years · none this year

    2007: 0 people2008: 0 people2009: 0 people2010: 0 people2011: 0 people2012: 0 people2013: 0 people2014: 0 people2015: 0 people2016: 0 people2017: 0 people2018: 0 people2019: 2 people2020: 0 people2021: 0 people2022: 0 people2023: 1 person2024: 0 people2025: 0 people2026: 0 people
    20072026
    Something wrong here?
  32. Mouse-and-keyboard design makes cells hard to use on a phoneUnreviewed

    3 people since 2023, in 1 different year · none this year

    2007: 0 people2008: 0 people2009: 0 people2010: 0 people2011: 0 people2012: 0 people2013: 0 people2014: 0 people2015: 0 people2016: 0 people2017: 0 people2018: 0 people2019: 0 people2020: 0 people2021: 0 people2022: 0 people2023: 3 people2024: 0 people2025: 0 people2026: 0 people
    20072026
    Something wrong here?

This list counts all time; the period switch above only changes the ranking. Each issue is a group of similar complaints raised by at least 3 people in 3 different months and threads. Each line under an issue is Claude Haiku's summary of one of its latest comments, not a quote; follow it to read the comment on Hacker News.

Unreviewed issues were grouped by machine: Claude Haiku labelled each comment as a usability complaint, named what it's about and summed up the problem in a line, and a small model grouped similar problems. Nobody has checked them by hand. Expect mistakes.

The newest 50 complaints