5 EXCITING New Excel Features - which is your favourite?

in this tutorial i'm going to highlight some cool new excel features that might have slipped under your radar a couple of which we have wanted forever now these are available to microsoft 365 users and some are so new that they're only available to office insider users on the beta channel now if ever there was a good time to get microsoft 365 it's now and by the way i don't get paid to recommend microsoft products it's just my honest opinion all right let's take a look the ability to unhide multiple worksheets in excel has been at the top of people's wishlist for so long that many have resorted to writing macros to automate this task finally it's here right click any worksheet tab unhide and then in the dialog box you can use control to select non-contiguous sheets or you can hold down shift to select arrange and click ok and now they're on hidden now you can do the happy dance if you work with data that requires large row heights then you'll be overjoyed with the new ability for excel to smoothly scroll across rows without it jumping to the next row this feature is on by default assuming you have the update you should note that the row height is set to a maximum of 409 so if i try and set it to 410 i get the error row height must be between 0 and 409 although you can get around this by merging cells vertically workbook statistics is a handy tool when you're working with large and or complex excel files you'll find it on the review tab and then workbook statistics this opens the workbook statistics dialog displaying counts and other information about the current worksheet and the workbook as a whole the end of sheet cell is particularly useful for detecting cells that excel things still contain data that need cleaning up which is a common problem although thankfully not in this file the navigation pane is a great way to get an overview of the workbook's layout you can open it from the view tab and then navigation you can use the expand and collapse buttons to focus on specific sheets from there you can see the elements that make up each worksheet and navigate directly to them so for example if i want to see what graphic number six is i click on it and you can see it's now selected in the worksheet the icons indicate what type of element it is for example here we have a cell range this is a graphic object for example shapes or icons or images we also have charts and if we look in the analysis tab you can see we have pivot tables and in the data tab we have a table you can use the search bar to search for items by name and you can right click and rename the elements and for object elements like charts that i've selected here you can also delete or hide them if you use conditional formatting with long formulas then you'll be pleased to see that you can now resize the dialog boxes so opening the manage rules dialog box here i can resize it horizontally and vertically i can also edit the rule and resize this one although this only resizes horizontally i can't resize it vertically even though it gives me the pull handle and you'll notice in the rules manager dialog box that we can now duplicate rules directly from here if you don't see these features in your version of office yet you can try updating or switching to the beta channel i hope you're as excited as me about these new tools tell me in the comments below which is your favorite and if you like this video please give it the thumbs up and subscribe to our channel for more and why not share it with your friends who might also find it useful thanks for watching [Music] you

Channel: MyOnlineTrainingHub

Views: 22,699

Rating: 4.9767828 out of 5

Keywords: excel, excel 365

Id: LLxRQJlQ8A0

Length: 4min 15sec (255 seconds)

Published: Thu Sep 16 2021