Monday, July 29, 2024

My keyboard acting strange: ' apostrophe, ~ tilde character need to press keyboard two times to get it appear in Windows 11

  • Apostrophes and double quotes don't show up until I type the next letter, 
  • Windows 10 changed how quotation marks work. How do I fix this?, 
  • Why I have to press keys two times to get the ^ or ´ or ` symbol in Windows 7 and how can I fix it? [duplicate], 
  • My windows keyboard is being "clever" with the quote keys - how can I stop it?, 
  • Quotes and double quotes appear twice after keyboard press,

and many other strange twice pressing actions on keyboard. 

The solution? 

Change your 'Installed keyboards' to US QWERTY. 


Steps: 

  1. Win + X, go for Settings, (or search Settings), 
  2. Time & Language, 
  3. Language & region, 
  4. Under 'Preferred languages' is your installed language(s) appear. Click on triple dots on the right side of 'English (United Stated), 
  5. Choose another three dots 'Language options', 
  6. Scroll for Keyboards, 
  7. Here you need to add the better keyboard that didn't need to press twice: click on 'Add a keyboard', 
  8. Scroll to look for US QWERTY keyboard. Click on it to add as your keyboard.
  9. Next is to remove the twice pressing keyboard (that is United States-International QWERTY) keyboard > click on the triple dots on it's right,
  10. Remove, 
  11. Basically you're done up to this point. But for extra confirmation, please Restart your pc ASAP. To really makes it use the new keyboard settings. 
  12. Done! 

 

Tried and tested working by me! 

 

Resources that helps a gazillion! : 

 

Just in case you need a video version of the solution, here it is: 

https://www.youtube.com/watch?v=sGsXZjNF_74


That's it. Thank you and enjoy your one time keyboard press typing~~ 

;-P 

Friday, July 26, 2024

Change Facebook Business Page URL in July 2024

  1. Go to your page, 
  2. On your left, which is a 'Manage Page' menu, browse downwards and go to 'Settings', 
  3. The menu will be 'Settings & Privacy', browse downwards for 'Page setup', 
  4. The new page is titled 'Page setup' > 'Your page name', 
  5. Next to 'Name' is a 'View' button, click it, 
  6. Here you will arrive at 'General Page settings', 
  7. The menu there is 'Name' and 'Username', with 'Edit' button on the right, 
  8.  'Username' > 'Edit' > and now here is where you can change your facebook page URL/link! 
  9. Type your preferred page url, 
  10. If the status is 'Username is available', now you can 'Save changes' and start sharing that Facebook Page link~~ 

 

Remember to type manually your newly created fb page url link to double check whether it's working well or not~

 

Ciao~

 

.

Tuesday, July 9, 2024

How to really add text to multiple cells without having to re-enter anything in Google Sheets? (No formula used)

I found a Reddit page that uilize 'Find and Replace', but it does not working as intended. It adds text to the end of the cells content. So, I tried with special characters and boom! I found it!!! 

How to add text to the front of multiple cells using Find and Replace:- 

  1. Select the cells, 
  2. Edit -> Find and Replace (Ctrl+H), 
  3. type ^ in 'Find',
  4. type your text or numbers or whatever in 'Replace with', 
  5. tick the 'Search using regular expressions', 
  6. click 'Replace all', 
  7. Done! (It should says 'Replaced # instances of ^ with (your text)) 


 

How to add text to the end of multiple cells using Find and Replace:- 

  1. Select the cells, 
  2. Edit -> Find and Replace (Ctrl+H), 
  3. type $ in 'Find',
  4. type your text or numbers or whatever in 'Replace with', 
  5. tick the 'Search using regular expressions', 
  6. click 'Replace all', 
  7. Done! (It should says 'Replaced # instances of $ with (your text)) 

 


Oh. I forgot to mention: 

If you want to add space, just type into the textbox 'Replace with'. If you didn't, the text will be sooo close together.

 

Sauce: 

 

Done! Profit! Bye! 

Monday, June 3, 2024

Where to find your logged in devices in Facebook Settings?

Okay, I tried to log in into Facebook using a new device. And to my surprise, I've logged on into : 

how to find your facebook notification on another devices
Facebook tells me that I logged with my phone and with another Samsung devices??? But I did not use Samsung phones????? 


I got so afraid, afraid that my Facebook account got hacked by unknown user so I tried to search in Facebook Settings what devices connected or logged into my account. 

That settings hides somewhat deep, so I guess if anyone out there who tried to find any devices that logged into their Facebook account, they can search it too. 

This is how :- 

1. Go to your Facebook Settings, 

2. Click on Activity log, 


3. Scroll down for 'Security and Login Information', 

4. Click on Recognized devices, 


5. Click on the log, they should be option menu (I can't remember it's the three dot or ??? on the right side) > click on it > logout/disconnect from device. (I also forgot what the option is. I just remembered to screenshot where to find the devices setting....) :-( 

I hope that this will help anyone who needed this. Maybe if I encountered this again later, I will update with newer screenshot. 

Please sometimes check credentials for your socials, you might surprised who is watching you :-( 


.


Wednesday, August 9, 2023

Cannot run the macro [*]. The macro may not be available in this workbook + custom button in Excel that goes to previous sheet

"Cannot run the macro [filename.xlsm'!macroname']. The macro may not be available in this workbook or all macros may be disabled." 


How to solve this macro problem in Microsoft Excel? I created a shape so it would function as a button that goes back to the previous sheet or the next sheet. But my macro didn't run. That guy just walks off on it's own. Maybe going to the next town, getting some milk. Who knows? 

Sorry I'm so sorry. I was creating my own inventory Excel but encounter this hurdle. So here's how I solved it? 

1. Ctrl+click on that button, (so I could select that button) 

2. right click (I want to get second opinion) 

3. look for 'Assign macro...', click on it. 

4. Next, assign newly made Macro to that button. Basically I just override that error. Good bye error. See you never! 


I forgot step 0. 

0. Record a brand new Macros from View > Macros > Record Macro... 

0a. Give your 'Macro name:', but without spaces. Maybe use underscore if you need to. Give description like 'This macro goes hard'. No no no. Write the description as 'This macro go to previous sheet using Ctrl + Page Up' or something like that. 

0b. Click 'OK', 

0c. If it says 'Macro with name 'blablablah' already exists. Replace existing macro? > YES please! 

0d. Actually when you start pressing that OK, it will start to record. So, after that OK, just go on press Ctrl + Page Up together. 

0e. Click 'Macros' > Stop Recording. That should be it. 

0f. Go back to your button just now, click on it. It should bring you back to previous sheet. That error 'Cannot run the macro...' should be gone by now. 


The last step is to save it into your computer. Save it as a file with extension of .xlsm. 

File > Save As > This PC > Desktop > go to the Save as type > choose Excel Macro-Enabled Workbook (*/xlsm) > click Save. And you're done. 

Close all your Excels and everything. Try open that Excel with macro and try clicking on your button again. It should work. If it didn't, Sorry, I don't know how to solve that. Magically it works when I'm doing it here. 


Tips: 

: For button going to next sheet, record it: Ctrl + Page Down. Yeah, that Ctrl key in your keyboard. Press it together with Page Down keyboard. 

: Let's say you want to remove all macros... Oh no, I actually save a back up before saving it as xlsm file. In case I want a macro free Excel. 

Another option is delete that macro-ed button and create a new one. View your macros and delete all unused macros. 

: In order for macro to work, when opening that xlsm Excel, you need to 'Enable content'. It appears below the ribbon. If you didn't enable it, that Excel becomes read only file. Hahahaha. 


I guess that's it? This method worked with Microsoft Office LTSC Professional Plus 2021. Eh, I thought it was Microsoft 365? I download Excel app from Explore all your Apps in Microsoft 365... 

Last but not least, 

I've uploaded that xlsm file in OneDrive, and try clicking on my macro-ed button, but it didn't work. Button with hyperlink to Index sheet is working. But macro-ed button do nothing... 

Thank you to Youtube: Two Quick Shortcuts to Switch Sheets in Excel #Shorts for the Excel sheet keyboard shortcut. 



Bye.

Thursday, December 6, 2018

How to Delete Images & Photos from Blogger

.: Have you uploaded images or photos into Blogger and...
  • you think the picture is low in quality and you want to delete it? 
  • that picture is not for the internet to consume? 
  • I immediately regret my wrong clicking? 

Cry no more!

Go to [ https://get.google.com/albumarchive/ ], there may be multiple items there > look for 'Photos from Blogger' > Pick the blog you're working on > Don't worry it is never sorted alphabetically > search for that unwanted picture > delete it and boom!

That's it. Bookmark the link =
https://get.google.com/albumarchive/

 It will save your long day. Keep Calm and be Happy~

Yep, it is dark in here. [Google AlbumArchive]

Ooigi.blog: "Thank you very very much TechJourney!"

:.

Wednesday, October 31, 2018

OnePlus 6T : Cute Lovable Traitor Smartphone

.: I took my time watching some videos. I rate the newest model is medium best because I love the led thingy and the godfather Headphone Jack.

Of course I don't have the actual phone yet. But watching these videos, I assure you I won't trade my Samsung A6+ yet. It's better to wait for OnePlus to merge both OnePlus 6 and OnePlus 6T together in one model.

OnePlus X6T??? (you traitor!)

Wait, I don't randomly say OnePlus is our Android traitor, but I heard it from Angie Zampona say it.

I already have arrange some review videos and let's start with something soft and later we go to the killer review zone. You'll get what I meant later.

OnePlus 6T from Youtube.


First video: OnePlus 6T promo video~


The coveted proper fingerprint hint~ Yesssss!!
That is Sic.

The second video : Review by Dave Lee - the heat sensor guy!


I prefer him to scan the heat emitted by this phone just like he scan the notorious overheating Macbook. But, oh well. Points taken from this video :
  • Teardrop shape notch is the ooooooooomphh bon appetite~ 
  • Fingerprint sensor under the screen is cool, but slower than the usual fingerprint sensor found at the back of OnePlus 6.
  • if your finger is wet, say goodbye to that sensor. Use your face unlock instead. 
  • This badboy traitor is thicc. 
  • Sadly, NO headphone jack. What. The. Jack??! 
  • Warning, eight legged sighted. 

My third video : Ma man MKBHD review.


My second favorite daily driver guy after Lewis Hilsenteger. He gives out good points too, which is
  • Yep. Teardrop notch is the new black. A curvy one *wink*
  • fingerprint sensor Vivo < OnePlus 6T fingerprint sensor < TouchId or physical fingerprint sensor, the official meme review rating.
  • The cons of this under the screen fingerprint sensor is how they execute it. OnePlus 6T will turn their screen brightness to the fullest in order to scan your fingerprint. During the day it didn't get noticed much, but during the night it certainly gives you some discomfort. 
  • Battery champion. 
  • "No headphone jack because of the larger battery and the fingerprint reader under the screen eats up so much space." - OnePlus 6T 2018. 
  • Hi there. It's General DBrand! 
  • Verizon and T-mobile friendly (soon). 
  • Peace! 

Say Hi to the fourth video : Canadian LinusHomeTips in house coat.


Gotta say his marble table is delicious~
  • Little animation = futuristic. Cool. I approve.
  • The reason why under the screen fingerprint sensor is the best move compared to traditional-hiding-at-the-back-sensor is: there is no need to waste your energy lifting your smartphone that resting on the table to scan your finger, because you can just tap on it directly. Easy tap easy life, right? (compares with Apple phone). I approve. 
  • The least obtrusive notch design award : because it contains all-in-one package, namely the front camera, light+color temperature+distance sensor in one cute place. (compares mechanical camera next). :-P 
  • Drop test coming, like a boss. (Yeah old meme). 
  • Condom type case. Yes Canadian Linus can say that. I approve again. 
  • USB-C to 3.5mm audio dongle \old man appears/ 
  • 3 finger screenshot, draw O to launch camera, draw M to open Maps, etc etc. 
  • 19.5:9 aspect ratio. Whoaaaa... 

And here comes the best video (cause I visit their website to compare new phone specs to my current phone every so often) : GSMArena the sharpest eye~


I know it's boring to hear the same 6T specs again and again, but can I point out some info not found in other video review?
  • I can't stop watching the LegendLegend Hat. 
  • Oppo and Vivo are great couple. Their kid 6T is even greater.
  • This kid is not lit, because LED light is missing. *bummer* 
  • I didn't mind stiff mute button because if it too smooth it defeats the true purpose. If it slides easily silent phone will ring so sudden in my meeting and it will spook everybody. Not ideal there, not that ideal. 
  • Her finger failed the sensor. Is it wet? 
  • I heard UD fingerprint reader. UD stands for Under Display. I gsmarena-ed it for you. 
  • Super color accurate. Wow~ 
  • OnePlus is hypocrite. They mock Apple removing the headphone jack and now they joined the movement. Even after asking users what they want and still they go for jackless phone. What the jack! Traitor! 
  • Gaming mode mentioned. 
  • Here navigation option is cleverly implemented. 
  • Different battery mAh. 
  • The twin camera built is... what? Whyyyy??? 
  • I love new smartphone review that comes together with their actual camera and video review/comparison. 
  • Google Pixel 3 Helicopter pad of a notch. Savage! 

Andddddd, the very best is served last.


I would like to remind you, if you cannot stand phone abuse video, please exclude this. I just wanna share it because it completes the review very well.
  • Sarcasm is everywhere. I approve again. 
  • S reflection is a new kind of review. Different eyes sees and catches different aspect. 
  • Experiments have been done and green light is your best fingerprint friend. 
  • Define indiscernible. He's comparing how invisible the fingerprint sensor placed under this screen compared to other smartphones. How genius! 
  • Please follow his do and don'ts. I've learned the hard way mixing keys and phone screens accidentally.
  • Unboxing videos comes with this subtle satisfying plastic peel audio, but this video screams pain into your deepest soul with the scratch test. Told ya this video is abusive. It pains more when listened with our headphone....
  • Oh, I mentioned already, 6T is the new black. Hahahahaha. It comes from this video~ 
  • This phone is tough. Build 6T tough. (Ford slogan inspiration). 
  • You can flex your OnePlus 6T while flexing the phone itself. Oh no! Call the mobile police. We got an abuser here! 

If you happened to have Samsung smartphone like me but uses OnePlus wallpaper, here is the link to the wallpaper creator himself : Hampus Olsson.

And in some point while watching all these videos, I've been thinking on can I tumblr-ed or Deviantart-ed the 'Never Settle' font for other project? Well, there is no information about the font itself, but I found something kinda related, if you know what I mean... OnePlus Slate font. Please oh please read the disclaimer and understand it. Go Google Translate if you need to. I do not want to be associated with any wrongdoings.


Ooigi.blog: "USD 6++ converted to MYR is likely RM 2,400. Oh myyyyy... Good bye OnePlus 6T. I pray that you will be cheaper soon. Especially your newest model which combines 6 and 6T specs..."
:.