4 Essential Excel Settings You Need to Review NOW!

Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-cou...
This video reveals 6 crucial settings you should tweak now for a smoother Excel journey. Perfect for anyone looking to enhance their productivity and ease of use in Excel.
👉 Key Highlights:
▪️ Control Cell Movement on Enter: Learn how to stay in the same cell after pressing Enter, ideal for frequent formula users.
▪️ AutoCorrect for Long Phrases: Save time by setting up auto-completion for commonly used long texts like company names.
▪️ Custom Lists for Quick Filling: Discover how to create and use custom lists for repeated elements like months or departments, applicable across all workbooks.
▪️ Preferred Pivot Table Layout: Set a default layout for pivot tables to avoid constant adjustments, including style and column width settings.
▪️ Streamlined Startup: Adjust Excel's startup settings to suit your workflow - skip the start screen and dive straight into a new workbook.
▪️ Preserve Leading Zeros: Stay ahead with a new beta feature that maintains leading zeros in numbers, crucial for product codes or phone numbers.
🌍 My Online Courses ► www.xelplus.com/courses/
00:00 Change These Excel Settings Now!
00:18 What Happens on Enter
01:46 Long Phrases with AutoCorrect
03:05 Custom Lists
05:03 Pivot Table Settings
07:21 Startup Settings
08:17 Keep Leading Zeros
09:47 Wrap Up
⯆ Link to the blog post: www.xelplus.com/excel-setting...
🎬 LINKS to related videos:
7 Things You're Doing WRONG in Excel: • 7 Things You're Doing ...
➡️ Join this channel to get access to perks: / @leilagharani
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#Excel #exceltips #office365

[@LeilaGharani]

Stay ahead with our Weekly Newsletter. Get the latest insights and updates straight to your inbox 👉 link.xelplus.com/yt-c-newsletter

[@fantasytrain42]

I’ve been using excel since 1992. I still keep finding new things from your videos. Keep up the great work. I need to make your Chanel mandatory at work

[@KV21A]

Custom List is Really Helpful. Thanks for sharing Leila, and your voice is so sweet to hear.

[@BartJanicki]

We all know that you are amazing when it comes to excel and stuff, but I want to tell you, your humor is top tier also.

[@user-ks8dr7ch8t]

😅

[@mulembacial]

​

[@paulinemurray8835]

Absolutely love these tips. So simple and make those repetitive steps so much more efficient

[@averaguilar]

Jeez, you just cannot help but learn with Leila!!!, so smooth and to the point.

[@sunphyre42]

The Pivot Table setting adjustment is SO helpful! I always set up my pivot tables like you did and I had no idea I could change those settings! Thank you!

[@e.bmijaresmarquez323]

The beauty of this video is that I already knew most of the features, but I couldn't even imagine how to upgrade my work with them!!! Just genius!!!! Thanks 😊😊

[@LeilaGharani]

You're very welcome!

[@deanngilliver3374]

Can't wait for the leading zero's option to be released!! This one has been needed for a very long time!! :) Love all your videos... they are so helpful and easy to learn from!! You are my "go to" when I'm stuck with anything! Thank you for sharing!

[@John-bn4pq]

Thank you! I love the view of 'recent workbooks' when I open the Excel app. I'll keep this default setting.

[@maymangundayao]

this is so helpful, especially about leading zeros. been figuring out how to retain the zeros on my report control numbers, now i know. thanks so much.

[@fuzzylon]

Something you didn't mention with autocorrect is that the entries you add here apply for all Office programs not just Excel - which I find really useful.

[@j.ballsdeep420]

Or in reverse, if you don't want shit to autocorrect your _also_ need to do this in ever single office app to shut off autocorrect. Shit is so annoying.

[@bencodykirk]

I was going to say this too. So if you create an AutoCorrect entry in another Office app it will be in Excel too! Sharing is caring!

[@grantpepper1647]

