But what if you have dups a few places. Can you have it search and remove dups without highlighting it.
@hellmunddegenhard3 күн бұрын
Thank you, you got a new subscriber.
@JustClickHere-ITtraining12 сағат бұрын
Brilliant! Thank you so much
@user-zb7lw5hv4g9 күн бұрын
Thank you so much
@JustClickHere-ITtraining8 күн бұрын
You are very welcome! I'm glad you found it useful 😀
@Venom.IQ211 күн бұрын
Thank you
@JustClickHere-ITtraining10 күн бұрын
You're welcome!
@garimakaurfintalksАй бұрын
Thnx❤
@JustClickHere-ITtrainingАй бұрын
Welcome!
@aadhishivam2652Ай бұрын
Thank you mam it really helped (:
@JustClickHere-ITtrainingАй бұрын
Happy to help! Thank you for taking the time to comment 😀
@aadhishivam2652Ай бұрын
@@JustClickHere-ITtraining 😁 thank you for taking the time to upload.
@faridsameh50Ай бұрын
You saved me hours of work ❤❤
@JustClickHere-ITtrainingАй бұрын
Glad I could help!
@Sidhcheudj2 ай бұрын
nice video thank you very much
@JustClickHere-ITtrainingАй бұрын
Thank you!
@AndrewFalls-f2j2 ай бұрын
Unfortunately doesn't work as of 7/24 - They've replaced "master" with a "theme builder" that works about 1000x worse
@JustClickHere-ITtraining2 ай бұрын
oh no.... Thanks for taking the time to let me know - I really appreciate it.
@hooplernono70333 ай бұрын
ok, but how is it if I do not want all slide to change, only one specific page is needed as portrait
@JustClickHere-ITtraining3 ай бұрын
Sadly Google Slides does not support mixed orientations within a single presentation. The orientation you set will apply to all slides in the presentation. If you need different orientations, you could create separate presentations, then link them. (For example, add a link from your original presentation to your portrait presentation. then you can add a back button to your portrait presentation, linking it to your original document).
@wilfrednoble36303 ай бұрын
You earned a subscriber
@JustClickHere-ITtraining3 ай бұрын
Thank you!!
@babithathiyagarajan81463 ай бұрын
I found it very useful.. very simple and short.. Thank you so much.. u got a new subscriber 😊
@JustClickHere-ITtraining3 ай бұрын
Thank you so much 🙂
@seagullspb4 ай бұрын
Спасибо !
@JustClickHere-ITtraining4 ай бұрын
You are very welcome!
@mordantseer3145 ай бұрын
Life Saver
@user-nk7hv1vh2c5 ай бұрын
Thank you so much. Really appreciate this knowledge!
@JustClickHere-ITtraining5 ай бұрын
Glad it was helpful!
@SoltGamingOfficial5 ай бұрын
Its still show in recent when i open google sheets what to do??
@JustClickHere-ITtraining5 ай бұрын
Who owns the spreadsheet? And who else can edit it? Who owns the folders it is/was in? Are they in My Drive or a shared drive? Can you open it from the Recent list? Or not? (A while ago, I had a similar problem when we were migrating across to shared drives. My personal drive folders couldn't be directly moved into the shared drives. So we moved the files into a cloned folder structure in the shared drive (and then deleted the personal folders afterwards). But… any files that I had added to someone else's folder, couldn't be moved into the shared drive as that would affect my ownership privileges. I ended up making many copies of files (so I owned them), moved the copies to the shared drive.) Hope this helps! Let me know...
@SoltGamingOfficial5 ай бұрын
@@JustClickHere-ITtraining They are not in my shared drive, my drive it open when i click i m not the owner when i remove it get removed from view but after i refresh tab it show again in earlier section again and agin i am too frustrated now!
@JustClickHere-ITtraining5 ай бұрын
Only the file owner can delete a file. Do you get an "InsufficientFilePermissions" error at all? If you have read-only permission to this file, and it cannot be removed from your Google Drive account. This happens when someone shares a file with you but gives you read-only access...
@SoltGamingOfficial5 ай бұрын
@@JustClickHere-ITtraining bruh why can't I remove it from my drive or sheets I want to there are a lot of sheets I got from web,KZbin and etc 🥹🥲
@amymayodesertpineshs31305 ай бұрын
Thank you! I wish I had known this years ago, but I know it now!
@JustClickHere-ITtraining5 ай бұрын
You're so welcome! And thanks for commenting 😀
@user-xt8tf9fx8x6 ай бұрын
Thanks. Really helpful advice
@JustClickHere-ITtraining6 ай бұрын
Glad it was helpful! And thanks for taking the time to comment
@MindMathMoney6 ай бұрын
Thank you so much :)
@JustClickHere-ITtraining6 ай бұрын
No problem 😊
@barkatthemoons6 ай бұрын
It works! Thank you.
@JustClickHere-ITtraining6 ай бұрын
Great! You are welcome 😀
@saifxalikhan60786 ай бұрын
Thank you sir.
@JustClickHere-ITtraining6 ай бұрын
You are most welcome!
@amalkardaly16526 ай бұрын
THANK YOU
@JustClickHere-ITtraining6 ай бұрын
You are welcome 😀
@orderla88776 ай бұрын
Thank you. But it changes orientation of all slides at once. I have images with different aspect ratios, so is there a way to to change one slide at a time? Thank you again, dear.
@JustClickHere-ITtraining6 ай бұрын
Sadly PowerPoint doesn't allowing for the mixing of landscape and portrait slides in the same presentation... there is a workaround here though (where essentially you create one portrait presentation, one landscape presentation, then use action buttons to link them) support.microsoft.com/en-gb/office/can-i-use-portrait-and-landscape-slide-orientation-in-the-same-presentation-d8c21781-1fb6-4406-bcd6-25cfac37b5d6#:~:text=PowerPoint%20doesn't%20allowing%20for,would%20on%20a%20portrait%20slide. Hope this helps! Let me know if it doesn't...
@phillipfry81417 ай бұрын
This doesn't fucking happen and it's driving me insane, I've been trying to just add up a column of numbers for like 20 minutes what the fuck.
@JustClickHere-ITtraining6 ай бұрын
Apologies for my late reply - school half-term. Did you get it sorted? If not, can you email me a copy & I'll have a look for you. (email address on contact page on website - thanks)
@Mishef-38323 ай бұрын
The same thing is happening on my machine. I tried to format cells as currency, as numbers, as text and got nothing but the formula.
@jhart37857 ай бұрын
I got the "The range does not contain a valid query" error, then realised the top A & B column just both had "0", so I deleted that row, tried it again and it worked on the 7056 items! Thank you @JustClickHere-ITtraining !
@MegaRavi667 ай бұрын
clear and lucid explanation. thank you.
@caslan10007 ай бұрын
A great tip! Thanks!
@JustClickHere-ITtraining7 ай бұрын
No problem!
@carolynt4028 ай бұрын
very helpful still...thank you.
@JustClickHere-ITtraining8 ай бұрын
Glad it helped! 😀
@alnoorinternational36289 ай бұрын
Jazak Allah This Video saved my Time Thankyou
@JustClickHere-ITtraining8 ай бұрын
I'm really pleased to hear that! Thank you for taking the time to comment - much appreciated :-)
@jamespaul46189 ай бұрын
Your tutorial is appreciated - thanks 123
@JustClickHere-ITtraining8 ай бұрын
Glad it was helpful! :-)
@InnerSunshine9 ай бұрын
Thanks, a lifesaver😄
@JustClickHere-ITtraining9 ай бұрын
Glad it helped! 😀
@tom-rz4to10 ай бұрын
Perfect!
@Justeen02611 ай бұрын
You have saved me so much time! thankyou!
@JustClickHere-ITtraining11 ай бұрын
You are welcome! I'm delighted to hear that 😀
@cassidybeaton5602 Жыл бұрын
Thank you very much. I really appreciate it.
@JustClickHere-ITtraining Жыл бұрын
You are very welcome 😀
@ronmanson3000 Жыл бұрын
Straight to the point, thanks
@JustClickHere-ITtraining Жыл бұрын
You are welcome! 😀 Thanks for taking the time to comment 😀
@moriomislam6693 Жыл бұрын
thanks
@JustClickHere-ITtraining Жыл бұрын
You're welcome!
@humberto8911 Жыл бұрын
Thank you! It's very well explained.
@JustClickHere-ITtraining Жыл бұрын
Glad you liked it 😊
@rohitdavid8559 Жыл бұрын
Great information
@JustClickHere-ITtraining Жыл бұрын
Glad it was helpful!
@focootto Жыл бұрын
It´s dont useful anymore, but I like so much of the explanation, thank you anyway!
@JustClickHere-ITtraining Жыл бұрын
I think you just made my day with that comment! Love a bit of positivity 😊
@josephyang8135 Жыл бұрын
This video is old. I don't see Master option under View.
@JustClickHere-ITtraining Жыл бұрын
Yes it is - I amended the description (after the update) to say "After the latest update, Slide Masters can be found under View, then Theme Builder." It changed after the update in around October 2021.
@SNBCHAN101 Жыл бұрын
Thanks for these tips!!
@JustClickHere-ITtraining Жыл бұрын
You are welcome! And thanks for commenting too 😀
@fionajones8231 Жыл бұрын
Excellent! Couldn't get default lowercase in my table. Thank you very much for your clear explanation!
@JustClickHere-ITtraining Жыл бұрын
You are very welcome! (And I really appreciate the fact you took the time to comment - thanks!)
@mot1w759 Жыл бұрын
tysm
@JustClickHere-ITtraining Жыл бұрын
You are very welcome!
@Fr4nkL33-D34DLY Жыл бұрын
Great! So, do you happen to know where the subtraction button is located? Just curious is all... :)
@JustClickHere-ITtraining Жыл бұрын
Here you go! Quick video on basic formulas, hope you enjoy! 😊 kzbin.info/www/bejne/bHjRmottgLx9mrc
@Fr4nkL33-D34DLY Жыл бұрын
@@JustClickHere-ITtraining Thanks! It sure helps... 👍
@carultch Жыл бұрын
Is there a way to password protect comments, so only you can see them?
@JustClickHere-ITtraining Жыл бұрын
I don’t think you can password protect comments… It’s not a feature I’ve come across (although I think it would be a useful function). In case it’s useful, Word does let you show/hide comments by author? (I appreciate that’s not exactly what you need.) To show only comments added by a specific author: Go to the Review tab, in the Tracking group select Show Markup, then choose Specific People: Deselect all authors, except the author(s) whose comments you want to see. If I think of a way to password protect comments, I'll let you know!
@carultch Жыл бұрын
@@JustClickHere-ITtraining Thank you for your help.
@minhnguyenbinh609 Жыл бұрын
This range does not contain a valid query
@JustClickHere-ITtraining Жыл бұрын
Sorry to hear that this didn't work for you - I have seen this error before though! 🙂 From my experience it seems to be caused by the range that is selected being different from the range displayed (in the "Read Filter Criteria From" box) in the Advanced Filter dialogue box. I hope that helps! If it doesn't help, you can get in touch with me through my website - justclickhere.co.uk (It is difficult to know exactly what the problem is without seeing your data...sorry!) Let me know!
@marfelchairstian8309 Жыл бұрын
Thanks
@JustClickHere-ITtraining Жыл бұрын
No problem!
@dogukanilbay3126 Жыл бұрын
very undrstandable gut english
@JustClickHere-ITtraining Жыл бұрын
Thank You!
@fredericgiudicelli4410 Жыл бұрын
Thanks. Love your accent.
@JustClickHere-ITtraining Жыл бұрын
Thank you! 😃
@pauls7056 Жыл бұрын
Very nicely explained. Thanks for posting. It worked for some calculations for me - not for others. I think it is a formatting problem. But, great video. I cannot understand why so many librecalc videos go through the process of highlighting all the content and writing "sum()" when this does it so easily. Thank you for posting.