fixed : remove icon from behind the Dock

Question :

I somehow managed to move an icon to the outer corner of the Desktop in such a way that there’s no way to select it and move it to another location (or trash it). The document icon even got placed behind the Dock, so whenever I try to select the icon, the Dock is in front of it, and I am selecting or activating something in the Dock…

How can I fix this ?

 

Answer :

If there’s a document icon (or app icon) on your Desktop that you can’t select to use or move the document (or app), try this :

– open the Finder

– in the Finder window that opens, select your Desktop, then select the file (or app)

– now move it to another location on your Mac ; to another folder or to a new folder

– then, when you go back to your Desktop, the file will be in folder you’ve just put it in

…and if you wish, you can even drag & drop it back onto any location on the Desktop.

That’s it !

Enjoy !

Donate Button (MacManusNL)

 

Advertisements

fixed : move opened Preview-document from outer corner of Desktop

Question :

I somehow managed to move an open Preview document to the outer corner of the Desktop in such a way that there’s no part of Preview’s document window in sight that can be clicked and dragged. So, there’s no way to drag the open document onto the center of the Desktop…

And closing the document and opening it isn’t an option either, since nove of the red/yellow/green window buttons are in sight either…

How can I fix this ?

 

Answer :

Here’s what to do :

– click and hold the Preview app icon in the Dock

– in the pop-up menu that opens, click on “Show All Wondows”

– in the view that opens, select the troublesome document

…now the document will open in the centre of the Desktop, and you can drag it or close it.

That’s it !

Enjoy !

Donate Button (MacManusNL)

fixed : hashtags making text unreadable in Excel

Question :

Somebody sent me an Excel spreadsheet in which some of the data is unreadable since it has been replaced by text consisting of hashtag signs only…

I’ve seen this happening before, and the remedy used to be just to broaden the column, since all number that are too large to fit their cell width are automatically made unreadable…

However, in this case, if I broaden the column width, some of the hashtag text will turned into readable numbers, but other hashtag text will remain, no matter how wide I make the column…

What is wrong ?

And how can I fix this ?

 

Answer :

This seems to be a problem with Excel for Windows files that are opened in Excel for Mac (possibly more specifically with data copied or converted from another application into Excel on a Windows-PC). So PC-users will not be warned on forehand that their Excel output is not suited for use on Macs…

Fixing it turns out to be rather simple (but annoying) :

• open the file in Excel for Mac

• select the cells that are effected (or preferably even the entire column), then go to “Format” in the top menu bar

• from the dropdown-menu that appears, select “Cells…” and a window entitled “Format Cells” will open

• make sure the “Number”-tab is selected and make sure that you select “Number” or “General” from the list (make sure that it is something else than what was previously selected ; anything seems to be okay, as long as it is not “Accounting”)

• no return to your spreadsheet to check if the hashtag texts have disappeared (if not : try again)

That’s it !

Enjoy !

😉

Donate Button (MacManusNL)