we wanted circumstances under which heatmap should employed
@youngp380511 күн бұрын
"Command+shift+space" bar did not work for me, but "Command+control+space" worked
@silver_was_found14 күн бұрын
Thank you so much for this. One solution I found for the "file format not matching the file extension" error is to open the document in TextEdit. I was able to copy the text and paste it into another file that way.
@GBM_19_8517 күн бұрын
This did not work changed it to white even clicked do not change setting automatically and still black
@NIZARMOUMNI20 күн бұрын
Thank you so much!!
@orlynavarro381923 күн бұрын
Thanks!
@mda500325 күн бұрын
That didn't work with my UK keyboard but it did work if I held down the 'Shift' key instead.
@SharonHughes-gl5cg25 күн бұрын
Hey how do you actually tick the box in the word version? The only option I am seeing is the options button to add a tick with a new box which seems counterintuitive, the whole point is to have a box and tick as I go? Any solutions, thanks for the up to date developer add
@allafradkin21 күн бұрын
ive had the same problem, I thought this video had the answer, but alas the Apple Microsoft checkbox is untickable
@SharonHughes-gl5cg20 күн бұрын
@@allafradkin never has a less useful function been included in a package. Sad face for us
@omarmessam26 күн бұрын
OMG, why didn't I knew this before!
@WaseemOnlines26 күн бұрын
I just found much easier way to do so: A2=A1 + TIME(0,0,0) Just replace Zeros with h,m,s
@rdoman4728 күн бұрын
Number 3
@ashleyl.8447Ай бұрын
I LOVE YOU SO MUCH YOU JUST SAVED MY LIFE FROM HAVING TO RESTART MY RESEARCH PAPER ALL OVER AGAIN OH MY GOD THANK YOU!!! BLESS YOUR LIFE AND FAMILY
@olwethumaseti8666Ай бұрын
This is the best tutorial! Thank you for sharing🙏
@DarekMartinMediavillaAyalaАй бұрын
gracias crack te me cuidas, un saludo, enderpearl, fernanfloo era mejor en su epoca que ahora como que se nos casa.Lolito o ninja, españa vs EEUU, thankiu and bai bai ibai
@cornerofficelatinasАй бұрын
Thank you! You were the only one to save me! Have a great day!
@Dibzz-p3mАй бұрын
lifesaver hoenstly, saved me so much time
@monicaarmanino7013Ай бұрын
OMG thank you!
@anamariarocha3018Ай бұрын
Sometimes is dificult to put feelings in words, this is one of those times. Thank you
@Cozy_and_QuietАй бұрын
Used this just now for a work project. Thanks for posting!
@vutuanbao1696Ай бұрын
Why does mine keep showing #VALUE! while I type the exact same formula and could not come up with the result?
@jenevieveviselli5775Ай бұрын
I don't have this file at all when I search it and idk what to do
@kellyhalverson9202Ай бұрын
Exactly what I needed!! Thanks! 😀
@Luv.liiinaaАй бұрын
If anyone’s using the 2010 version, you can click the graph, then go to format, and it’ll be under analysis
@victoriacampbell4035Ай бұрын
I am SOBBING. thank you so much. You have no idea how much you helped me. I’ve been working on this final paper for over a month and it deleted off my Mac and I was crying for over an hour. Thank you thank you thank you!!!
@sarahyu4278Ай бұрын
Thank you so much!!!! It worked - at first I couldn't open it, but then renamed to doc. as you suggested and voila. You are a true godsend. <3
@ChrisMadison-e7cАй бұрын
Appreciate it
@ganeshgani2132Ай бұрын
How to increase 5 %
@RealRaizoАй бұрын
THERE'S NO GREEN PLUS SIGN, LEE. WHERE'S THE GREEN PLUS SIGN? HOW CAN I POSSIBLY CREATE A TREND LINE WITHOUT A DAMN GREEN PLUS SIGN??? THIS VIDEO IS MORE EXPIRED THAN MY VEGETABLE OF A GREAT GREAT GRANDMOTHER
@sheetlevellerАй бұрын
First, you can try resetting the chart to its default settings by right-clicking on the chart and selecting "Reset to Match Style". You can also try clearing the cache by going to File > Options > Advanced > Display and checking the "Disable hardware graphics acceleration" option. There is a sign in the up-right corner of a chart in Excel for Windows but not Excel for Mac. The chart elements in Excel for Mac is in Chart Design tab. Hope this is of some help
@RealRaizoАй бұрын
@@sheetleveller I FIGURED IT OUT, LEE. I HAD TO RIGHT CLICK ON THE DOTS AND THERE WAS A TREND LINE OPTION RIGHT THERE. I'VE MADE A SEVERE AND CONTINUOUS LAPSE IN MY JUDGEMENT. I WAS AN OAF AND IT WAS THAT SIMPLE ALL ALONG
@muhammedqassimkhan9402Ай бұрын
Thank you very much :)
@sheetlevellerАй бұрын
You're welcome
@williambrodhag3920Ай бұрын
Thank you
@sheetlevellerАй бұрын
You're welcome
@Bino-1-r2wАй бұрын
This is what I'm looking for. Thanks😁
@sheetlevellerАй бұрын
Glad I could help
@mokshved2 ай бұрын
Thx You bro solved my issue.
@sheetlevellerАй бұрын
You're welcome
@DUBUDexter2 ай бұрын
How do you return a negative number with this formula?
@TrKaris2 ай бұрын
Works like charm! Thank you.
@sheetlevellerАй бұрын
You're welcome
@NicolaPhibbs2 ай бұрын
omg...thank you so much for making this video. Brilliant!! I just found my document that took hours to write. ty ty ty ty
@sheetlevellerАй бұрын
Glad it helped!
@olive_official1182 ай бұрын
Thank you big help
@sheetlevellerАй бұрын
Happy to help
@HHRX2 ай бұрын
i only found a document but when i clicked it says "Word cannot open the file because the file format does not match the file extension" what should i do?
@sheetlevellerАй бұрын
Couple of suggestions I found for you, Change the File Extension Manually - .docx to .doc Change the File Type to .asd Another solution that may help you get rid of the “Word cannot open the file because the file format does not match the file extension” message is to change the file type. Step 1: Open File Explorer and copy the file with the error. Step 2: Navigate to the following path: C:Users%username%AppDataLocalMicrosoftOfficeUnsavedFiles Step 3: Paste the copied file here. Then right-click the file and select Rename. Step 4: Change the file type to .asd and then click Yes. Step 5: Select Word and click Open from the left panel. Then click Recover Unsaved Documents at the bottom. Step 6: In the list, double-click the right file to open it and then save it. Once you finish the above steps, you can open the file with the correct extension.
@codingXspark2 ай бұрын
thanks
@sheetlevellerАй бұрын
You're welcome!
@calisedediva2 ай бұрын
Perfect… thank you
@sheetlevellerАй бұрын
You're welcome!
@advance43302 ай бұрын
You helped me so much. You're such a lifesaver. I hope your pillow is cold on both sides. I hope every train waits for you. I hope you get a seat on the bus every time.
@jadaderouen10592 ай бұрын
I want to thank you from the bottom of my heart for making this video. I sat in front of my computer crying and defeated because I thought I had lost my honors essay which is literally due tomorrow. Thank you for helping to save us defeated students. I wish you luck and prosperity in your life. :)
@sheetlevellerАй бұрын
You're welcome! Hope you get the results you want with the essay 🙏
@kamilc32292 ай бұрын
awesome!
@sheetlevellerАй бұрын
You're welcome!
@chaosforever2 ай бұрын
my border that appears has dashed lines not just empty? FIX: go to border settings and select view gridlines OFF
@sheetlevellerАй бұрын
Perfect, others will find this helpful
@First-Star212 ай бұрын
Very helpful!
@sheetlevellerАй бұрын
You're welcome!
@bethanybrown20222 ай бұрын
How do I recover it when it WAS saved and and I had to restart and then the document gone and it’s “auto recovered” but it deleted a bunch of my work? I went in here and the version that it auto recovered was the one that was there, not the one I’d saved before restarting.
@HHRX2 ай бұрын
thats my issue right now too and idk what to do either, if u did find out a way to solve it let me know please
@Fee-h3w22 күн бұрын
Hi I’m going through the same issue. Did you manage to recover it?
@bethanybrown202222 күн бұрын
@@Fee-h3w nope. I had to redo all the work.
@haleyvanderyt52492 ай бұрын
I could kiss you. I’ve been having a mental breakdown for about 2 hours now trying to recover this document and you have done it. I love you sheet leveller