Secret #5 seems to be the most popular. Question for you... Are there any time consuming Excel tasks that you'd like to automate with a macro? Leave a comment and let us know. 👇🏼 I'm working on another video on the macro recorder and want to include examples that would be helpful for you. So, your idea or question could be featured in the video.
Make a macro about how to keep the header row fixed on a sheet even if we are scrolling down so that we don't have to go all the way up to check the headers again and again while entering data. Because if we do so there surely is a chance of making mistakes. (I'm a beginner and came across this problem while doing a simple task)
@@florenciaray5954 Hi Florence, you really don't need a macro for that. Put your data into a table (an actual Excel one) and when you scroll down the column letters will be replaced by your table headers! Magic 😁 (and you can see that at minute 9:20 of the video checking day 5 is present in the table created with Power Query)
How about a merge cell macro that mimics Word's merge cell capability, which does not discard data that is not in the upper left cell? And a counterpart macro that splits data across cells?
@@florenciaray5954 Welcome to the Excel world. The program has the built-in Freeze Panes capability that creates header rows and columns. Access Freeze Panes on the View tab.
@@florenciaray5954 Probably easier than a macro for that is to use one of Excel's "Freeze Panes" options (i.e. freeze top row OR freeze 1st column OR freeze whatever's directly above & to the left of the currently selected cell. From the ribbon, go to View tab and right click on the "Freeze Panes" option, then select the "Add to Quick Access Toolbar" option. FWIW, I like to show my Quick Access options BELOW the ribbon, that way more icons can appear without running into the file name AND they're available regardless of what ribbon tab is selected.
The power query to combine files contained in a folder ...... I found this feature on the web a couple days ago, so still new to me, your video just cleared up a sticking point and added more detail. SO simple and will save me so much time and frustration! I will be watching more of your tutorials! Thank you.
Thank you for this one. Although I know a lot of shortcuts, I always find it interesting to watch these kind of videos. For just 17 minutes, I learned one new shortcut/trick - Ctrl Shift End - in case of blanks. An amzing one. Thank you. It will save me more than 17 minutes in the future :)
Thanks so much, Jan! It will take about 40 uses of the shortcut for you to recoup your time. That's assuming you use it on an average of 10,000 rows that take 26 seconds to select. 17 / (26/60) = 39.23 Lot's of assumptions in that equation, but I love to geek out on this stuff. I'd love to know how many thousands of times I've used that shortcut alone. And I think it's awesome that you thought about the time you will save in the future. So good! 🙂
When I have a select enough rows that I can no longer see my formula, then my favorite way to keep that range selected and "scroll" back up to the formula is while that to just hit Ctrl + Backspace. It's fabulous!
if you go to File, Options, Advanced, and Untick Allow editing in Cells, then you will always edit your formulas in the formula bar at the top of the sheet.
As always Jon........AWESOME! You always speak and describe things so well and at just the right pace for me. There's never any time wasting or 'padding' with you, that's why you're always my go to for excel. Thank you so much for sharing. Regards John (Inverurie, Scotland)
Great excel tutorials. I have learnt a lot. The most important was the macro. This will save me a lot of time and make my work super easy. Thank you so much Jon.
I use a very similar header row macro for my work that includes the filename (=CELL("filename",A2) when it is printed out so that I can find the file using the printed output. It is useful to have a blank row below the header if you use arrays with CurrentRegion.
Great work as always Jon. At my company, personal macro workbooks have been banned/locked out by IT Security. So far, a workaround is to convert that same workbook to an Excel Add-in and then set it to load on start up. I've got my own personal ribbon with icons linked to the functions in that Add-In and also custom icons on the Excel shortcut dropdown list so i can get to them either way. If you put together a video on the Add-In approach for personal macros, I'm sure it would be popular.
Creating a macro to insert and identically format a top row on multiple sheets is probably not necessary for most spreadsheet users. A different approach is to group a contiguous set of sheets by holding the Shift key, selecting the first sheet's tab and the last sheet's tab. All grouped sheet tabs will indicate that they are in active use. On an active sheet, insert the new first row and apply the desired formatting to the row. Entered text, etc. will be repeated on all grouped sheets. Note that an operation on a grouped sheet might be repeated on all sheets of the group if the operation is valid for all grouped sheets.
Thanks Jon for the informative video. This is excellent. My favourites are Power query and pivot tables that are time savers. Will learn power query in depth to make my life easier. Thanks again.
Jon, a fabulously informative video with clear explanations. Many thanks. Sadly I think that I shall have to get a more up to date Office suite in order to be able to use the new functionality!
In my very first proper spreadsheet (using Lotus 1-2-3 on MS-DOS), not just trying to learn how to use them, I used lookups. It was only a modest size - but took over twenty minutes to recalculate. Needless to say, auto-recalc was impossible. Things have changed.
I appreciate you sharing your knowledge and skills. The videos were informative and simple to understand. I will use all 5 "secrets" to improve productivity. I like that you demonstrate the shortcut keys as you teach. Also, Xlookup was new to me.
Thanks for the shortcuts, Jon! They’ll be really helpful at work. I’m having trouble with Excel though-it’s asking for a product key. Does anyone have any idea where I can get one?
Thanks for the clear explanation of these often used functions! I knew them, but i think it is always good to keep reading it if you do not use Excel that much. I do have a question about PowerQuery. What if there already is file and you have to add the data of other files to it without creating a new sheet?
As always Jon appreciate your sharing your knowledge of excel your videos are always clear and easy to understand the sheet title layout was extremely helpful, I added an input box to mine so I could fill the title in as I created the sheets works perfectly thank you.
I love that idea, Tom!! 🙌 Save a step in the process. The section on macros seems to be the most popular and I'll do some follow up videos on additional ways to use the macro recorder and modify the macros, including your tip on the input box. It' the InputBox function for anyone reading that wants to learn more.
I have never created a macro in Excel, Access yes, but not Excel. Very interesting. You have expanded my knowledge on every point of your tutorial. I will use the quick keys for selecting ranges a lot. For the XLOOKUP function, is there value for naming headers and data in the formula? I know you most did absolute references. I really enjoyed this video. VERY HELPFUL!
Awesome video, thanks for sharing! Do you have any that shows how to use a vlookup formula to compare 2 different dates in 2 separate spreadsheets and then to present the difference in days between one and the other? Thank you! 👍👍
I really enjoyed the Macros but your explanation was great for all of your tips. I am a huge fan of keyboard shortcuts. Do you have a shortcut to automatically increase the column width to fit the data? I am currently using crtl+a and then alt+h+o+i, but I have to do this every time I need to review the data provided and updated from an outside source. I am currently unable to ask them to change their default column width so I am looking to possibly use VBA/macros to automate this step. I am interested to see if you've come across this challenge or if the aforementioned shortcuts are the fastest way to complete the action. Thank you again for teaching and sharing your knowledge, I really appreciate it.
Click the first cell. Scroll down and click the last cell while holding shift. Unselect individual cells you don't want while holding ctrl. Same as when you select files or photos in windows explorer.
Ty Jon! Can you run a second macro after the first? Have a situation at work, where I run a macro that creates 4 sheets, and then I create six other sheets in same workbook. Can I create/run a second macro on whole to give same formatting?
Am new subscriber this one really awesome i learned new things especially ctrl+shift+end without knowing that i waste time now u saved everything :) do more video we support u kudos!!🥳
When recording macros, Excel doesn't necessarily do things the most efficient way, primarily because it's emulating you physically manipulating what you're trying to accomplish. But VBA can do things more efficiently. Primary example is always having to do a /SELECT/ on a range before operating. In all the VBA code I've written (hundreds of thousands lines or more), I've never used SELECT to accomplish any programming task except to be in a specific spot when I finish the process, or restore a user selection because certain VBA operations will clear the selection (and clipboard-which is not maddening at all). [On the other hand, SELECT is nearly mandatory for any SQL programming. 😆]
All that to say: Recording macros provides a great start and certainly provides insight into the needed commands. But that's not necessarily the end of the task.
Great points, Jack! I completely agree. The point of this video was to provide that start and introduction to macros. We do have several other videos on VBA. Here is a link to one of our most popular ones for anyone else that wants to learn additional ways to automate tasks with macros. ruclips.net/video/9R0_h_aoSAE/видео.html
Awesome tips. Thanks heaps Jon. I’m so glad I found your channel, it was actually through Primal Video that I discovered your amazing channel and tutorials.
Oh my goodness. Power query was the best for me. Thank you so much. On another note, every August we have a huge business meeting (approximately 800 in attendance) that I have to download all the data from the online registration and create name tags (among other things). I usually download all the info into a csv, then create a 'label' in Word, add the fields, .. you get where I'm going. Is there a quicker easier way? Any help would be appreciated. Thank you.
Great question, Franco! I tend to put several macros in the same module. In my personal macro workbook, I group the macros based on their functionality (or what they do). For example, I have a module named mUnhideSheets that contains several macros for hiding and unhiding sheets. You can see an example in this video. ruclips.net/video/cckNqUEALbQ/видео.html This organization allows me to find them a bit easier than putting all macros in one module. It also allows me to move a module to a different workbook if I want to use those macros in a specific project. I think there are pros and cons no matter which way you choose to organize your macros. And it's important to find a method that works best for you. One thing to note is that you can use Ctrl+F to find macros in the current procedure, module, or project. So if you don't want to organize them, search is another way to quickly find them. I hope that helps. Thanks again and have a nice weekend! 🙂
@@ExcelCampus Thank you! I will follow your advice to better organize my macros! I didn't know about Ctrl+F. I will definitively use it in the future. Have a nice weekend too!
Thanks for being a subscriber! We appreciate your support. 🙏 For anyone else reading this, there is a link in the description to join our free weekly Excel Pro Tips Newsletter.
Hi Jon. Just found your channel today and subscribed. Great tips. May I ask - what screen recorder do you use? You appear to fly through the steps and are able to annotate very fast. I'd love to learn VBA, is there a course you would recommend? Thanks!
Great video… thanks for sharing! I was already onto most of the tips but the macro bar at the end looks helpful and I’ll check out your video on that! Cheers 🍺🍺
I created buttons on my Quick Access Toolbar and assigned them to the most common macros I use. I didn't know we could make our own ribbon item though!
Love the cntrl + shift + end reminder, but now that I'm on a Mac we don't have an end button. figured out that shift + command + down arrow works if fields are filled in, but it didn't work when there are empty cells. Would love to know if anyone found the alternative when blanks. 🦋
Surprised that I knew all of these. Doesn't mean that there isn't anything left to learn. Learning is never ending. My easiest shortcut was John's Excel hero add-in. Not sure that is sold anymore. But is pure gold.
Unfortunately, the operation of the End key is usually unusable. It must actually be the last cell of the data range. In addition, Excel clumsily remembers the cells we entered (by mistake), so it often marks an empty cell somewhere at the bottom right. This behavior is also familiar to VBA programmers who have to reset the UsedRange. I'm afraid that this will make the End key as forgotten as the extended mode (F8) or even the slightly hated ScrollLock.
Is there a way to select a group of cells in a column, then tab to the next column and have the same amount of grouped cells selected? For example selecting cells A1 thru A12 and tab over to have just B1 thru B12 selected?
Hi, I'm a student and a beginner user of excel. The only device I have at home is a MacBook. What is the difference of Excel on MacOS compared to Windows?
The macro - how to use the macro to run an automatic pick for a list of purchase orders every day, based on min and maximum inventory levels, without an inventory management ERP system?
Secret #5 seems to be the most popular. Question for you... Are there any time consuming Excel tasks that you'd like to automate with a macro?
Leave a comment and let us know. 👇🏼
I'm working on another video on the macro recorder and want to include examples that would be helpful for you. So, your idea or question could be featured in the video.
Make a macro about how to keep the header row fixed on a sheet even if we are scrolling down so that we don't have to go all the way up to check the headers again and again while entering data. Because if we do so there surely is a chance of making mistakes. (I'm a beginner and came across this problem while doing a simple task)
@@florenciaray5954 Hi Florence,
you really don't need a macro for that.
Put your data into a table (an actual Excel one) and when you scroll down the column letters will be replaced by your table headers!
Magic 😁
(and you can see that at minute 9:20 of the video checking day 5 is present in the table created with Power Query)
How about a merge cell macro that mimics Word's merge cell capability, which does not discard data that is not in the upper left cell? And a counterpart macro that splits data across cells?
@@florenciaray5954 Welcome to the Excel world. The program has the built-in Freeze Panes capability that creates header rows and columns. Access Freeze Panes on the View tab.
@@florenciaray5954 Probably easier than a macro for that is to use one of Excel's "Freeze Panes" options (i.e. freeze top row OR freeze 1st column OR freeze whatever's directly above & to the left of the currently selected cell.
From the ribbon, go to View tab and right click on the "Freeze Panes" option, then select the "Add to Quick Access Toolbar" option.
FWIW, I like to show my Quick Access options BELOW the ribbon, that way more icons can appear without running into the file name AND they're available regardless of what ribbon tab is selected.
Crtl Shift End instead of down arrow was new for me. Thanks Jon!
You're welcome. 😀
Same here. But meanwhile I like the table approach more: Ctrl+A, Ctrl+T, then shift+space for rows and Ctrl+space for table column
Same
Really, then you have learnt a new trick
The power query to combine files contained in a folder ...... I found this feature on the web a couple days ago, so still new to me, your video just cleared up a sticking point and added more detail. SO simple and will save me so much time and frustration! I will be watching more of your tutorials! Thank you.
Glad to hear that, Diane! 😀
Ctrl+Shift+End is a new thing for me. Thanks
Shift control end is new for me when there are multiple blanks in column and used to do manually. Now i am pro after watching
Thank you for this one. Although I know a lot of shortcuts, I always find it interesting to watch these kind of videos. For just 17 minutes, I learned one new shortcut/trick - Ctrl Shift End - in case of blanks. An amzing one. Thank you. It will save me more than 17 minutes in the future :)
Thanks so much, Jan! It will take about 40 uses of the shortcut for you to recoup your time. That's assuming you use it on an average of 10,000 rows that take 26 seconds to select. 17 / (26/60) = 39.23
Lot's of assumptions in that equation, but I love to geek out on this stuff. I'd love to know how many thousands of times I've used that shortcut alone.
And I think it's awesome that you thought about the time you will save in the future. So good! 🙂
When I have a select enough rows that I can no longer see my formula, then my favorite way to keep that range selected and "scroll" back up to the formula is while that to just hit Ctrl + Backspace. It's fabulous!
if you go to File, Options, Advanced, and Untick Allow editing in Cells, then you will always edit your formulas in the formula bar at the top of the sheet.
Thanks Jon! I've been scared of PowerQuery - but you made it sound super easy! I'll definitely be looking into it more.
As always Jon........AWESOME!
You always speak and describe things so well and at just the right pace for me.
There's never any time wasting or 'padding' with you, that's why you're always my go to for excel.
Thank you so much for sharing.
Regards
John
(Inverurie, Scotland)
Wow, thank you for your feedback! 😀
Great excel tutorials. I have learnt a lot. The most important was the macro. This will save me a lot of time and make my work super easy. Thank you so much Jon.
Glad it was helpful! 😀
Awesome! Double clicking on the fill handle was something I learned from your video. Super useful.
I use a very similar header row macro for my work that includes the filename (=CELL("filename",A2) when it is printed out so that I can find the file using the printed output. It is useful to have a blank row below the header if you use arrays with CurrentRegion.
for my current job, i am most interested in Combing Files. I need to watch it again. thank U
You are welcome! 😀
Great work as always Jon. At my company, personal macro workbooks have been banned/locked out by IT Security. So far, a workaround is to convert that same workbook to an Excel Add-in and then set it to load on start up. I've got my own personal ribbon with icons linked to the functions in that Add-In and also custom icons on the Excel shortcut dropdown list so i can get to them either way. If you put together a video on the Add-In approach for personal macros, I'm sure it would be popular.
I sure wish I had found you much earlier, but I'm glad to have found you now. Thanks!!😀
Creating a macro to insert and identically format a top row on multiple sheets is probably not necessary for most spreadsheet users. A different approach is to group a contiguous set of sheets by holding the Shift key, selecting the first sheet's tab and the last sheet's tab. All grouped sheet tabs will indicate that they are in active use. On an active sheet, insert the new first row and apply the desired formatting to the row. Entered text, etc. will be repeated on all grouped sheets.
Note that an operation on a grouped sheet might be repeated on all sheets of the group if the operation is valid for all grouped sheets.
Learning Analytics and these videos you post have been instrumental.
Thanks!
Really nice demonstrations and descriptions here. MS Excel is so powerful now.
Thanks! And yes! 💪
Thanks Jon for the informative video. This is excellent. My favourites are Power query and pivot tables that are time savers. Will learn power query in depth to make my life easier. Thanks again.
Awesome! I'm happy to hear you're interested in learning Power Query. It's an amazing tool for data cleanup tasks.
All of these videos were extremely helpful - Thank you
Thanks, Jon! All so helpful, but I think I'll be using the macro function most.
Jon, a fabulously informative video with clear explanations. Many thanks. Sadly I think that I shall have to get a more up to date Office suite in order to be able to use the new functionality!
In my very first proper spreadsheet (using Lotus 1-2-3 on MS-DOS), not just trying to learn how to use them, I used lookups.
It was only a modest size - but took over twenty minutes to recalculate. Needless to say, auto-recalc was impossible.
Things have changed.
Same! Lotus 1-2-3 as a summer intern in data processing. Had a fancy word processor with a "gold key" too!
It's been a minute...
Thank you!
I appreciate you sharing your knowledge and skills. The videos were informative and simple to understand. I will use all 5 "secrets" to improve productivity. I like that you demonstrate the shortcut keys as you teach. Also, Xlookup was new to me.
Thanks for the shortcuts, Jon! They’ll be really helpful at work. I’m having trouble with Excel though-it’s asking for a product key. Does anyone have any idea where I can get one?
Hey Keith! I got my Excel product key from BNH Software and was able to use it without any problems!
@@Ann_779 Hey Ann, I have a question. Does this key work for all the Office programs, or just for Excel?
@@MarkUSAfreedom Hello Mark! It's only for Excel. You can find the product keys for the other programs on the same website. Hope it helps!
Thank you, Ann!! It worked perfectly, and now I can use Excel without any problem!
@@keithM7 You're welcome! I'm happy to help
5 for the price of one - one day only! Thanks Jon!
LOL! Tell your friends! 🏃
I didn't know you could hit F4 to make references absolute. That's so handy. Thanks!
I have joined your channel today and this was the first video I watch it's amazing. If I go through all the videos I might become a pro
Awesome! Thank you for your feedback. 😀
Thanks for the clear explanation of these often used functions! I knew them, but i think it is always good to keep reading it if you do not use Excel that much. I do have a question about PowerQuery. What if there already is file and you have to add the data of other files to it without creating a new sheet?
Great stuff! A guy on Reddit was asking about combining files today, and I was able to link this video! Thanks again!
Glad it was helpful! 😀
Thank you for your efforts, explained in great detail yet easy enough for a novice excel user. Great Job.
Thank you for your feedback! 😀
As always Jon appreciate your sharing your knowledge of excel your videos are always clear and easy to understand the sheet title layout was extremely helpful, I added an input box to mine so I could fill the title in as I created the sheets works perfectly thank you.
I love that idea, Tom!! 🙌 Save a step in the process. The section on macros seems to be the most popular and I'll do some follow up videos on additional ways to use the macro recorder and modify the macros, including your tip on the input box. It' the InputBox function for anyone reading that wants to learn more.
I have never created a macro in Excel, Access yes, but not Excel. Very interesting. You have expanded my knowledge on every point of your tutorial. I will use the quick keys for selecting ranges a lot. For the XLOOKUP function, is there value for naming headers and data in the formula? I know you most did absolute references. I really enjoyed this video. VERY HELPFUL!
As usual a very well structured video. I learnt a few new ways to do thing faster, especially the Macro.
🙌 I'm happy to hear you learned some new things. Thanks for letting us know.
the recording macro might have been the most helpful for me but mainly because i already kknew the others. overall great video
Thanks for the feedback! And I'm happy to hear you enjoyed the section on macros. We'll do more videos on that topic in the future.
Awesome video, thanks for sharing! Do you have any that shows how to use a vlookup formula to compare 2 different dates in 2 separate spreadsheets and then to present the difference in days between one and the other? Thank you! 👍👍
Great video, will be sharing this at work! Someone will make use of it 😊
I'm so happy to hear that and thanks so much for sharing! 🙏
Thank you. Which video that shows how to add my micro tab?
Very helpful! Compliments on how you present. So easy to follow. Appreciate the effort you put in
Thanks Lindie! I’m happy to hear it helped and appreciate the nice feedback. 🙂
I love your efficient videos! Helpful
I really enjoyed the Macros but your explanation was great for all of your tips. I am a huge fan of keyboard shortcuts. Do you have a shortcut to automatically increase the column width to fit the data? I am currently using crtl+a and then alt+h+o+i, but I have to do this every time I need to review the data provided and updated from an outside source. I am currently unable to ask them to change their default column width so I am looking to possibly use VBA/macros to automate this step. I am interested to see if you've come across this challenge or if the aforementioned shortcuts are the fastest way to complete the action. Thank you again for teaching and sharing your knowledge, I really appreciate it.
I am so glad I found your channel Jon. This is great and useful information!
I'm glad that you find it helpful. 😀
Thank you.... These shortcuts are going to be really helpful in future
Glad to hear that! 😀
I am going to benefit the most from Secret #5! Thank you!
That's good to know. 😀
Click the first cell. Scroll down and click the last cell while holding shift. Unselect individual cells you don't want while holding ctrl. Same as when you select files or photos in windows explorer.
excellent video, very useful tips ( esp power query and macros) and very well explained.
Many thanks for your feedback! 😀
Thanks about your knowledge
and special thanks for sample file
I can follow video step by step
thanks very much
Mr.Jon continue your great work to the community.Nice video to save the time.
Thank you, will do! 😀
Ty Jon! Can you run a second macro after the first? Have a situation at work, where I run a macro that creates 4 sheets, and then I create six other sheets in same workbook. Can I create/run a second macro on whole to give same formatting?
Am new subscriber this one really awesome i learned new things especially ctrl+shift+end without knowing that i waste time now u saved everything :) do more video we support u kudos!!🥳
Thank you for your feedback! 😀
Could you create a style for the SheetTitle macro? I never use the preset styles as they were never quite what I wanted.
When recording macros, Excel doesn't necessarily do things the most efficient way, primarily because it's emulating you physically manipulating what you're trying to accomplish.
But VBA can do things more efficiently. Primary example is always having to do a /SELECT/ on a range before operating. In all the VBA code I've written (hundreds of thousands lines or more), I've never used SELECT to accomplish any programming task except to be in a specific spot when I finish the process, or restore a user selection because certain VBA operations will clear the selection (and clipboard-which is not maddening at all). [On the other hand, SELECT is nearly mandatory for any SQL programming. 😆]
All that to say: Recording macros provides a great start and certainly provides insight into the needed commands. But that's not necessarily the end of the task.
Great points, Jack! I completely agree. The point of this video was to provide that start and introduction to macros. We do have several other videos on VBA. Here is a link to one of our most popular ones for anyone else that wants to learn additional ways to automate tasks with macros. ruclips.net/video/9R0_h_aoSAE/видео.html
Thank you for the video. Always enjoy your videos, you have a great teaching manner.
I appreciate your feedback. 😀
Yeah, excellent tips to increase productivity. Thank you Jon!!!
Thanks so much Ivan! 🙌
Excellent tips and tools. Straight forward explanation.
Thanks, Simon! 😀
Awesome tips. Thanks heaps Jon. I’m so glad I found your channel, it was actually through Primal Video that I discovered your amazing channel and tutorials.
Awesome! Thank you for your feedback! 😀
Oh my goodness. Power query was the best for me. Thank you so much.
On another note, every August we have a huge business meeting (approximately 800 in attendance) that I have to download all the data from the online registration and create name tags (among other things). I usually download all the info into a csv, then create a 'label' in Word, add the fields, .. you get where I'm going. Is there a quicker easier way? Any help would be appreciated. Thank you.
Thanks my friend.
Thanks for these techniques
You are so welcome! 😀
I want to understand more on the xlookup formula and the thought process to how the formula works. Example why =xlookup(C6?
Thank you for the great video and hints. Do you save several macros in the same Module or each macro in a separate Module?
Great question, Franco! I tend to put several macros in the same module. In my personal macro workbook, I group the macros based on their functionality (or what they do). For example, I have a module named mUnhideSheets that contains several macros for hiding and unhiding sheets. You can see an example in this video. ruclips.net/video/cckNqUEALbQ/видео.html
This organization allows me to find them a bit easier than putting all macros in one module. It also allows me to move a module to a different workbook if I want to use those macros in a specific project.
I think there are pros and cons no matter which way you choose to organize your macros. And it's important to find a method that works best for you.
One thing to note is that you can use Ctrl+F to find macros in the current procedure, module, or project. So if you don't want to organize them, search is another way to quickly find them.
I hope that helps. Thanks again and have a nice weekend! 🙂
@@ExcelCampus Thank you! I will follow your advice to better organize my macros! I didn't know about Ctrl+F. I will definitively use it in the future. Have a nice weekend too!
Rial life practical job is it. Thanks for sharing
Welcome 😀
Ive watched a few of these videos and they are really helpful. I really appreciate the info you present!
Thanks for your support. We really appreciate it. 🙏
Woa so macros.... I want to make custom macros for.my business for our internal forms and sheets. I need to figure that out!!!
Thank you
Thanks for your newsletter bringing me here 😅
Thanks for being a subscriber! We appreciate your support. 🙏
For anyone else reading this, there is a link in the description to join our free weekly Excel Pro Tips Newsletter.
Love this.
Marvelous, very value added info
Thanks so much! I'm happy to hear it. 😀
macros is a great tool to now use thanks
You're welcome! 😀
need a bit more about power query- how do i get more videos on this topic- btw my favorite
very easy and clear
Hi Jon. Just found your channel today and subscribed. Great tips. May I ask - what screen recorder do you use? You appear to fly through the steps and are able to annotate very fast. I'd love to learn VBA, is there a course you would recommend? Thanks!
#6: Scroll Lock changes the behavior of the arrow keys :)
Great video… thanks for sharing!
I was already onto most of the tips but the macro bar at the end looks helpful and I’ll check out your video on that!
Cheers 🍺🍺
Thanks for the nice feedback John! I'm happy to hear you'll be learning more about macros. One of my favorite Excel topics. 🙂
I created buttons on my Quick Access Toolbar and assigned them to the most common macros I use. I didn't know we could make our own ribbon item though!
oh my , i was searching for a day and this is the best video
Glad I could help. 😀
Love the cntrl + shift + end reminder, but now that I'm on a Mac we don't have an end button. figured out that shift + command + down arrow works if fields are filled in, but it didn't work when there are empty cells. Would love to know if anyone found the alternative when blanks. 🦋
Surprised that I knew all of these. Doesn't mean that there isn't anything left to learn. Learning is never ending. My easiest shortcut was John's Excel hero add-in. Not sure that is sold anymore. But is pure gold.
very helpful!
Jon do you have a keyboard shortcut sheet for Mac
Very good, congratulations!
Thank you! Cheers! 😀
Very good. Nice job!
Unfortunately, the operation of the End key is usually unusable. It must actually be the last cell of the data range. In addition, Excel clumsily remembers the cells we entered (by mistake), so it often marks an empty cell somewhere at the bottom right. This behavior is also familiar to VBA programmers who have to reset the UsedRange. I'm afraid that this will make the End key as forgotten as the extended mode (F8) or even the slightly hated ScrollLock.
Great video. Thanks a lots
thanks for informative tricks
Thank you so much, excellent and helpful.
Glad to hear it was helpful! 😊
Really helpful!
Thanks Jon You're Amazing 👍
Thanks Jon, these tips are really good, especially about recording macros. Paul
Thanks Paul! I appreciate it and I'm happy to hear the feedback on macros too.
Wow Jon... what a good short leaning video... I am ur new subscriber right away.
Thank you! 😀
Is there a way to select a group of cells in a column, then tab to the next column and have the same amount of grouped cells selected? For example selecting cells A1 thru A12 and tab over to have just B1 thru B12 selected?
Hi, I'm a student and a beginner user of excel. The only device I have at home is a MacBook. What is the difference of Excel on MacOS compared to Windows?
Great excell tips, very helpful! Thank you, Jon! =)
Glad it was helpful! 😀
Excellent tips, thanks Jon!
Thanks Chris! I appreciate it! 🙌
I need help on how to creates the formula for begin the start and end date then it gives prompt for PayPeriod and Fiscal year in Excel
Great work sir🎉
So nice of you 😀
Some really helpful tips 👍
Thank you.
The macro - how to use the macro to run an automatic pick for a list of purchase orders every day, based on min and maximum inventory levels, without an inventory management ERP system?
Did you get an answer
@@toniantrowers5922 Not yet.
Crtl Shift End only works if your data is not in table form.