Hands down, this is the Excel tips video with the most and greatest tips in the short period of time. Nicely done!
@ExcelCampusАй бұрын
Thanks for the feedback, Sam! 😀
@samsmythsenior811Ай бұрын
@@ExcelCampus Thanks to you for producing such informative quality.
@todds9839Ай бұрын
A 25+ year Excel user learned more than 30% of those features today. 🙂 Thanks!
@ExcelCampus27 күн бұрын
You're welcome! 😀
@barttitulaerexcelbart9400Ай бұрын
Lock the drawing tool, and the selection : great tips!!
@rjbjajjjmj1Ай бұрын
Agreed; that was the one that had me saying, "I wish I'd known that before!"
@tomwelt1825Ай бұрын
Jon, I've been using Excel for decades, but I never realized you could double-click on the Format Painter to repeat use. What an awesome revelation. That example was my favorite. Keep up the great videos!
@ExcelCampusАй бұрын
Thanks, Tom! 😀
@BeugsTheLegendАй бұрын
My favorite was double clicking to hide the ribbon. I didn’t know that one and it will help tremendously.
@TrevB_Wakefield4 күн бұрын
Though I've used Excel for many years, first at work and now at home, I've learnt several useful tips here. My favourite is double-clicking the Format Painter to lock it, rather than having to keep clicking on it to reformat several other cells on different parts of the worksheet. It certainly saves time! 😃👍
@seandudley927929 күн бұрын
Just like a previous comment, I have used Excel for years but not seen most of these shortcuts. Thank you
@ExcelCampus27 күн бұрын
You are welcome! 😀
@JHatLpoolАй бұрын
All tips are good and very useful. I like the tips at 00:20 and 00:35 (workbooks containing multiple sheets, moving between these sheets etc.).
@samogoro536118 күн бұрын
Thanks for sharing these great tips. It will take away my stress and make my work smarter
@dividendtimes21 күн бұрын
'Name Box Range Selection' - I have a worksheet that I was scrolling several thousands of rows using page down on a regular basis. This takes me right to my target point. I knew Excel had a work around and you just showed me. Thanks.
@RobertAfrick24 күн бұрын
Just when I thought I knew EVERYTHING about Excel…your Excel video shows up in my mailbox. As always, Jon, thanks for another fabulous set of tips so well put together. There’s nobody like you! Please keep them coming!
@charlesnazare7358Ай бұрын
I loved the double clicking on the format painter! Thanks Jon!
@waynethompson5098Ай бұрын
Outstanding tips. Love the right-click on sheet arrows to obtain a list of sheet names for easy navigation.
@marlenemccullough1567Ай бұрын
I knew several of these short cuts which are super helpful; the F2 button for entering/editing a cell was new to me and will have to try that one. The other one was the fill handle, I have known about putting cursor in the bottom right corner and dragging but double clicking to auto fill/update the cells is very helpful. I will be forwarding this to staff in the office so they can learn new tricks as well, if they don't already know. I believe half the staff I have forwarded emails from you to them and they may already be on your email list. I really like the tips and tricks - although some of the more advanced tips are over my head - but at least the accounting staff can find them useful. Thank you Jon for all the great information.
@jimeads3460Ай бұрын
I didn’t know you could lock the Format Painter. I will use that a lot. Great tips!
@terrywilliamson206721 күн бұрын
I didn’t know about “Fit to selection” to automatically zoom in on the cells you have highlighted - handy!
@joukenienhuis688821 күн бұрын
Wow, great tips! I only am very bad in remembering, so I will have to review these tips again and again. But I loved the lock mode and the zooming selection
@alexanderbenson160224 күн бұрын
My favorite was either the select range option, or the double click to keep the formatting painter on
@mohemmedansari86644 күн бұрын
Likes the format locking. Didnot know of it.
@HandelMcHandelАй бұрын
The select shapes tip was excellent- also the format painter double click - I knew this before but had forgotton it
@hagun6535Ай бұрын
The zoom out for named ranges is very helpful
@PradeepKumarSingh28 күн бұрын
I like select the object selection button and drawing lock option. Thank you sir for this knowledge sharing. 🙏
@ExcelCampus27 күн бұрын
You are welcome 😀
@stephenl5693Ай бұрын
It's always great to keep the brain refreshed and constantly learning little features/shortcuts 👍, thanks for the video!
@ajrawlingsАй бұрын
Did not know about the 'Lock Drawing Mode' - that will certainly help now! 🙂
@soniccheese01Ай бұрын
Thanks Jon, love the Lock Drawing Mode
@randyhaimila6476Ай бұрын
As always, great job John. I especially liked being able to add the sheet number to the status bar. 👍 Also, starting at 2:18, I like how we can select cells like that.
@h.esther9400Ай бұрын
The tips about the status bar are cool seem really interesting but the best tip might be clicking to collapse the ribbon! 🎉
@Malconceivance20 күн бұрын
OMG i learned more in 8 minutes than the last 6 weeks i've spent in an Excel CLASS. Thank you. Favorite short cut here? Probably the Status bar trick for adding the sum etc. to a cell and/or adding options to the bar area.
@judywilder7883Ай бұрын
Format painter lock mode was something I did not know! That will save some time for sure👏
@HeddyB20 күн бұрын
Amazing! Thank you so much!!
@acreguy315628 күн бұрын
I only knew one of these. The rest are new! Thanks Jon!!!
@ExcelCampus27 күн бұрын
Welcome 😀
@nboisenАй бұрын
Locking the drawing tool was a new one for me and one that will come in handy
@jamiereife558111 күн бұрын
The zoom was my favorite
@sallyho146Ай бұрын
Thank you. F2 and arrow lock down are cool
@rrkiАй бұрын
All tips are really helpful. Great video, thanks a lot
@freezendog7Ай бұрын
Great video Jon, even for the more advanced user. I've learned some new tricks. That F2 edit / enter mode works a treat in the conditional formatting menu when you want to write a formula for the conditions. All the best!
@ExcelCampusАй бұрын
Thanks! I’m happy to hear you learned something new. 😊
@kapibara2440Ай бұрын
Good video, thank you 🎉
@keeney413Ай бұрын
your content is so freaking helpful
@tammymheinАй бұрын
Great tips. The steps moved fast but very helpful.
@ExcelCampusАй бұрын
Glad it was helpful! 😀
@birgerkagan6087Ай бұрын
What a fantastic amount of great tips both here and in other videos from other Excel experts - I wish I could remember more of them
@user-dn5gd1rn9fАй бұрын
Thank you very much! The select objects tip is my favorite- did not know that one!
@pionytudr16 күн бұрын
Some pretty nice tips there. Thanks!
@ExcelCampus15 күн бұрын
Welcome! 😀
@2bczar4uАй бұрын
Hard to pick. I just plain love shortcuts. Collapsing the ribbon and using the Quick Access toolbar (for any 365 products) is the way I work.
@josealvesferreira1683Ай бұрын
You are very, very good, I think this tips are very usefull. Thanks
@ExcelCampusАй бұрын
Thanks, Jose! 😀
@notesfromleisa-landАй бұрын
My favorite KZbin hack: For all of the Excel tips and tricks that you know you won't remember, create a saved list call Jon's Excel Hacks and save the video for your future reference. Favorite? Like picking a favorite child. (1) Lock the drawing tool. (Though I don't draw much). (2) Double clicking on the Toolbar to collapse and restore. My all time favorite tip from you is your running totals in tables. It is a feature I use a lot, and your method is both simple and effective. My personal tip for those who work with tables extensively: lot, adding the table totals icon to the QAT. Also the column filter toggle shortcut is something I use frequently. It is a godsend for eliminating any filters from a table quickly from large tables.
@ExcelCampusАй бұрын
Thanks so much for sharing and for your support! I love the Jon's Excel Hacks idea!! We'll think about how we can create something around that idea in the future. For anyone wondering about the running totals in Tables, here's a link to that video. Running Totals In Excel Tables - The Efficient Way kzbin.info/www/bejne/hnjPc5moariYe6M Thanks again! 🙌
@AMDSTTАй бұрын
Thank you very much ❤
@HsiuHsienMartinАй бұрын
Great to know how to use Enter Mode and Edit Mode to update formula.
@drsteele4749Ай бұрын
Very useful! Thanks, Jon. My tip - I like to put the QAT below the ribbon: the icons are clearer and coloured down there and you can fit many more of them.
@notesfromleisa-landАй бұрын
I'm so reliant on my QAT (below the ribbon as you note which is so helpful), that when I have to help another on Excel, I find that I'm swimming through peanut butter to get to the needful things. We develop so much muscle memory in using our Excel tools.
@vinc.7765Ай бұрын
Very useful, Jon :D (davvero utile, Jon)
@salahuddin502Ай бұрын
Thank you sir, such this useful tips.
@ExcelCampusАй бұрын
Always welcome 😀
@RaviKumar-gz9my20 күн бұрын
Master: Thank you. Excellent.
@HumDingaDoozyАй бұрын
BEST excel tips everrrr 🎉. So many faves - will be adding them to my repertoire ✌🏼👏🏼 thx heaps from 🇦🇺
@Darkslide820Ай бұрын
Great video
@joshuamanampiu6489Ай бұрын
For me also the lock the drawing tool was outstanding. I discovered it also works in word! Great tip
@ExcelCampusАй бұрын
Cool! I don't think I've ever tried it in Word. Also works in PowerPoint. Thanks for sharing! 🙌
@JRT-z6rАй бұрын
Drawing tools tips
@chrisklimantiris2520Ай бұрын
Thank You Jon.!!
@tibibaraАй бұрын
Lock Drawing Mode -> woww, thanks Jon! ;-)
@ExcelCampusАй бұрын
You're welcome! 😀
@josh_excelАй бұрын
Good tips (new features?) I didn't know about.
@anindyamukherjee7690Ай бұрын
My favorite _ format painter locking, toggle between edit mode and enter mode by pressing f2
@learningwithmalihaАй бұрын
Nice tips, I like the lock drawing mode tip!
@neronjp9909Ай бұрын
thx so much, so helpful !
@ExcelCampusАй бұрын
Glad it helped! 😀
@matiasbunsterraby2176Ай бұрын
Thank you Jon. I lked the zooming into a certain range.
@nadermounir8228Ай бұрын
So many nice tips hard to choose which one is the most useful
@tamirbahalker16Ай бұрын
Good job with this video, really enjoyed it. The thing i loved the most was working with the grid while he is hiding
@ExcelCampusАй бұрын
Glad you enjoyed it! 😀
@EslamAbdo1919Ай бұрын
These are amazing tips. Thank you so much.
@jhonjaramillo4649Ай бұрын
For the tip at the minutes 7:24 can be done with ctrl + f1
@chuckpg31Ай бұрын
Locking format painter. Mind blown
@Kausik_UpadhayaАй бұрын
I liked the one with the status option and copy the results shown there and also locked for shapes
@jackcurl2005Ай бұрын
Really like the double-click ribbon tabs to collapse and expand the ribbon.
@andyrobertson4096Ай бұрын
Top tip... Don't have too many sheets per workbook!
@rajeevgosavi4514Ай бұрын
Great video. Really useful tips in day to day working. Thanks John.
@ExcelCampusАй бұрын
Thanks, Rajeev! 😀
@Sandh76532Ай бұрын
Excellent trick, thanks Jon
@mickeytee6533Ай бұрын
double click the format tool... great!!! very useful.
@nanasusieАй бұрын
So many new tips. I like the right-click on sheet arrows to get the sheet list. I use an add-in to create an index page and usually use that, but this is quick. As always, great job!
@ExcelCampusАй бұрын
Thanks for your feedback! 😀
@patrickschardt7724Ай бұрын
The copy sheet shortcut is amazing
@ashokp4536Ай бұрын
Thank you Jon for useful tips.
@harshanaweragama270Ай бұрын
Thank you.. You are one channel that I follow, and have helped me when I really did need some tips.. I rely not only on the KZbin channel, but also a fan of your bog post
@ExcelCampusАй бұрын
Wow! Appreciate that 😀
@sigmaschoolmodasaАй бұрын
Cool and useful
@Lightningstrikes88421 күн бұрын
Awesome!
@chrism9037Ай бұрын
Excellent video thanks Jon!
@OlawaleMichael-qm4kfАй бұрын
Great teacher. Thank you!
@BouncewithLife_1Ай бұрын
Thanks a lot Jon for such videos.
@ConstanceHanscombАй бұрын
Great tips! I will be saving this video for future reference. Thanks!
@ExcelCampusАй бұрын
Thanks Constance! 🙂
@samiabdullah5437Ай бұрын
I really enjoyed it. Please do something on linking cells and sheets like if I have a list of names, when ever I click on a name it takes me to his page or file.
@ExcelCampusАй бұрын
Thanks! One way to achieve that is with a table of contents sheet. This is just a sheet with a list of sheet names and links to each sheet. We can use a macro to create the sheet. Here are a few videos that explain the setup. kzbin.info/www/bejne/pn23oZtpZtyskLssi=K1Mf5-TSLveAEPbJ kzbin.infoD4eZZr9RqCg?si=VAr_TC6Eu_d4kGad There are other ways to do this, including linking to files instead of sheets. I'll add that to our list for future videos. Thanks!
@sallyho146Ай бұрын
Can you make a video on a faster way to compare the 1st data set to 2nd data set and extract the difference added after the 1st data was pulled.
@tarikajain3386Ай бұрын
Double click Format painter, selecting cells by typing cell number. Zoom to fit selection.
@peterjones7673Ай бұрын
Fantastic tips Jon, I love tip one as I have several sheets with multiple workbooks and the quick look up will save me scrolling back and forth, thank you so much as all of these great tips will be so useful.
@ExcelCampusАй бұрын
Happy to hear this. Thanks Peter! 🙌
@joukenienhuis688821 күн бұрын
Reminded me of a tip of automatically creating a menu
@sledgehammer-productionsАй бұрын
Although I still don't like to use the mouse too much, a lot of the double click tips are worth incorporating. On a side note: I'm mousing left, so I'm used to translating 'right click' to 'left click' and vice versa. But better words would be "selection button" (my right) and "context button" (my left).
@bbotzongАй бұрын
Great tips!!! Thanks.
@junogunbiyi7750Ай бұрын
Thank you so much!
@VedantKhare-wi7gcАй бұрын
Really helpful tricks
@lpanadesАй бұрын
Loved all.
@mmaimmortalsАй бұрын
CNTRL D to content above, including formats and formulas. ALT A T to apply filter. AlT W F F to apply freeze pane. CNTRL C to copy, then Right Click V yo paste value only. Very fast.
@ahmedeid-bz8gdАй бұрын
Amazing
@user-vb1rn6ox8nАй бұрын
Select Objects! Lock drawing mode!
@agraharafamily5634Ай бұрын
Most of the features are known. However learn special feature with format paint double click. Thanks
@bretthyder5602Ай бұрын
Great tips!
@404ErrorPageАй бұрын
The Format Painter was a surprise. Previously I was using conditional formatting with formula =MOD(ROW(),2)=0 to make alternate colored rows