Pivot default info was very helpful. Sometimes it's the small things that make a difference to people's work lives. I have subscribed now, and feel like I have my personal productivity coach, Leila sitting with me as I work. Thank you.

[@zolzin561]

I just find you useful. I just started learning Excel because of my job and your short precise lessons are perfect. Thank you so much!✌️

[@kimwhidby3858]

Loved the pivot table advice

[@Freemarkets1236]

Same!

[@LeilaGharani]

My favorite!

[@craftpassion1812]

LOVE the Pivot table setting!!! Thankyou for showing this

[@silverlicious2086]

Hi Leila. I like the option of changing what happens when pressing 'Enter'. I can see that being useful on projects when developing and testing formulas. Thanks for posting. Cheers from Cincinnati, USA

[@andrewcharlesmoss]

I like 05:03 Pivot Table Settings the most. Really useful way of saving a bit of time if you're using pivot tables often!

[@rajesh300982]

I agree 💯. Thank you Leila.

[@SamirHabib]

Yes you are right

[@RonDavidowicz]

I only wish you could also specify the default number format for the values.

[@LeilaGharani]

@@RonDavidowicz True.

[@lilpinkiy]

this is one of those things that i've always said to myself "i'll google that after this piece of work" and always forget once i've finished the task 😄

[@thenewdataguy]

Thanks! The setting with "Enter" and open screen is really helpful! Really simple settings, but probably most powerful ones!

[@LeilaGharani]

Great to hear!

[@elim1720]

I enjoy your teaching Leila, you are amazing 👏

[@rufaiabeeblahi7452]

You're so amazing. Your excel tips actually changed my life

[@mpugliano]

It would be nearly impossible to find a more impressive and knowledgeable personality on KZbin, thank you so much for the skill in which you bring the information forward.

[@fahadpalladium2]

I couldn't agree more

[@hosenshad5991]

بهترین استاد اکسل دنیا (ممنون از دروس مفید شما)

[@twosongs7396]

I so appreciate your videos, Leila. Thank you so much🌹

[@LeilaGharani]

You are so welcome!

[@rajeevgosavi4514]

Great Leila, All the functions are very helpful for day to day excel workings. Thanks.

[@abdulsaidmkamara7305]

Thank you Leila ! I found the Lists & PIVOT quite good.

[@tomrichardson7297]

Thank You!!! I knew there had to be a way to change the default for Pivot Tables! Your suggestions were exactly what I needed!

[@jollyjuln1054]

Thank you so much. I guess many of us were happy to learn new trick with pivot table style;) And now you can clearly hear a sigh of relief

[@steves6557]

So glad to have stopped by to learn about the Pivot Table Settings. Building a dozen or more Pivot Tables daily and all those [groan] annoying changes from the default wasted a lot of time over the years. No more! Thanks Leila! 👍

[@LeilaGharani]

Glad it was helpful, Steve!

[@diosdadoatendido9418]

Thanks.Leila, I love the custom list.. nice tricks as always.. ❤️ hope you make videos on advanced with multiple xlookup example... Thanks for this, it helps us a lot learning new things again..

[@naseebkhaan6487]

I love all the default Settings... Thanks Leila, big fan of yours... just waiting for the leading zero option in my excel...I love the Pivot setting and its very useful for me :)

[@sushantachoudhury7021]

Thanks, Leila. The pivot tip is definitely going to save some time.

[@thiagarajanneelamegam8640]

Hi Leila, Good day to you ! Always your tips and all about excel information very useful and save the time. Thanks a ton.

[@saritad8606]

Thanks for the Pivot Table tip. So valuable

[@christinejean9134]

The pivot tables settings will really be helpful for me. Than you!

[@djsennhauser]

OMG! Default formats for pivot tables will save me lots of frustration! Thank you for highlighting this!

[@thinkleclt]

Leila I love your videos and your story. I’ve been doing excel for over 25 years and I still usually learn something from your videos. On changing the default behavior of keys like enter. That to me can be dicey. Might make your workstation fit better but then usually any other persons computer you’re on the setting is the other way. Just a thought BUT the great thing about your videos, you are t telling people they have to, just showing the option

