This is a cool shortcut. When using macros, keep in mind the rest of tables have to be the same size and placement otherwise you'll error out and if you don't know how to edit the code then...yeah.
@hassanboussi8909
9 ай бұрын
You can use relative reference if the table didn’t start/end at the same position or had a different size
@mars2459
8 ай бұрын
that's what i was wondering. what if a new worksheet has new added rows will this still work or is there a work around
@shanidhameed
8 ай бұрын
@@hassanboussi8909how is that done..
@thorstenl.4928
7 ай бұрын
If you click into the table and then ctrl+a it will highlight the table no matter the size. Use ctrl+arrows vor navigation and ctrl+space / shift+space for highlighting whole column / row These are relative navigations and they will work also if the size differs…
@jaxnaturals
Жыл бұрын
This is literally the best shortcut I have ever crated. Took 2hrs of work down to 10 minutes. And I have to do that every 2 weeks.
@tubeo94
9 ай бұрын
I used to work in corporate, knowing how to use macro, write code in excel, building auto tool in excel will “excel” you in your job
@sayakdasgupta1788
4 ай бұрын
You can you format painter and just copy the sheet and paste it other. It will work fast for this scenario
@sabyasachibasuroy560
Жыл бұрын
Did I just see the data for THE OFFICE! Michael's gonna get mad😂😂
@valheim2
10 ай бұрын
Or you can select all sheets and this formatting once. This is a great tutorial for creating a basic macro. Thank you.
@matteosberna735
7 ай бұрын
I love to use this method as a base for my scripts
@taimoorkhan8203
Жыл бұрын
add application.ScreenUpdating = False and apply it to all sheets with additional code in VBA
@alexthomas2667
8 ай бұрын
You could also just select all sheets and make your changes. I love macros, but I think it would yield the same result without having to create a macro. Love your content. Keep it up! 😃
@hamdioumellal1709
Жыл бұрын
You're the best!!!
@niteshjaiswal2754
6 ай бұрын
Excellent
@youcifebraheem8510
6 ай бұрын
Or by grouping sheets together and format one of them then all will same. love yr contant 😍 keep going dude❤
@jaikumarjadhav6575
10 ай бұрын
Invalid for different size -> Copy & Paste as Format should work.
@akshayganesh4144
7 ай бұрын
This guy took characters from office
@meleciasingson5868
Жыл бұрын
How about selecting the sheets at once?...pressing control then select each sheet then edit one sheet automatically the rest copies the edits
@munnakarthiko1
6 ай бұрын
😮👌
@diyfusionhelp472
10 ай бұрын
Love your videos 🫡 thank you
@kinchannel3264
9 ай бұрын
You can make select and format , without macro
@brendamg7298
Жыл бұрын
Cool
@Dulitzlives
Жыл бұрын
I love this. Genius stuff. Thank u!!
@praveent7979
Жыл бұрын
@easy_sheets- If we filter in macros base file sheet & do the changes, the same will not reflect in rest of the sheets?
@tazguy371
Жыл бұрын
You’re going to have to edit the macro to accommodate changes in the table name, at the very least.
@JaredGauthier
Жыл бұрын
Recording a macro this way will result in a hard coded macro. Every he did will now repeat when he runs the macro no matter what workbook he’s in or worksheet. He didn’t change any text, only formatting. So as long as the next table he gets are all in the same cells it will work.
@jd0879
5 ай бұрын
Disagree. This works if you’re exclusively changing formatting which he is
@imransharif8387
10 ай бұрын
Will the shortcut work in the another workbook?
@LeahyPhoto
Жыл бұрын
Name it whatever you like, as long as you don’t like spaces!
@dhamodaraninbanathan3592
5 ай бұрын
If any additional information to be add in that working sheet still the Recording Macro work correctly?
@hanadiss408
9 ай бұрын
👏🏽👏🏽👏🏽👏🏽👏🏽
@sahillarya06
4 ай бұрын
How about format painter
@suneelkumar6431
8 ай бұрын
How to do it in different workbook
@serbonkers4130
Жыл бұрын
Will this work in google sheets
@simsbanshee
Жыл бұрын
How do you unlock developer mode? Or is it always there I can't remember
@michelledizon6867
10 ай бұрын
I can save it right? So it won't be lost when I restart my pc
@brimmed
Жыл бұрын
Does that work for data filtering too? For example at work we pull the work orders from a site for the whole group, then i want to filter out orders that are in "historical" state, and want to filter just my jobs. I'm assuming yes. Hopefully I remember to try it since it's a long weekend
@easy_sheets
Жыл бұрын
Yes. Works for pretty much everything. you can add columns, make calculations, format, add filters, etc.
@DaveMcGarry
10 ай бұрын
Isn't it better to do it in Power Query... Don't you have to save the file as xlsxm format? Which end up being untrusted doc...
@QwDragon
Жыл бұрын
Brush solves it in a better way.
@abdelouahedboutahir5906
8 ай бұрын
Dunder Mifflin :) :) :)
@redhotz21
Жыл бұрын
Is the macro only saved to this one file, or is it retrievable from my 365 account?
@AdySimm
Жыл бұрын
When record a macro, after you name it, choose to store macro in "my personal macros" (not "this workbook"). When you finish recording the macro, save the excel file in order to save the macro. That's it! When you open a new excel file, will find the recorded macro under the tab developer - macros.
Пікірлер: 47