Make Excel Row Visible Even When You Scroll Up and Down

September 7th, 2017   Tech Editorials 

Say you have a tall Excel sheet whose number of rows exceed the amount your screen can show at once. It’s a scrollable sheet you have, and the kind of sheet where the first row is a header: So far so good, but when you scroll down, the header row disappears: So, how to make…  

Remove Last Name on Facebook

September 5th, 2017   Tech Editorials 

Here’s a cool trick: You can remove your last name from Facebook. Like, completely. This is an important step if you want to become anonymous but still use the social medium. You see, Facebook allows people from Indonesia to remove their surname. I’ve heard this is because Indonesians generally have only one name, at least…  

Add Single Quotes Around String in Excel Cell

August 31st, 2017   Tech Editorials 

Adding single quotes ‘like this’ around a string in Excel cells sounds like an easy thing to do, but in reality, it takes a little more than just typing in the quotes from your keyboard. Excel is a powerful tool with myriads of features while there are only so many keys available; hence Microsoft have…  

Install WordPress in 5 Minutes – Using the Command Line

August 29th, 2017   Tech Editorials 

So you want to Install WordPress quickly? There are already official guides how to achieve this – but let me refine this a bit and present you my guide, using command line to install WordPress in five minutes! Requirements: SSH-enabled hosting. We’ll install WordPress with the command line, so having SSH access to your web…  

Important Features For A Photographer’s Laptop

August 25th, 2017   Tech Editorials 

Important Features For A Photographer's Laptop

I like to take photos now and then. Camera is essential, but so is a laptop – without the computer,  photos wouldn’t get the final touch and might look worse (however, there’s also a school of thought that prefers straight out of camera shots, called SOOC). Anyway, having recently revived my photography blog, it got…  

How To Manually Back Up WordPress

August 4th, 2017   Tech Editorials 

Backing up your website is crucial. If something bad happens to your website or its files while you are without a backup, how will you restore all the data you used to have? This is even more important with blogs that are updated often – if you write every day to your WordPress blog, you…  

The Logic Behind Link Shortener

August 1st, 2017   Tech Editorials 

Link shortening is a method of transforming a longer link to a shorter one. Let’s say you are linking to an article at http://www.somedomain.com/content/articles/index.php?article_id=567 on your blog post, but would like the link to appear shorter. There are several different approaches for this – one can, for example, use Bitly, probably the world’s most popular…  

Social Media and Pillars of Addiction

July 27th, 2017   Tech Editorials 

In the past ten years, social media has become a big part of everyday life. Since the inception of Facebook, people have flocked to social media to share, connect and learn. Social networking has also changed our lives; people spend more time online today than they did before. Sometimes, the better part of the day…  

Is Life Without Smartphone Possible?

July 25th, 2017   Tech Editorials 

In 2017, smart phones are an essential part of people’s lives. For many, it can feel these phones have existed forever, however only in 2010s their popularity exploded, peaking at turn of the year 2012-2013. Indeed, about five years ago was the time when everyone was buying a smart phone; and nowadays it can be…  

Changing WordPress Username

July 22nd, 2017   Tech Editorials 

Inside the WordPress admin panel, usernames can not be changed for some reason. First name, last name, nickname and how your name will be publicly shown can be changed, but what if you want to modify the username itself? Reason for this could be that you want to login with a different name – indeed,…