[@dsbra1944]

Love the one for pivot tables. Such a time saver!

[@shivanisrivastava5667]

This was totally new! Thanks Leila! 😊

[@vasanths7027]

I Love the way you nailed it in all your videos. Thankkkkkkkkkkkkkkkkkkkkkk You Sooooooooooooooooooooooooooooooooooo Much!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

[@siwokuyushau4669]

Leila. you are superb "custom list was great"

[@2012worship]

Pivot table settings really useful! Thank you for sharing!

[@rosemaryng7994]

The pivot tables setting is amazing. I did exactly the same things as you do every time I use pivot table. I no longer have to now.

[@Elbranto1]

Excellent suggestions, thank you very much. I will use the pivot table options setting immediately!

[@mcwahaab]

I used Ctrl+Enter to stay within the cell but this tip is super handy. Thanks Leila, as always

[@agustinvimar3907]

I really liked the configuration of the dynamic tables, so I can save effort and time, thank you very much and greetings from Mx

[@datasimplify]

Great tips. Thanks Leila. I'm going to activate the 5th right now. It is very annoying to have to always choose the blank workbook. Another that I think is very useful is, in Advanced, the one that allows the editing of cells. I don't like to edit cells when I double-click. I'd rather go the reference that's made there. It is very usefull to review files and immediately go to the sheet or analisys that I want to see! I look forward for another video of you 💚

[@brianpeterson5008]

Pivot Table setting are really helpful!

[@ronaldnayman4841]

Thanks you for these tips. You are a great presenter also.

[@saramurgia8367]

Leila, you have become my guru!

[@englishwithabdullahsafi5034]

Great! I loved the way you teach. I really appreciate your hardwork.

[@DrummerB0y001]

Thank you!!!! I work with product codes all day long and the "Keep Leading Zeros" is a godsend.

[@RA-rh5lb]

all are good tips. I found pivot table and leading zero is extremely helpful. Thanks .

[@AP-eb8hd]

Awesome job as always Leila.. Always find something or other better from your videos.

[@thetuningpoint1600]

you are my Excel Godess , you don't know how much time you have saved for me thanks and love you

[@Marquinhos_1961]

Thanks a lot for you tips, these are awesome, and your English is very easy to understand, I'm from Chile with the intermediate level english, and I can understand all your comments. Bless

[@abrahamj2600]

The pivot table settings are extremely helpful! Thank you, Leila!

[@LeilaGharani]

Glad it was helpful!

[@leerv.]

Leila with more great Excel tips! It's so easy not to look under options, I can't say I'm not guilty of doing the same. There are some good settings worth enabling or disabling (auto-fit columns in pivot tables being way at the top of the list of settings to disable, imo!). Oh, and why yes, my KZbin settings do show me subscribed. I'm going to leave that one as it is! ;)

[@user-cd8nq2ro8n]

i love your presentations, thanks for sharing.

[@GeertDelmulle]

All of these are good suggestions, Leila! The first one I have configured myself for quite a long time already (keep the cell selected). I combine that with the fact that I have unchecked the automatic fill down of the column formula in an Excel Table (I decide on that manually - and I do get a useful icon for that every time the occasion presents itself).

[@LeilaGharani]

Great! Thanks for sharing the table config. I never thought of turning that off.

[@justgettinon]

Can't wait for the last Excel setting to paste including leading zeros to come to my excel! Thanks for the fantastic videos!!

[@7sandip]

Leila you are just amazing.. Great work..😍

[@rajirvin1]

Loved all the settings! Very useful for people like me who have worked a lot in Excel but haven't bothered to look at settings and tweak things to make life better. New subscriber and love your videos. Keep it going 😊🙌

[@LeilaGharani]

Great to have you aboard!

[@jianjunhe3440]

The last one is the most useful for me ☺️, thank you

