+ Reply to Thread
Results 1 to 9 of 9

What do you (dis)like in Excel?

  1. #1
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,359

    What do you (dis)like in Excel?

    Hi,
    When MSO2007 appeared, I honestly tried several times to use it. It was useless. I really hated MS for what they had done. MSO2003 is all my love and I used it till 2014 and then installed 2013. I still google some things because I do not know where MS has put them (I know they made a built in search in 2016). But there are some features I enjoy using:
    IFERROR (the best!!!)
    AGGREGATE
    Context-sensitive menu
    adding a new sheet.
    What do you think about it?

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,404

    Re: What do you (dis)like in Excel?

    Dislike - Merged cells. I would remove them from Excel

  3. #3
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,359

    Re: What do you (dis)like in Excel?

    I would not be so uncompromising
    It is a matter of using
    data table and print form are different things.
    I use the attached file as a template very offen.
    Attached Files Attached Files

  4. #4
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,404

    Re: What do you (dis)like in Excel?

    Let's agree to disagree

  5. #5
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: What do you (dis)like in Excel?

    I absolutely hate structured references.
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  6. #6
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,359

    Re: What do you (dis)like in Excel?

    Quote Originally Posted by Tony Valko View Post
    I absolutely hate structured references.
    Tony,
    (What it is?)
    Agree!!!
    Last edited by tim201110; 01-21-2017 at 02:19 PM.

  7. #7
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: What do you (dis)like in Excel?

    I also hate that not all functions can work with 3d references or that some functions won't work when referencing a closed file.

  8. #8
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,359

    Re: What do you (dis)like in Excel?

    Quote Originally Posted by Tony Valko View Post
    I also hate that not all functions can work with 3d references or that some functions won't work when referencing a closed file.
    Tony,
    MVP is not just a title.
    You can talk with MS more freely
    Did you ask them about it?

  9. #9
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: What do you (dis)like in Excel?

    MVP's (and others) have been asking for those things for years!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1