Lock the drawing tool, and the selection : great tips!!
@rjbjajjjmj1
3 ай бұрын
Agreed; that was the one that had me saying, "I wish I'd known that before!"
@tomwelt1825
3 ай бұрын
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
3 ай бұрын
Thanks, Tom! 😀
@samsmythsenior811
3 ай бұрын
Hands down, this is the Excel tips video with the most and greatest tips in the short period of time. Nicely done!
@ExcelCampus
3 ай бұрын
Thanks for the feedback, Sam! 😀
@samsmythsenior811
3 ай бұрын
@@ExcelCampus Thanks to you for producing such informative quality.
@jedgeorge3485
29 күн бұрын
And well, clearly explained, making sense and easy to learn!
@todds9839
2 ай бұрын
A 25+ year Excel user learned more than 30% of those features today. 🙂 Thanks!
@ExcelCampus
2 ай бұрын
You're welcome! 😀
@JHatLpool
3 ай бұрын
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.).
@BeugsTheLegend
3 ай бұрын
My favorite was double clicking to hide the ribbon. I didn’t know that one and it will help tremendously.
@JRT-z6r
3 ай бұрын
Drawing tools tips
@marlenemccullough1567
3 ай бұрын
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.
@byteseq
3 ай бұрын
I have no comment to leave
@waynethompson5098
3 ай бұрын
Outstanding tips. Love the right-click on sheet arrows to obtain a list of sheet names for easy navigation.
@DanicaH50
10 күн бұрын
Me too!
@seandudley9279
2 ай бұрын
Just like a previous comment, I have used Excel for years but not seen most of these shortcuts. Thank you
@ExcelCampus
2 ай бұрын
You are welcome! 😀
@HandelMcHandel
3 ай бұрын
The select shapes tip was excellent- also the format painter double click - I knew this before but had forgotton it
@RobertAfrick
2 ай бұрын
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!
@randyhaimila6476
3 ай бұрын
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.
@charlesnazare7358
2 ай бұрын
I loved the double clicking on the format painter! Thanks Jon!
@mmaimmortals
3 ай бұрын
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.
@ajrawlings
3 ай бұрын
Did not know about the 'Lock Drawing Mode' - that will certainly help now! 🙂
@h.esther9400
3 ай бұрын
The tips about the status bar are cool seem really interesting but the best tip might be clicking to collapse the ribbon! 🎉
@RandalSullivan-n4b
3 күн бұрын
Thank you, I found the video interesting and extremely useful. The zoom to fit selection was my favorite feature.
@sledgehammer-productions
3 ай бұрын
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).
@fliptop157
19 күн бұрын
While I can see the name range when I scroll to less than 40% it's difficult to read at that scale. How did you make your Name Range bigger than the surrounding text?
@11prem
3 ай бұрын
I don't seem to get the "Sheet number in status bar" option when I right-click on the status bar. Even the lock drawing mode option isn't available in my version. I have excel version 2016.
@billco1947
3 ай бұрын
auto column width
@Taty14002
2 күн бұрын
Just learning excel. I subscribed to your channel.❤
@PalettesOfPihu
2 ай бұрын
Click something from status bar that will automatically copied in clipboard and then paste it to the cell....i really was thinking recently if somehow that can be done. And voila!!
@ashleymoore1845
7 күн бұрын
Defs "Lock drawing mode" !! Changed my life. ;-)
@stephenl5693
3 ай бұрын
It's always great to keep the brain refreshed and constantly learning little features/shortcuts 👍, thanks for the video!
@judywilder7883
3 ай бұрын
Format painter lock mode was something I did not know! That will save some time for sure👏
@keeney413
3 ай бұрын
your content is so freaking helpful
@agraharafamily5634
2 ай бұрын
Most of the features are known. However learn special feature with format paint double click. Thanks
@jimchidwick3602
8 күн бұрын
Wow ... I learnt so much from this one video. Look forward to watching some of your other videos
@sandrahedges8843
Ай бұрын
I do like your explanation of excel. Very clear. How do you copy the foremating of sheet without the content of the sheet?
@tarikajain3386
2 ай бұрын
Double click Format painter, selecting cells by typing cell number. Zoom to fit selection.
@Андрій-ф8в
3 ай бұрын
Select Objects! Lock drawing mode!
@rrki
3 ай бұрын
All tips are really helpful. Great video, thanks a lot
@jayeshkmodi3207
2 күн бұрын
You hv done very hard work and lot research on excel. Thanks for sharing
@anindyamukherjee7690
2 ай бұрын
My favorite _ format painter locking, toggle between edit mode and enter mode by pressing f2
@chuckpg31
3 ай бұрын
Locking format painter. Mind blown
@josh_excel
3 ай бұрын
Good tips (new features?) I didn't know about.
@flyingscot19
16 күн бұрын
I’ve been an excel user for many years. I only knew about a couple of these tips. This video has been really informative and helpful,thanks very much.
@ExcelCampus
15 күн бұрын
Glad it was helpful! 😀
@jimeads3460
2 ай бұрын
I didn’t know you could lock the Format Painter. I will use that a lot. Great tips!
@lewesmariner
3 ай бұрын
F2 Enter/Edit - explains why editing formulas sometimes goes awry!
@ExcelCampus
3 ай бұрын
Yes! I sometimes wish this feature wasn't so "hidden" because it can be very useful. I forgot to mention in the video that Enter/Edit modes also work in all popup windows where you are selecting ranges. Data validation, conditional formatting, named ranges, etc. These are often referred to as ref edit boxes.
@drsteele4749
3 ай бұрын
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
3 ай бұрын
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.
@mohemmedansari8664
Ай бұрын
Likes the format locking. Didnot know of it.
@foxinusakim991
2 ай бұрын
Hi Jon, How can I our Spanish employees’ 2 first name and two last name can adjust to last name first. Thank you for your help.
@ExcelCampus
2 ай бұрын
Hi Foxinusa! 🙂 One way is to create additional columns for the second first name and the second last name, then sort according to your desire. Another way would be to reverse the names manually and add commas. For example, the name "Apple Banana Cherry Lemon" could have "Apple Banana" in the first name column, and "Lemon, Cherry" in the last name column. Sorting on the last name in that case would sort on the letter, "L." I hope that helps! 😊
@sallyho146
2 ай бұрын
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.
@HsiuHsienMartin
2 ай бұрын
Great to know how to use Enter Mode and Edit Mode to update formula.
@nboisen
3 ай бұрын
Locking the drawing tool was a new one for me and one that will come in handy
@PradeepKumarSingh
2 ай бұрын
I like select the object selection button and drawing lock option. Thank you sir for this knowledge sharing. 🙏
@ExcelCampus
2 ай бұрын
You are welcome 😀
@ShauriePvs
25 күн бұрын
Tips related to shapes are my favourite
@bankongdan
3 ай бұрын
Can you draw out a course outline in excel for data analytics training?
@josealvesferreira1683
3 ай бұрын
You are very, very good, I think this tips are very usefull. Thanks
@ExcelCampus
3 ай бұрын
Thanks, Jose! 😀
@soniccheese01
2 ай бұрын
Thanks Jon, love the Lock Drawing Mode
@abhaykachhawa5623
Ай бұрын
Hey i am getting a dget value error pls make a video or help me explain it
@jhonjaramillo4649
2 ай бұрын
For the tip at the minutes 7:24 can be done with ctrl + f1
@2bczar4u
3 ай бұрын
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.
@williestevenson9538
3 ай бұрын
I use most of these but one I have been using lately is the status bar calculations, especially when the values I want to sum are not contiguous. Just Ctrl and select those you want evaluate, no need to write a formula to get a quick result.
@ExcelCampus
3 ай бұрын
Great tip with the Ctrl+select! Thanks Willie! 🙌
@404ErrorPage
3 ай бұрын
The Format Painter was a surprise. Previously I was using conditional formatting with formula =MOD(ROW(),2)=0 to make alternate colored rows
@HeddyB
Ай бұрын
Amazing! Thank you so much!!
@hagun6535
3 ай бұрын
The zoom out for named ranges is very helpful
@dividendtimes
Ай бұрын
'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.
@CorrineTan-rq3zw
Ай бұрын
I learned a lot of great tips from this video. Thank you so much. 👍
@ExcelCampus
Ай бұрын
You're welcome! 😀
@TrevB_Wakefield
Ай бұрын
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! 😃👍
@cruzinsweetsntreats
3 ай бұрын
Tip #1 doesn't work for Excel on mobile devices, unfortunately. 😢
@ExcelCampus
3 ай бұрын
Good point! I don’t believe there are any sheet navigation features like that on the mobile version. One workaround is to add a table of contents sheet to your workbook. You would need to create that sheet on the desktop version with either VBA or Office Scripts. I have a few videos that explain the setup in more detail. kzitem.info/news/bejne/0YKK1pxpaqmqjY4si=K1Mf5-TSLveAEPbJ kzitem.infoD4eZZr9RqCg?si=VAr_TC6Eu_d4kGad I hope that helps. 🙂
@cruzinsweetsntreats
3 ай бұрын
@@ExcelCampusI've seen your tutorial, amongst a few others at the leading edge of M$ Office; just don't really use it for my travel / business delivery needs.
@chrisklimantiris2520
3 ай бұрын
Thank You Jon.!!
@sophykeo9639
3 ай бұрын
Edit & F2
@Malconceivance
Ай бұрын
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.
@UsmanAli-cp4og
Ай бұрын
F2 button in righting formula
@HumDingaDoozy
2 ай бұрын
BEST excel tips everrrr 🎉. So many faves - will be adding them to my repertoire ✌🏼👏🏼 thx heaps from 🇦🇺
@jonbebus4092
26 күн бұрын
Been using Excel since the 90s. I knew less than half of these. Well Done! Thanks.
@ExcelCampus
25 күн бұрын
You're welcome! 😀
@tibibara
3 ай бұрын
Lock Drawing Mode -> woww, thanks Jon! ;-)
@ExcelCampus
3 ай бұрын
You're welcome! 😀
@AMDSTT
2 ай бұрын
Thank you very much ❤
@KnightsMultiMediaCapeTown
3 ай бұрын
I have used Excel from before Noah went into the ark and I am very much a keyboard jocky, mouses are for navigation, keyboards are for work. However I did learn 3 new things today. thanks
@notesfromleisa-land
3 ай бұрын
Hah...I still miss Lotus 123. I had spreadsheet PTSD when Microsoft won the software wars. (Amipro, I miss you too)
@ExcelCampus
3 ай бұрын
"Mouses are for navigation, keyboards are for work". Haha, love it! I'm sure there were mice on the ark, but never knew there were keyboards too. 😜 Happy to hear you learned some new things. Thanks!
@BigSmokey3
3 ай бұрын
Unrelated to Excel, but you seem like a nice person. That is all.
@ExcelCampus
3 ай бұрын
😊 💚
@samiabdullah5437
3 ай бұрын
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
3 ай бұрын
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. kzitem.info/news/bejne/0YKK1pxpaqmqjY4si=K1Mf5-TSLveAEPbJ kzitem.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!
@jamiereife5581
Ай бұрын
The zoom was my favorite
@joukenienhuis6888
Ай бұрын
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
@md.aktheruzzaman2475
2 ай бұрын
I want to pull down importrange data in below row in google sheet, but cell reference not change, how i can do it?
@md.aktheruzzaman2475
2 ай бұрын
No one can help me?
@Sickandtwisted1990
3 ай бұрын
F2 to switch between edit and enter mode is just what I’ve been looking for - always thought it wasn’t possible to go back to navigating by arrows after entering the initial formula 😂
@terrywilliamson2067
Ай бұрын
I didn’t know about “Fit to selection” to automatically zoom in on the cells you have highlighted - handy!
@tammymhein
2 ай бұрын
Great tips. The steps moved fast but very helpful.
@ExcelCampus
2 ай бұрын
Glad it was helpful! 😀
@MaureenPesch
3 ай бұрын
Thank you very much! The select objects tip is my favorite- did not know that one!
@vinc.7765
3 ай бұрын
Very useful, Jon :D (davvero utile, Jon)
@kapibara2440
3 ай бұрын
Good video, thank you 🎉
@mickeytee6533
3 ай бұрын
double click the format tool... great!!! very useful.
@RaviKumar-gz9my
Ай бұрын
Master: Thank you. Excellent.
@extraktAI
20 сағат бұрын
Great video!
@riteshvishwakarma9595
3 ай бұрын
❤❤
@jackcurl2005
3 ай бұрын
Really like the double-click ribbon tabs to collapse and expand the ribbon.
@birgerkagan6087
2 ай бұрын
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
@alexanderbenson1602
2 ай бұрын
My favorite was either the select range option, or the double click to keep the formatting painter on
@pionytudr
Ай бұрын
Some pretty nice tips there. Thanks!
@ExcelCampus
Ай бұрын
Welcome! 😀
@sigmaschoolmodasa
3 ай бұрын
Cool and useful
@notesfromleisa-land
3 ай бұрын
My favorite KZitem 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
3 ай бұрын
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 kzitem.info/news/bejne/sX2iqJqoboWWeHY Thanks again! 🙌
@skyabdig4893
Ай бұрын
Genius ...Thanks
@EslamAbdo1919
2 ай бұрын
These are amazing tips. Thank you so much.
@TecSparks
27 күн бұрын
Thanks a lot
@andyrobertson4096
3 ай бұрын
Top tip... Don't have too many sheets per workbook!
Пікірлер: 206