[@darkersz]

I really like the custom lists. Didn't realise it before, thanks!

[@larryklonowski7913]

Great tips!!! I especially like the pivot table tips

[@nuna9970]

I will love so much more ms excell ❤ ❤ ❤ God is awesome!

[@wilsonmoscoso4620]

Leila, you are the best!!!!!

[@MrVijay20vijay]

Pivot table setting was the best!!

[@shayemoore]

Girl, you are just too good at what you do. I just started watching your videos and I "liked" this video before I even watched it lol.

[@LeilaGharani]

Thank you so much!!

[@rukshik]

The Pivot tip and the custom list are the best... It's going to save a lot of my time... Thank you...

[@LeilaGharani]

Glad to help!

[@saud4it]

Really useful way of saving a bit of time

[@dazzarg5]

Wow! Custom lists are amazing, Thank you 😊

[@The_Ol_Bizzaroo]

Just changed my pivot table settings. So excited about this. Thanks!

[@LeilaGharani]

Fantastic!

[@emilyevans3442]

The default pivot table formatting tip has changed my working life!

[@samantharezek4495]

Loooove the PivotTable default setting...been annoyed by it for so long! Thank you Leila!!

[@LeilaGharani]

Same here :) Glad it was helpful, Samantha!

[@julial7987]

Pivot table setting is just 🔥🔥 you can’t guess how many years of my life I’ve been wasting with this so far 😭 Leila you are a gem ❤️❤️

[@SFUZIMOTO]

Thank you for all the useful videos.

[@berchu4577]

Helpful Video, Thank you, Leila.

[@Stepford]

Big thumbs up for the pivot table defaults tips! Thanks for sharing Leila!

[@LeilaGharani]

Thanks for the thumbs up, Steve!

[@asimali5820]

Amazing! Thank you for letting us learn alot from you....

[@ajs11201]

I agree with the many comments about the Pivot Table settings. That will be enormously helpful. I make a lot of pivot tables, and each and every time, I need to deselect the autoformatting. Changing the global default will be fantastic!

[@LeilaGharani]

Definitely was much awaited!

[@jfoxlim1966]

The pivot table is awesome, save my time from now on, Thank you soooo much. Also the position post ENTER.

[@LeilaGharani]

Glad it was helpful!

[@DinoDelight]

Thanks for the Pivot Table default, wish I knew this previously would of save insane amounts of time

[@marybatiancila5984]

Precise and clear

[@venkatiyer7459]

As usual truly amazed with your Excel Tips ... Thanks a lot

[@LeilaGharani]

Most welcome!

[@steventezcan689]

Thanks Leila! Especially for the auto correction tips!

[@LeilaGharani]

You're so welcome, Steven!

[@neemaz]

Thank you Leila. I will use at least 4 of these tips to expedite my routine work.

[@LeilaGharani]

Happy to hear that, Neema!

[@ananguyen4509]

Thanks Leila so much for the great tips. They are very useful. I like tips No.1, No. 4 and No.5 the most.

[@LeilaGharani]

Glad it was helpful, Ana!

[@carryon2197]

Thank you for the educative & useful video.

[@tylergawne-buckland3924]

Leading zero's tip is so helpful!

[@rrki]

Thanks Leila for good tip. You look great.

[@PhillipAmthor]

Thx for this quality content!

[@Scareware28]

Great stuff Leila! LOVE the last one! Can't wait for it to be out of Beta!

[@ahmadtkar]

Amazing video The ctl enter was so cool

[@calark5812]

Can't wait to have the option of not removing leading zeros. Glad I stuck around to the end and watched your bonus tip.

[@jabirkottiary]

Definitely, very useful tips . ❤❤

[@fatihiadamu4621]

My best excel tutor

[@simonraju3555]

Thank you for your effort, its useful

[@jameslucas5590]

The PivTbl configuration was an eye-opener to me. Thank you.

[@LeilaGharani]

My pleasure, James!