List your fave tips for Excel 2016, Please : - )
List your fave tips for Excel 2016, Please : - )
(OP)
I have been dragged kicking and screaming into using Excel 2016. "Upgrading" from my old Excel 2007 (which was itself another kicking and screaming story).
Okay, it seems to run all of my VBA and standard workbooks without too many hitches [okay, in hindsight that was TIP #3]. But I just don't like the interface. On the other hand, unlike Excel 2007 the "Office bar" can be modified easily by the user [that was TIP #1] (in 2007 the Office bar could be modified but required some very fancy legwork that I was never able to follow, at least in any decent amount of time; one of our programmers here did do so for our commercial software and he attempted to larn me on it).
I've mostly accommodated myself to the new GUI. But the one thing that I just couldn't get accustomed to (well, there is the fact that each workbook now opens in its own window, don't think I'll ever get used to that ... but I am able to use some existing VBA routines to set up a special view of 3 related workbooks, so I'm thankful for that), back to the point, I just can't get used to the abrupt screen change when selecting the File menu. Well, obviously, this is not something new to Excel 2016 and I'm certainly not the only person to be "shocked" by this, as this article indicates http://www.informit.com/articles/article.aspx?p=20.... Okay, and maybe that view has some utility with the Info that's provided.
But I really detested the abrupt change when all I needed to do was to create a new workbook. Even worse is that using the File menu I have to select a Template from which to start my new workbook. (Truth be told, I think even Excel 2007 did this as well but I must have put some tool buttons on the bars to immediately create a new file).
Well, the point of this post is that I am a happy camper now. I put the standard tool button into the Quick Access Toolbar to avoid the full screen File view. But this still made me select a Template. Inefficient use of my time! So then I created a VBA routine to directly create a new blank workbook and I put that in the QAT [that was TIP #2]. I'm very happy now.
What tips do you have? Please share, thanks!
Okay, it seems to run all of my VBA and standard workbooks without too many hitches [okay, in hindsight that was TIP #3]. But I just don't like the interface. On the other hand, unlike Excel 2007 the "Office bar" can be modified easily by the user [that was TIP #1] (in 2007 the Office bar could be modified but required some very fancy legwork that I was never able to follow, at least in any decent amount of time; one of our programmers here did do so for our commercial software and he attempted to larn me on it).
I've mostly accommodated myself to the new GUI. But the one thing that I just couldn't get accustomed to (well, there is the fact that each workbook now opens in its own window, don't think I'll ever get used to that ... but I am able to use some existing VBA routines to set up a special view of 3 related workbooks, so I'm thankful for that), back to the point, I just can't get used to the abrupt screen change when selecting the File menu. Well, obviously, this is not something new to Excel 2016 and I'm certainly not the only person to be "shocked" by this, as this article indicates http://www.informit.com/articles/article.aspx?p=20.... Okay, and maybe that view has some utility with the Info that's provided.
But I really detested the abrupt change when all I needed to do was to create a new workbook. Even worse is that using the File menu I have to select a Template from which to start my new workbook. (Truth be told, I think even Excel 2007 did this as well but I must have put some tool buttons on the bars to immediately create a new file).
Well, the point of this post is that I am a happy camper now. I put the standard tool button into the Quick Access Toolbar to avoid the full screen File view. But this still made me select a Template. Inefficient use of my time! So then I created a VBA routine to directly create a new blank workbook and I put that in the QAT [that was TIP #2]. I'm very happy now.
What tips do you have? Please share, thanks!





RE: List your fave tips for Excel 2016, Please : - )
[TIP #5] Should you happen to have multiple versions of Excel installed it seems that they all use the same personal.xlsb macro file.
For that matter, I'm thinking that they use the same VBE, but I'd have to go back and double check that on the computer on which I have both versions installed.
RE: List your fave tips for Excel 2016, Please : - )
Hallelujah! That's of the best new features I've wanted FOREVER. One of the reasons I have two screens is to have documents side-by-side, and stretching a single window across two displays is just so noob.
TTFN (ta ta for now)
I can do absolutely anything. I'm an expert! https://www.youtube.com/watch?v=BKorP55Aqvg
FAQ731-376: Eng-Tips.com Forum Policies forum1529: Translation Assistance for Engineers Entire Forum list http://www.eng-tips.com/forumlist.cfm
RE: List your fave tips for Excel 2016, Please : - )
Regarding your Tip #2: There is a QAT Icon named New and one named New....
The New icon (ctr+N) creates a plain vanilla workbook.
The New... icon opens opens the File > New window, from which you can choose a template.
You might want to check out...
thread770-425996: Little-known Excel features and functionality
Skip,
Just traded in my OLD subtlety...
for a NUance!
RE: List your fave tips for Excel 2016, Please : - )
RE: List your fave tips for Excel 2016, Please : - )
I am with you on that one! I HATED having to have two excel workbooks in the same parent window. I would go as far as opening a new instance of excel just to have them separate, but then as I'm sure you know, you could not copy and paste formulas between the two instances. Office 2013/2016 are much better in that respect.
RE: List your fave tips for Excel 2016, Please : - )
RE: List your fave tips for Excel 2016, Please : - )
???
Skip,
Just traded in my OLD subtlety...
for a NUance!
RE: List your fave tips for Excel 2016, Please : - )
RE: List your fave tips for Excel 2016, Please : - )
You must have had something wonky in the setup. The default "New" button on the QAT is a standard blank worksheet.
TTFN (ta ta for now)
I can do absolutely anything. I'm an expert! https://www.youtube.com/watch?v=BKorP55Aqvg
FAQ731-376: Eng-Tips.com Forum Policies forum1529: Translation Assistance for Engineers Entire Forum list http://www.eng-tips.com/forumlist.cfm
RE: List your fave tips for Excel 2016, Please : - )
Skip,
Just traded in my OLD subtlety...
for a NUance!
RE: List your fave tips for Excel 2016, Please : - )
TTFN (ta ta for now)
I can do absolutely anything. I'm an expert! https://www.youtube.com/watch?v=BKorP55Aqvg
FAQ731-376: Eng-Tips.com Forum Policies forum1529: Translation Assistance for Engineers Entire Forum list http://www.eng-tips.com/forumlist.cfm
RE: List your fave tips for Excel 2016, Please : - )
TTFN (ta ta for now)
I can do absolutely anything. I'm an expert! https://www.youtube.com/watch?v=BKorP55Aqvg
FAQ731-376: Eng-Tips.com Forum Policies forum1529: Translation Assistance for Engineers Entire Forum list http://www.eng-tips.com/forumlist.cfm
RE: List your fave tips for Excel 2016, Please : - )
yes, that is a great new feature versus Excel 2007. Maybe it was in intermediate versions but new to me.
RE: List your fave tips for Excel 2016, Please : - )
Skip,
Just traded in my OLD subtlety...
for a NUance!
RE: List your fave tips for Excel 2016, Please : - )
More here: Using Flash Fill
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
RE: List your fave tips for Excel 2016, Please : - )
Thanks for that tip. I hadn't seen Flash Fill or the ExtractNums() function before. Those may come in handy.
RE: List your fave tips for Excel 2016, Please : - )
http://interactiveds.com.au/software/RegExpres.xls...
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
RE: List your fave tips for Excel 2016, Please : - )
It now drives me mad when I have to deal with other spreadsheets that aren't written to take advantage of this.
Its made me a lot more efficient at developing spreadsheets!
RE: List your fave tips for Excel 2016, Please : - )
Thanks! I'll check that out. Oh, I guess I have already. I saw the "new" (to me) option to do this customization. This sort of thing was taken away in Excel 2007, prior to that I used custom menus, which was great. This ability is indeed wonderful. Thanks for pointing this out!
RE: List your fave tips for Excel 2016, Please : - )
RE: List your fave tips for Excel 2016, Please : - )
RE: List your fave tips for Excel 2016, Please : - )
About bloody time!
Thanks for that. I hadn't noticed.
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
RE: List your fave tips for Excel 2016, Please : - )
RE: List your fave tips for Excel 2016, Please : - )
TTFN (ta ta for now)
I can do absolutely anything. I'm an expert! https://www.youtube.com/watch?v=BKorP55Aqvg
FAQ731-376: Eng-Tips.com Forum Policies forum1529: Translation Assistance for Engineers Entire Forum list http://www.eng-tips.com/forumlist.cfm
RE: List your fave tips for Excel 2016, Please : - )
Whatever the timing, I'm glad it's possible at last.