bsod - Windows 7 Shutdown Delay

I am experiencing an issue with Windows 7 Professional. The computer experiences some issues randomly (internet connectivity, slows down, etc). At this point I will try to shutdown the computer, which ends up taking at least 15 minutes. The computer logs out and displays "Shutting down" for 15 minutes. Eventually it will shutdown. When it comes back up it displays an error message and indicates that there is a dump file.

Does anyone have any suggestions? I have already rolled back recent updates but it doesn't seem to have helped. I can link the dmp files somewhere if they would be of help.

Thanks!

microsoft excel - How to apply a formatting rule to a whole row based on a cell value

I'd like to Bottom Border to a whole row where a certain cell is non-empty. I have managed to do that by using conditional formatting formula =$A2<>"" and applied that to the whole column.

My problem with that solution however is that it only creates the border only for the single cell and I want the whole row to have the border. It doesn't look like there is anything can be done from the "Format Cells" dialog.

EDIT:

Below is what I have at the moment:

And this is what I want to achieve (assume that the bottom border goes until the end of the row):

This is the conditional formatting rule that I applied:

Any other way to achieve that?

Answer

Do you want the formatting for every row to be based on the value in cell A2? If so, just select the rows you want to format, and use this conditional-formatting formula: =$A$2<>"".

If instead you want each row's formatting to be based on the value in that row's A column, just use the conditional-formatting formula you already mentioned: =$A2<>"".

partitioning - How do I shrink a partition on Windows, it seems broken?

Hello. I'm using Windows Vista Home Premium 32 bit.

After managing my software moving it to some other partition for another OS, I have a partition table that is a bit bizarre. In fact, for example, I can reduce the C: partition to only 14 GB (instead of 70 GB), and I can't add those 14 GB to the partition F:.

So, I ask to you if there are some ways to fix my partition table, without touching the actual OS. (Maybe working when the OS start, or in the pro-visionary modality).

I think this is an hard or maybe impossible request, but I'm looking for a solution I could try!

I remember in the past I use Partition Magic, and sometimes it works for this kind of stuff.
(But, sometimes, not at all hehe).

Cheers

Answer

A great tool that I use to shrink, expand, or even delete partitions is GPartEd (Gnome Partition Editor). The data center I work at uses this tool sometimes too (it's trusted). I would just advise that you attempt to backup your precious data first because I have had a computer BSOD on me after using GPartEd before.

Good luck.

laptop - Swap FN modifier for a particular key

I have recently bought a new laptop and I have a keyboard "steelseries". The keyboard is of very good quality overall, with just a small problem :

The keys "PageUp" and "Origin" are on the same physical key, as well as "PageDown" and "End". The default behavior is to execute "PageUp/PageDown", and I need to hold "FN" to be able to type "End" or "Origin". Not really convenient for a programmer...

Is it possible to swap the FN function just for these particular keys ? I'd like the default behavior to be "End/Origin" and not "PageUp/PageDown"

I am running Windows 10

The actual laptop is a MSI Ghost GS60

Answer

You can use a software mapping tool, such as AutoHotKey or SharpKeys

Although you know this, I put in for clarity (for other visitors) but the search phrase you need is "

software keyboard mapping

Or

keyboard mapping tool

These will usually bring up a wealth of information.

hard drive - Windows 7 "freezes" (chills?), and then "unfreezes" after about 1 minute

I have an Acer Timeline 1810T netbook (4GB RAM) with Windows 7 x64.

About once or twice a day, it "freezes" - the reason I put this in quotation marks is that it does not really freeze, as I you cant move mouse, etc.

I can move my mouse and jump between different applications, but I cant use the applications for anything. So I can jump between notepad and Firefox, but I cant browse to a new web page.

I have been trying to determine the source of this misery for a while now, and I suspect it has something to do with the hard drive - indirectly if not directly. Here are some screen shots of the resource monitor during a "freeze" and during normal operation:

Freeze:

Normal operation:

As you can see, CPU is fine during freeze, but the disk is going bananas.. Does anyone have an idea of what these reading means, or about the problem in general? There seems to be no specific activity that sets this off - it can be during browsing, or during media playback with nothing else open.

The fact that I can see navigate to applications but not use them might suggest a hard drive problem as well? Maybe I can access the stuff that is in RAM, but not anything that would require interaction with the drive.

keyboard - Windows: Why does the Alt Gr key does not work when an RDP session is running?

I came across some really strange behavior in Windows 7. I usually have open a remote desktop connection to another Windows (Win 7 or 10) machine. Nevertheless, I mainly work on the local machine. Everything, including the Alt Gr key works perfectly. Now let's say I lock my PC by pressing Ctrl+Alt+Del and unlock it again, the Alt Gr key just does not work anymore. I need to Alt+Tab to the Remote Desktop Window, then Alt+Tab back to some local program like some browser and - voilá - it works again.

This is a problem as some characters on a German keyboard can only be accessed by using the Alt Gr modifier key. When entering passwords I don't usually see what characters I type, so this causes failed login attempts.

Note that I already completely re-installed Windows on both the remote machine as well as the local machine and it does not seem to depend on which remote machine I am connected to. (However, I cannot tell if this also happens when connecting to remote machines running other OSes.) And, of course, when I am not connected to any RDP session, I don't have any issues with that key.

While researching on this issue I stumbled upon this link, unfortunately it does not provide a solution:
https://forum.devolutions.net/topic9714-altgr-key-disabled-by-rdm.aspx

Some (German) Microsoft help page suggested to switch the "Apply Windows key combinations" in the RDP settings to "On this computer" - however, it does not change anything.

Any further suggestions?

Make OneDrive desktop play nice with Bitlocker protected drives

Here is my environment:

• Windows 10 (also occurs with 8.1)


• System partition C: is not encrypted using bitlocker


• "Data" partition E: is encrypted using bitlocker with manual unlock


• OneDrive desktop sync location: E:\OneDrive

When Windows starts, I manually unlock E: using my passphrase.

The problem

When my computer starts, OneDrive complains that my OneDrive sync location is not available. This is because the location is within a bitlocker-protected drive that is not yet unlocked.

We couldn't find the location of your OneDrive folder.
Click OK to reconfigure your OneDrive folder.

[OK] [Close]

Whether I click OK or close, OneDrive deletes its own configuration and starts from scratch. "Hello, this is OneDrive, a place for all your files blah blah blah". I am forced to reconfigure the sync location and a very long sync operation starts.

This has been reported on technet and on uservoice [1, 2]. The only answer people get is:

Encrypt your system partition and enable auto-unlock for your secondary partition. This way the partition will be unlocked before OneDrive starts.

OK but I do not want to encrypt the system partition. I want OneDrive to wait for my partition to be unlocked and then do its job.

Question

Do you know a way of delaying the startup of the OneDrive desktop app?
This would avoid the bug.

Do you know any other trick that would prevent the app from deleting its own configuration and state when this occurs?