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!
I was going to post the same thing! 30 year Excel user here and it's always pee'd me off that you had to click the Format Painter each time, or so I thought! On the one hand, I love videos like this as I learnt something new. On the other, they make me feel stupid for (A) not realising that there was a better way, and (B) not finding it out myself!
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!
I have been using Excel since the early 90s - right after Symphony and Lotus. Over the years it has been my pleasure to learn and apply most commands in my work. Today, I came across your video and realised there's a lot more I have to discover. Thank you for the tips on shortcuts when using multiple sheets.
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.
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.
I bought your Pivot Table training about 10-years ago. Since then I’ve been recommending your tip emails and your classes to anyone I encounter using Excel. I wish everyone would take a deep dive into Excel if they are going to use it in their work or life. Too many people are still using it like a notepad. Thanks for these tips. I learned a bunch of stuff. I’m retired now, but still use Excel to make order out of chaos!
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.
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.
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.
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! 😃👍
I've used Excel for many decades, have taught Excel to my colleagues. I'm a keyboard shortcut user and consider moving my hand to the mouse as hitting a speed bump. I consider Ctrl+Shift+U the geekiest keyboard shortcut I know. Thank you for sharing it with your audience. One of my favourite Excel tips is to untick Edit directly in cell.
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
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!
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 TH-cam channel, but also a fan of your bog post
'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.
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!
I've been using (and self learning) Excel since version 4.0, long time ago, making complex worksheets and workbooks, even shainrg in a central storage and linking multiple external shhets. For this video, more or less a 40% of tips were unknown for me. Thanks
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.
You don't know how much help you give with your Excel tutorial videos, they really are a great help at work, I hope you know how grateful I am to you.
I think everyone does, but recently my Excel started having problems, so I think I need to look for an Office key to see if it works properly again.
Oh well, my office key is from BNH Software and it's been a while and it still works without any problem.
Thank you for the kind message, Keith. I'm happy to hear the videos are helpful. That means a lot to me. I appreciate your support. 🙌
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!
Thanks, Tom! 😀
You can also use ctrl-y which repeats your last step. That is very handy to repeat stuff that has no shortcut.
I was going to post the same thing! 30 year Excel user here and it's always pee'd me off that you had to click the Format Painter each time, or so I thought! On the one hand, I love videos like this as I learnt something new. On the other, they make me feel stupid for (A) not realising that there was a better way, and (B) not finding it out myself!
Hands down, this is the Excel tips video with the most and greatest tips in the short period of time. Nicely done!
Thanks for the feedback, Sam! 😀
@@ExcelCampus Thanks to you for producing such informative quality.
And well, clearly explained, making sense and easy to learn!
A 25+ year Excel user learned more than 30% of those features today. 🙂 Thanks!
You're welcome! 😀
That's sad
Lock the drawing tool, and the selection : great tips!!
Agreed; that was the one that had me saying, "I wish I'd known that before!"
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.).
My favorite was double clicking to hide the ribbon. I didn’t know that one and it will help tremendously.
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!
I have been using Excel since the early 90s - right after Symphony and Lotus. Over the years it has been my pleasure to learn and apply most commands in my work. Today, I came across your video and realised there's a lot more I have to discover. Thank you for the tips on shortcuts when
using multiple sheets.
Just like a previous comment, I have used Excel for years but not seen most of these shortcuts. Thank you
You are welcome! 😀
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.
Outstanding tips. Love the right-click on sheet arrows to obtain a list of sheet names for easy navigation.
Me too!
Also Ctrl click on the arrows to scroll to the first or last sheet>
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.
The select shapes tip was excellent- also the format painter double click - I knew this before but had forgotton it
I loved the double clicking on the format painter! Thanks Jon!
I bought your Pivot Table training about 10-years ago. Since then I’ve been recommending your tip emails and your classes to anyone I encounter using Excel. I wish everyone would take a deep dive into Excel if they are going to use it in their work or life. Too many people are still using it like a notepad. Thanks for these tips. I learned a bunch of stuff. I’m retired now, but still use Excel to make order out of chaos!
For me, Locking drawing mode and selecting objects mode are new for me and are super useful to know. Thanks.
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.
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.
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.
Thank you - very valuable suggestions. I love that see named ranges zoom feature.
I am new to Excel and I love your tips and short cuts it makes it easier to learn.
Great...!!! Even I am a lover of learning and teaching shortcuts and tricks...😊
It's always great to keep the brain refreshed and constantly learning little features/shortcuts 👍, thanks for the video!
Format painter lock mode was something I did not know! That will save some time for sure👏
Thank you. I love Excel. Learn quite a few new ones today.
I also love teaching and learning excel tricks
Thank you very much! The select objects tip is my favorite- did not know that one!
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.
Glad it was helpful! 😀
Thank you, you have just made my life a lot easier.
Thanks Jon, love the Lock Drawing Mode
Did not know about the 'Lock Drawing Mode' - that will certainly help now! 🙂
I didn’t know you could lock the Format Painter. I will use that a lot. Great tips!
For me also the lock the drawing tool was outstanding. I discovered it also works in word! Great tip
Cool! I don't think I've ever tried it in Word. Also works in PowerPoint. Thanks for sharing! 🙌
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
Thank you, I found the video interesting and extremely useful. The zoom to fit selection was my favorite feature.
All tips are really helpful. Great video, thanks a lot
Been using Excel since the 90s. I knew less than half of these. Well Done! Thanks.
You're welcome! 😀
Locking the drawing tool was a new one for me and one that will come in handy
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! 😃👍
Most of these were new to me. Love the tips. Thank you
You're welcome! 😀
Superb !! Its a package of time saving hacks. Thanks Jon.
Thanks for sharing these great tips. It will take away my stress and make my work smarter
I've used Excel for many decades, have taught Excel to my colleagues. I'm a keyboard shortcut user and consider moving my hand to the mouse as hitting a speed bump. I consider Ctrl+Shift+U the geekiest keyboard shortcut I know. Thank you for sharing it with your audience. One of my favourite Excel tips is to untick Edit directly in cell.
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
Good job with this video, really enjoyed it. The thing i loved the most was working with the grid while he is hiding
Glad you enjoyed it! 😀
The zoom out for named ranges is very helpful
I never knew about Edit mode vs Enter mode in formulas, thank you!!!
I knew some of the shortcuts but not all. Thanks for sharing and informing. 😊
Wow ... I learnt so much from this one video. Look forward to watching some of your other videos
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!
Thanks for your feedback! 😀
your content is so freaking helpful
Defs "Lock drawing mode" !! Changed my life. ;-)
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 TH-cam channel, but also a fan of your bog post
Wow! Appreciate that 😀
BEST excel tips everrrr 🎉. So many faves - will be adding them to my repertoire ✌🏼👏🏼 thx heaps from 🇦🇺
The tips about the status bar are cool seem really interesting but the best tip might be clicking to collapse the ribbon! 🎉
You hv done very hard work and lot research on excel. Thanks for sharing
Great video. Really useful tips in day to day working. Thanks John.
Thanks, Rajeev! 😀
I learned a lot of great tips from this video. Thank you so much. 👍
You're welcome! 😀
I like select the object selection button and drawing lock option. Thank you sir for this knowledge sharing. 🙏
You are welcome 😀
'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.
Tips related to shapes are my favourite
I didn’t know about “Fit to selection” to automatically zoom in on the cells you have highlighted - handy!
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!
Thanks! I’m happy to hear you learned something new. 😊
Thank you Jon. I lked the zooming into a certain range.
Thank you for the handy tips
Master: Thank you. Excellent.
I've been using (and self learning) Excel since version 4.0, long time ago, making complex worksheets and workbooks, even shainrg in a central storage and linking multiple external shhets.
For this video, more or less a 40% of tips were unknown for me.
Thanks
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.
Happy to hear this. Thanks Peter! 🙌
Reminded me of a tip of automatically creating a menu
I only knew one of these. The rest are new! Thanks Jon!!!
Welcome 😀
Awesome....I love it ..thanks John...
Thanks for watching! 😀
Great post, some very interesting tips 👍🏻
So many nice tips hard to choose which one is the most useful
Thank You Jon.!!
Just learning excel. I subscribed to your channel.❤
double click the format tool... great!!! very useful.
These are amazing tips.
Thank you so much.
For the tip at the minutes 7:24 can be done with ctrl + f1
Excellent trick, thanks Jon
Use of F2 Excellent!
Amazing! Thank you so much!!
Great tips! I will be saving this video for future reference. Thanks!
Thanks Constance! 🙂
Excellent video thanks Jon!
These are great tips!!🎉
Thank you Jon for useful tips.
Nice tips, I like the lock drawing mode tip!
Great Video, Many thanks,
Great teacher. Thank you!
Likes the format locking.
Didnot know of it.
Top tip... Don't have too many sheets per workbook!
Great tips. The steps moved fast but very helpful.
Glad it was helpful! 😀
I liked the one with the status option and copy the results shown there and also locked for shapes
Thanks a lot Jon for such videos.
Very useful, Jon :D (davvero utile, Jon)
Excel is a machine all on its own and is one of the 7 technological wonders of the world
Thank you sir, such this useful tips.
Always welcome 😀
The copy sheet shortcut is amazing
Some pretty nice tips there. Thanks!
Welcome! 😀
Great video!
I do like your explanation of excel. Very clear.
How do you copy the foremating of sheet without the content of the sheet?
1. Copy the range (Ctrl+C)
and then to apply only the formatting
2. Paste Special > Formatting > OK (Alt, E, S, T, Enter)
Thanks a lot. Super trick
F2… I’ve been using it forever to edit cells, but never knew it was a toggle switch. That’s very helpful. 👍🏻
Great to hear that! 😀
Thanks for the info