Running Office 365 apps in Safe Mode

There’s a handy Safe Mode for all Office 365 offline apps (and probably for older version of Office as well) that you can use to start any Office app without any add-ins and many other things (like themes, animations, etc.) turned off or disabled. Very handy for diagnosing possible problems with some Office app.

To enable it, simply hold Ctrl key when launching any of Office app. When you see app’s button in the taskbar, release the Ctrl key, click that button and answer Yes in the dialog window that appears:

That would be pretty much all.

Simple data validation or enum fields in Excel

Excel is still often used for simple time tracking or roadmap planning in small IT projects. It is good to know that with a simple steps you can create a basic data validation for certain fields in your sheets.

Kind of validation, as discussed here, focuses on forcing user to select or enter only values that are found in some reference list (dictionary). A classing enum / enumerator field well known in databases. If user provided an incorrect (out of scope) value then an error is displayed:

Unfortunately, due to nature of Microsoft Excel, this fails completely when data is pasted.

Read More “Simple data validation or enum fields in Excel”

Silently delete a folder in Windows and… yourself

Here’s a quick batch file for DOS / Windows that deletes selected folder and then deletes itself:

@echo off
:try
rmdir "C:\Trash\Temp" /S /Q
if exist "C:\Trash\Temp" goto try
del %0

Creating an endless loop for deleting a folder stinks like a hell, but I haven’t figured out anything better so far.

Get rid of “Pick up where you left off” from Word — three methods

Microsoft loves to “enrich” our lives with a wonderful (in their opinion) yet totally useless and pissing off (in our opinions) features. The “Pick up where you left off” is one of them.

This tiny little thing wouldn’t be so irritating and could be easily ignored, if it wouldn’t be for a single fact. It blocks keyboard shortcuts completely, until it hides itself (so for approx. 3-5 seconds)! Preventing you from pressing Ctrl+F to do an ultra-fast-searching-millisecond-after-opening-a-document (my beloved feature).

There’s a fairly easy solution to this problem (my own article) that requires you to do some dirty tricks in the Windows Registry. One and a half month after writing that article it turned out that a method described there simply isn’t working at all on one of my computers. So I came out with the following post.

Read More “Get rid of “Pick up where you left off” from Word — three methods”

Disable “Pick up where you left off” in Word

The “Pick up where you left off” is one of the worst features that Microsoft added to Word, because it prevents you from quickly opening and searching the document. With this feature enabled, now you have to wait approx. 3-5 seconds after you open any document and before you can hit Ctrl+F.

Disabling this feature is fairly easy, but — because this is Microsoft — again involves messing up with the Windows Registry, so you need administrator account in order to perform these steps.

Read More “Disable “Pick up where you left off” in Word”

How to get “Microsoft Print to PDF” virtual printer back to Windows 10

I have removed “Microsoft Print to PDF” virtual printer from my Windows and getting it back was a little bit more painful than I previously anticipated. Some solutions found in Internet simply turned out to be worthless. Finally, I found a solution that was both easy and working.

I decided to write this little memo to not look for it again.

#

Remove one-letter word (orphans) from the end of line

In English an orphan is:

A paragraph-opening line that appears by itself at the bottom of a page or column, thus separated from the rest of the text

Thus, in English typography it is understood in the context of the whole paragraph. Single line of a new paragraph, left alone on the preceding page (before page break) is not allowed.

Polish language is more strict by that and “explores” an alternative (less known) definition of “orphan”. In Polish typography this term is understood in the context of single line and regarded as a:

Single word (single letter in most cases) left along at the end of line (next to right paragraph).

And similarly this is prohibited in Polish typesetting.

In this article you can find a Word macro for removing such orphans from your text.

Read More “Remove one-letter word (orphans) from the end of line”