I won’t deny. I hate Windows 10 and I hate Microsoft for making Windows 10 the way they made it. And… I hate my company’s IT support for forcing me into using it. But since I was forced to and there was no way avoiding this madness, I made my personal list of things you have to disable, uninstall, tweak up or change in order to make this stupid operating system a little less stupid.
Whether it is Office 2010 or 2013 (haven’t tried newer and already forgot about earlier) and whether it is on Windows 7, 8.1 or 10, the set of my preferred configuration options and elements is usually the same. So I decided to write it down here to keep track of it whenever I have to fresh-install Microsoft Office anywhere.
This article covers only configuration of each Office component that I use. For other things that I usually do or change during fresh-install of Office, please, refer to this article.
Notice that Office 2013 under Windows 10 is not the same as Office 2013 under Windows 7. It ships with a completely different configuration and thus many options listed in this article you will have to change only under Windows 10, because under Windows 7 they can be already in designated values.
Even after years since initial publication, being mature and stable operating system right now, Windows 10 comes to your computer literally bloated with unnecessary stuff. And you need to clean it up by yourself.
Certain things can be uninstalled “the normal way” (i.e. as easy as going to Add/Remove programs section of Settings and clicking Uninstall next to each of unwanted items). Some other requires more sophisticated moves as some jerks at Microsoft decided that making uninstallation of these as complex and problematic as possible is funny.
By an accident I have discovered a handy feature (bug?) in new Google Calendar’s interface:
- Point your mouse pointer to desired date and time.
- Press left mouse button and then quickly right mouse button.
This will add a new event to your calendar and redirect you directly into editing that new event’s details (without need of moving your mouse toward “More options” button and clicking it).
So far, to quickly open a new copy of already running program or task I was doing this:
Right-click on program’s item in Windows taskbar + select name of that program from the context menu. Turns out there’s an even faster way of doing so: Click on program’s item while holding Shift button pressed.
Works in Windows 7. May work in other versions (though not tested). You may safely ignore this post, if this is absolutely obvious for you (wasn’t that obvious for me).
For some of my JIRA filters (and for JIRA lists on some of my Confluence pages) I need to display all closed JIRA tickets as last and all in progress in the beginning of list. Using
ORDER BY status failed because
Closed isn’t neither first nor last status name when ordering status names alphabetically.
Searching Internet also didn’t help, but I managed to find a cool workaround:
ORDER BY resolution DESC
It assumes that any JIRA ticket in progress has resolution set to Unresolved which in JIRA means “empty value” and causes all tickets with such resolution to be displayed first and all tickets with
Resolution != Unresolved to be displayed as last.
One of blogs in my WordPress network is using some old, free theme that was using
mb_strimwidth() function. This function is part of
php-mbstring package which turned out to be disabled by default in my hosting configuration for PHP 7.2 (it is enabled by default for PHP 5.6).
After enabling PHP 7.2 in my hosting configuration it turned out one of my blogs stopped showing content (showing those damn two small smilies instead). After enabling wp_debug mode it turned out that theme was using
mb_strimwidth() that was part of disabled
mb_strlen is not part of that package, seems to be part of core PHP and can be used as a workaround.
Meet Tasker, a state-of-art automation tool for Android that can:
- turn on GPS when Google Maps starts; turn it off when Google Maps closes,
- show a list of your music apps when you plug in headphones,
- turn off pattern lock while on home WiFi,
- read incoming text messages aloud,
- even more,
- a lot of more,
- even a lot of more.
It isn’t free (of course!). I costs… 5 bucks. But it is worth every damn cent spent on it!
And, if above is still not enough for you…
If you wish to forward any Outlook message as a file you can use copy/paste features:
- Find and select (on message list) message that you want to forward as a file.
- Press Ctrl+C to copy selected message to clipboard.
- Hit Ctrl+N to start a new message (or Ctrl+R to respond to some other message).
- Click anywhere within main text window (or press Tab three times to get there).
- Press Ctrl+V to attach copied message as a file (paste it from Clipboard).
That’s all, folks! :>
Sometimes, I need to forward message no x in my message list as a file attached in response to message no x-1 (the next coming in, since I have message list ordered by date). For this reason I use an ultra fast combination of: Ctrl+C | ↑ | Ctrl+R | Tab+Tab+Tab | Ctrl+V | Ctrl+Enter.
This is just a memo for myself to remember all regular expression that I often use:
- Remove sh*t from movie’s subtitles (there’s a longer article on this topic here):
\(([^)]+)\)— match everything between parentheses, including them,
[A-Z ]+:— match all uppercase letters followed by colon and a space.
^(.+?),— match everything from the beginning of the string until the first comma.
Probably no use for anyone else except me, sorry! :>
For regular Linux users this is so obvious that it can’t be more obvious. For me and some others this is something that I keep forgetting and need this short memo to remember about this.
So, here it is. An easier Linux commands invocation or running Linux commands from every folder.
Notepad++ prints texts with spelling errors underlined. Quite very weird, but true.
Fortunately, you can workaround this problem by using quick serie of keyboard shortcuts.
In many situations or scenarios Microsoft Outlook, instead of regular (consumable by other mail clients) meeting invitations can start sending “windmail.dat” instead. This is a proprietary format that other mail clients (like Thunderbird, Mac mail clients, web clients) ignore as not readable.
List of situations and configuration switches that may cause Outlook to behave like this is long. And so is the solution list. In my case only the most aggressive solution worked.
If you’re using any kind of software or browser’s plugin for capturing entire website, viewport areas longer than current screen or just a small pieces of website then with new Google Chrome DevTools 62 you can say bye, bye to all of them!
You can now capture screenshot of selected node (which includes capturing entire page, as I’ll show you) directly in DevTools in Google Chrome 62.
It is said that you can also capture a screenshot of selected part of viewport, but I managed to get this working only two times per ten on less than 10% of websites. Thus, I decided to not write about it.
…are not correctly detected by it’s internal Lister viewer.
They’re detected as binary files in this case and if they contain any character from outside Latin range, Lister will most likely display such characters incorrectly (Total Commander does not do automatic UTF-8 detection in binary mode). According to TC’s author this is a correct and expected behavior.
Lister needs at list one line brake to correctly detect text file as UTF-8 encoded.
There is no such function in Excel and to workaround this problem you have two options:
- help yourself using VBA (solution from here),
- consider using a plugin (spending 39 USD), i.e. Kutools for Excel.
Here, I’ll discuss first option.
One of many wrongs, fuckups and things that are missing in Microsoft Outlook is the fact that you can’t set default signature for every new calendar meeting invitation, as you’d do for any new email message.
Things gets even worse as you dig through the problem and realize that Outlook developers were stupid enough to force you to design a whole new meeting template instead of just giving you an option to enable or disable this feature (as — again — it works in case of emails).
When running my HP LaserJet Pro M426fdn for the first time I didn’t removed touchscreen foil and my finger slipped over when selecting location of my printer. I ended up with having proper language but location set to Estonia and some reports (like Google Cloud Print configuration leaflet) printed in cyrylic.
Unfortunately, due to extreme stupidity of HP engineers you can only change language of your printer using standard configuration menu. But, in order to change location of the printer you have to perform a full factory reset of your hardware.
And here my problems started, because none of the solution I found seemed working on my printer.
I had some problems with my Polycom SoundPoint IP 331 PoE phone and I decided to write this short guide / memo to have everything in one place for future use instead of digging this information from the Internet over and over again.
To add single directory (with all files and sub-directories) simply execute:
zip -r zip_file_name.zip name_of_your_directory
To add all contents of current directory (again, recursively) call instead:
zip -r zip_file_name.zip *
While to add two or more directories (but not all) in current directory — list them:
zip -r zip_file_name.zip directory_a directory_b directory_c
zip to see all switches, options etc.
If you ever need to turn some Android-based device (like a spare tablet) into single-function device (like auto-started browser with precisely selected website and all other functions disabled) then there’s a great article at Android Enthusiasts that explains in quick, sharp words, what you need to achieve this (some time and cash).
Sometimes QNAP changes file owner to
admin:administ (actually to
admin user in
administrators group) which may cause some troubles on certain FTP operations when you’re logged in to QNAP’s FTP server with user different than
admin (using this user to operate on FTP is a quite great mistake and you should always use other, less privileged user for this).
chown command you can easily fix this.
I’m using newest version of webtrees (1.7.9) and even though I have Control panel > Manage family trees > Preferences > Lists > The date and time of the last update set to
Hide, I could clearly see that field in
Facts and events sections of each person’s record.
Here is the solution how to hide that (and many more sections).
There are several ways, how one can access a website. Using domain name (i.e.
http//www.example.com/) is one of most popular. We can also use IPv4 address (i.e.
http://188.8.131.52/). In certain situations URL can be “enhanced” with port number, login and password etc.
A bit less known option is to access an URL using IPv6 address. You only need to enclose it inside square brackets i.e.:
Edit: Thanks to Foo Bar for correcting an obvious, yet fundamental mistake to this article.
When you press Alt+F7 in Total Commander, you have access to really powerful search functionality. Unfortunately, the
Load/Save tab allows loading and saving of search parameters, not the search results.
However, there’s a hidden gem that allows you to copy search results to clipboard and then you can paste them to Notepad and save them to file. Just press Ctrl+C when list of search results is focused. A single “blink” of window will tell you that contents are copied to clipboard.