Finally a video that doesn't make Excel more difficult than it has to be! My thesis and I are very thankful!
@CareerSolutionsforTodayКүн бұрын
So glad to hear that, thank you =)
@youngwill88202 күн бұрын
Great tip and thank you saved a lot of work
@CareerSolutionsforToday2 күн бұрын
@@youngwill8820 Thank you as well.
@TrevB_Wakefield3 күн бұрын
That is brilliant! i've been using Excel for many years, but never knew about this 😃👍
@CareerSolutionsforToday3 күн бұрын
Appreciate it!
@kellysnider51384 күн бұрын
I don't get "view code" when I right click????
@CareerSolutionsforToday4 күн бұрын
Hey there, are you using the web or application version of Excel?
@imranbinamdammoe68544 күн бұрын
Cells.WrapText=True Cell.EntireRow.Autofit
@mondysvlog3127 күн бұрын
It works however when I closed my excel program then reopen again it return to manual highlighting like you need to press F9
@CareerSolutionsforToday6 күн бұрын
Did you save it as a macro enabled workbook?
@asiasimpson708 күн бұрын
Worked, thanks!
@CareerSolutionsforToday7 күн бұрын
Thank you!
@davisarts35508 күн бұрын
Screen not clear
@CareerSolutionsforToday7 күн бұрын
Hey there, which part is not clear so I can help?
@FarahNabilah-t5k9 күн бұрын
Hey may I know, is it possible to do this if I already have other VBA code in the sheet?
@CareerSolutionsforToday9 күн бұрын
Hey there, you can sure, as long as the other VBA code doesn't conflict with this code in any way it should still work. Let me know if this helps =)
@mukundsetlur314115 күн бұрын
Good one, thank you for sharing!👌
@CareerSolutionsforToday13 күн бұрын
Thank you so much!
@harkaacharya815716 күн бұрын
Hi career solution, can you please make a video on how dropdown list will have their values automatically updated in next row? Thanks for this video.
@CareerSolutionsforToday16 күн бұрын
@@harkaacharya8157 Hey there, thank you for the comment. Help me understand fully what you are looking for. Do you mean dependent dropdowns that update based in your first selection?
@adwayduttagupta988717 күн бұрын
How about we do like this? ((90000/60000) - 1 ) * 100
@CareerSolutionsforToday16 күн бұрын
@@adwayduttagupta9887 Thank you for the comment =)
@phenomenal391318 күн бұрын
Thank you so much it is a game changer for me!
@CareerSolutionsforToday18 күн бұрын
Thank you as well =)
@deannaalleman971224 күн бұрын
When I use this it doesn't allow me to fill a cell with a color if I need to. Is there a fix?
@CareerSolutionsforToday24 күн бұрын
Hey there, do you have the fill tab in the formatting dialogue box?
@forestdamian560124 күн бұрын
Hi I see you didn't answer me anything. Do you think you can help me or not? If you don't know, it's no problem, I'll keep looking. Thank you
@CareerSolutionsforToday24 күн бұрын
Hey there, apologies for the delay. I don't yet have a way set up to share files. Sorry I cannot help more but not sure I would be able to offer a good solution without fully understanding. I am trying to remedy the data transfer issue and hope to have something set up soon. Wish you all the best.
@forestdamian560124 күн бұрын
@@CareerSolutionsforToday Ok.When I want to create a simple table. I select some cells, then Insert, then Table, and something appears below that says Create Table. And you can directly give Ok or you can select the box where it says "My table has headers". But even though I don't want to select "My table has headers" and I don't give that, I just give Ok, it appears with "My table has headers". What can I do to stop this from happening, to stop appearing with "headers"?
@CareerSolutionsforToday24 күн бұрын
@@forestdamian5601 Hello and thanks for this, I think I totally understand now. Did the option of selecting "Header Row" on the Table Design tab not help? That is how I can remove the header row if not needed. Let me know =)
@forestdamian560124 күн бұрын
@@CareerSolutionsforToday That's what I tried, it didn't work. It's probably something memorized
@CareerSolutionsforToday24 күн бұрын
@@forestdamian5601 Oh I am sorry to hear that. Not sure why it would force the headers if you deselect them. I hope you find the answer you need.
@tasmisa677825 күн бұрын
This was more than useful dude🎉hats off👌
@CareerSolutionsforToday24 күн бұрын
Thank you so much!
@forestdamian560127 күн бұрын
Howdy. I have a problem and I don't know what to do. Now tables with headers appear automatically when I click on tables and ok, although I don't want them to appear with headers. What can I do? do you think you can help me? Thank you
@CareerSolutionsforToday26 күн бұрын
Hello, I would be happy to try and help. I am not 100% sure I fully understand the question, but if you go to the Table Design tab in Excel with the table selected, and then click on the checkbox for header row, it removes the header formatting. Let me know if this helps, or if you were wondering about something else.
@forestdamian560126 күн бұрын
@@CareerSolutionsforToday I could send you some pictures so you can understand exactly what it is about. But how to send them to you? Thank you
@forestdamian560126 күн бұрын
@@CareerSolutionsforToday I made a short video of a few seconds. I can send it to you if you want. But how, where?
@rahuldass45229 күн бұрын
How would you do this on Excel in sharepoint? There isn't a "view code" option when right clicking the tab.
@CareerSolutionsforToday28 күн бұрын
Hey there and thank you for the comment. So you cannot create or edit macros in Excel online but you can create macros in the app version and then transfer them.
@saadaadispatchАй бұрын
Useful
@CareerSolutionsforToday28 күн бұрын
Thank you!
@eslamfahmy87Ай бұрын
Ok, thanks but how i leave the insider mood
@CareerSolutionsforTodayАй бұрын
Hey there, you can use the same menu you used to enter to exit the program if you'd like =)
@Ramakrishna-gl3jlАй бұрын
Good Advanced Excel Channel kzbin.info/www/bejne/r6KuYZWHj6yCg6csi=Dph6hJKOaYRCU-_k
@orumeemmans8289Ай бұрын
Thanks I understand this more better now
@CareerSolutionsforTodayАй бұрын
Thank you so much!
@briankaltreider9705Ай бұрын
It will not allow me to complete this on a shared sheet. Why?
@CareerSolutionsforTodayАй бұрын
Hey there, sorry to hear that, not sure why it wouldn't work on a shared sheet. Are you able to add a note at all?
@elina2173Ай бұрын
I'm still using 2016, the option is Get External Data>From Web, then New Web Query pops up with all kind of AVG Secure search on the top and next to URL address 'enhanced by Yahoo. Did not work.
@elina2173Ай бұрын
Holly shot, why hidden?
@CareerSolutionsforTodayАй бұрын
What do you mean by hidden?
@amandakennedy6895Ай бұрын
Please lets say i want to get the index of candy type of sour 210 how do u go about it. Thats trying to find the label area of the values. Its like the other way round this time
@CareerSolutionsforTodayАй бұрын
Hey there, so in your example based on the video are you wanting to replace the candy store dropdown with a sales figure? Apologies if I am a bit lost, trying to make sure I understand your question.
@amandakennedy6895Ай бұрын
@@CareerSolutionsforTodayokay thanks for your response. So I want a situation where if I choose taffy, with 180 I'll get the answer of candy baron. Like I want to get the value of the label area if I'm giving the type and amount or quantity.
@CareerSolutionsforToday26 күн бұрын
@@amandakennedy6895 Hey there, so to find the solution you are looking for with this same table, you would switch cell C3 to candy type "taffy" and switch cell C4 to number sold "210". Then in cell C5 you can enter the function: =INDEX(B7:D7, MATCH(C4, INDEX(B8:D11, MATCH(C3,A8:A11, 0), 0), 0)) And this will return the candy store name based on sales and candy type. Let me know if this helps.
@sunlandwaterdistrictАй бұрын
Thank you so much! As I get a little older, it's hard for me to see what row I'm in when I'm in a cell really far on the right side of the spreadsheet.
@CareerSolutionsforTodayАй бұрын
Thank you so much for the comment =)
@jasonloftis6318Ай бұрын
Thanks!
@CareerSolutionsforTodayАй бұрын
Thank you!
@Shelby.CorreiaАй бұрын
Great video, thank you!!
@CareerSolutionsforTodayАй бұрын
Thank you so much as well =)
@TimSmith-dw7usАй бұрын
Clear and concise. Thank you.
@CareerSolutionsforTodayАй бұрын
Thank you as well!
@lokuuproductions985Ай бұрын
How to change color hire area
@CareerSolutionsforTodayАй бұрын
Hey there, the background is just based on my Excel theme and that is how you can change it, by adjusting the theme. Let me know if this helps =)
@mr.x6737Ай бұрын
Is it work in any particular Excel format or any format can work..what main file & source file should be same?
@compupixАй бұрын
I wish there was a way to change the default fill method. Auto increment by one is rarely what I need.
@CareerSolutionsforTodayАй бұрын
Hey there, hold down the Ctrl key while you drag and this will stop/change the auto-increment method. Let me know if this helps.
@Falcon-ae96Ай бұрын
Hi Thanks for the amazing tutorial but is it also possible to hide the grey area or center the excel sheet?
@kevinpatel265Ай бұрын
It did not work whatsoever
@CareerSolutionsforTodayАй бұрын
Hey there, I have a video on my channel for when this doesn't work as well. Check here: kzbin.info/www/bejne/gKGwqnyQra10iZI
@rmalyami4935Ай бұрын
Is this video explained how to do it with adding code or not?
@rmalyami4935Ай бұрын
Can i do it without coding?
@jjrock9916Ай бұрын
This is lowkey gold, Thank you!
@CareerSolutionsforTodayАй бұрын
Thank you!
@pipo441Ай бұрын
The Target.Calculate is a vba code from Excel?
@CareerSolutionsforTodayАй бұрын
It is VBA code yes =) Let me know if this helps.
@Bluefox1978Ай бұрын
Thank you! You’re my memory when it comes to remembering useful stuff in Excel
@CareerSolutionsforTodayАй бұрын
Thank you so much!
@pauljohnson8921Ай бұрын
When I right clock the sheet. View code is not an option
@CareerSolutionsforTodayАй бұрын
@@pauljohnson8921 Are you using the application version of Excel or the web version?
@stephenrowland5436Ай бұрын
Thank you, these little tips are really useful. Please keep them coming.
@CareerSolutionsforTodayАй бұрын
@@stephenrowland5436 Thank you so much!
@IllayilluIllayАй бұрын
Not trying to type a formula? When the first character is an equal ("=") or minus ("-") sign, Excel thinks it's a formula: • you type: =1+1, cell shows: 2 To get around this, type an apostrophe ( ' ) first: • you type: '=1+1, cell shows: =1+1 thisis the messeg I got when I use this formula every time
@May-le6hpАй бұрын
Thank you!❤
@CareerSolutionsforTodayАй бұрын
Thank you as well =)
@May-le6hpАй бұрын
Thank you ❤
@CareerSolutionsforTodayАй бұрын
Thank you again!
@bukhariali71Ай бұрын
Holy smokes. Never knew this existed and I have been using Excel for 20 years. Awesome video. Thanks. 😊
@CareerSolutionsforTodayАй бұрын
Thanks so much!
@mishkabehardien3208Ай бұрын
Thank you! This saved me sooo much time
@CareerSolutionsforTodayАй бұрын
Thank you so much for the comment =)
@wsjeefo07Ай бұрын
I took time to read the comments and I must commend you for engaging all the comments with a response. Thank you. However I will like to reiterate "the problem with Copy paste data from one cell to another) Have you found the solution?
@CareerSolutionsforTodayАй бұрын
Hey there, sorry for my delay. Still haven't found the reason or workaround for this. I will let you know if I uncover anything. I hope you have a great weekend =)
@RH7777Ай бұрын
Sir how do we reverse it?
@CareerSolutionsforTodayАй бұрын
@@RH7777 Just remove the VBA code and conditional formatting and it will be removed.