Tuesday, April 9, 2013

My Excel 2016 Wishlist

Today, I started thinking about my Excel 2016 wishlist. Microsoft Excel has been updated every three years beginning in 2007. Knowing this, we can only assume the next edition of Excel will come out in three years from now in 2016. The latest update, Excel 2013, includes new tools like FlashFill, PowerView, Timeline Slicer, and over 50 new functions. Don’t get me wrong, Excel is a very powerful tool but it’s not completely perfect yet.
excel 2016 logo

Thus, it’s never too early to start thinking about the next edition of Excel and what improvements can be made. There are a number of features that I think would make creating spreadsheets even easier. A couple of simple improvements could help save users even more time. Here are some of the things I’d like to see in Excel 2016:



  • A FIXTODAY() function that holds the date of the day the formula was first created or entered into the spreadsheet.
  • I don’t know if this will ever be possible outside of Google Docs but allowing multiple users to edit the same document at the same time would be wonderful.This would eliminate all those extra copies of spreadsheets floating around.  This option is already available!
  • I don’t know why you can’t do this already but it would be great to be able to unhide multiple worksheets at the same time. Currently, you can only unhide one sheet at a time which can be a major headache and quite inconvenient.
  • Along this same line, I would like the ability to unprotect multiple sheets at once. Something like a global password may be the solution.
  • An easy way to be able to see exact revision history.
  • More options when protecting a sheet, like being able to use CustomViews.
  • More text manipulation functions and options.

That’s what I think. What about you? What would you like to see in future versions of Excel? What’s on your Excel 2016 wishlist? Please let me know in the comments below. Who knows, maybe Microsoft will even be taking notes!

2 comments:

  1. great ideas!
    I also like the unhide/hide multiple worksheets - I made a macro to do it for me - when developing I have a button on the main page - when ready to release it I delete that button.

    One thing I would like to see is treating different portions of the worksheet as different regions (think of divs on a web page) so that you can hide/unhide content and treat a worksheet like a dynamic web page

    ReplyDelete
    Replies
    1. Thanks for the comment Karl! I'd never thought of it before but I like your idea of being able to divide a worksheet into different regions or zones.

      Delete

I'd love to hear from you!
-Nick