Greatest Hits

136
votes
5answers
278k views

How do I get the distinct values in a column in Excel?

If I have a column with values, and I want to find out what distinct values are in there (not how many - but the actual distinct values), how can I do that? In SQL Server I would do something like ...
41
votes
8answers
119k views

Why Virtual Box won't give me option to create 64 bits guests?

My host is x64 bits Windows 8.1. I downloaded the latest Virtual Box (4.3) and I'm trying to create a VM with a 64 bits Ubuntu OS (ubuntu-12.04.3-desktop-amd64). When I go to New VM wizard, it ...
17
votes
2answers
66k views

Windows 8.1 & manual removal of “Sentinel Runtime Drivers”

I'm trying to install Windows 8.1 (basic upgrade from Windows 8). It is complaining of Sentinel Runtime Drivers incompatibility. I've looked for it in my Programs & Features list, but it's not ...
52
votes
3answers
362k views

How do I enable Automatic Logon in Windows 7 when I'm on a domain?

When Windows 7 is joined to a domain the option to automatically login is no longer available in the advanced User Management console. Since I am running a small home domain because of SharePoint and ...
41
votes
8answers
151k views

How to tell how many CPUs (cores) you have on Windows 7

I got me a nice new laptop and I want to know a bit more about the hardware. How can I see how many CPUs my computer has in Windows 7? (Note: Clicking on Start->Right clicking on Computer-> ...
21
votes
5answers
219k views

How to create a bootable USB Windows OS using Mac OS X

I'm having a trouble here because of my PC got infected today and I've tried everything to get it back to normal, but the only option left for me now is to do a clean install. Now, what happen is ...
36
votes
7answers
478k views

How do I change the wallpaper of Windows 7 Starter Edition?

Is there a way to change the desktop wallpaper in Windows 7 Starter Edition? I wanted to do that on my new netbook, just to find out that there is no "Customize" option in the control panel. Microsoft ...
47
votes
11answers
167k views

Can't delete folder and I am admin. “You need permission to perform this action. You require permission from…”

I can't delete a certain folder in Windows 7. It's not a system folder. It was created by an app. I get an error message "You need permission to perform this action. You require permission from ...
350
222
votes
6answers
142k views

How to chmod 755 all directories but no file (recursively)?

How to chmod 755 all directories but no file (recursively) ? Inversely, how to chmod only files (recursively) but no directory ?
55
votes
9answers
156k views

How to control master volume in Windows 7?

Some keyboards have volume controls on them that can be pressed anytime to control the master volume. My keyboard does not have that. Is there a way that I can create a key macro that will work like ...
20
votes
11answers
230k views

How can I set the fan speed to 100% on a laptop?

I recently purchased a HP Pavilion dv7-4031. When it's cool, it works smoothly and efficiently. However when CPU and GPU temperatures reach 60c and above, the PC starts freezing up and stuttering. I ...
7
votes
3answers
50k views

E_FAIL (0x80004005) when running Linux through Windows 8 Virtualbox

I wanted to run Linux through my Winows 8.1 machine using VirtualBox as hypervisor. After I tried adding Ubuntu (or Fedora, on another instance) to the list of virtual machines, I clicked Start, but ...
385
votes
4answers
142k views

How do I scroll in tmux?

I just started using tmux, and I really like it, but I need to be able to scroll within the buffers/panes/windows I have open. I don't care if it works with the mouse or not. When I search the tmux ...
365
14
votes
2answers
146k views

mysql how to fix Access denied for user 'root'@'localhost'

Before I screw up something, when login using $ mysql -u root -p , and show databases, +--------------------+ | Database | +--------------------+ | information_schema | | mysql ...
133
votes
13answers
242k views

How can I download an entire website?

How can I download all pages from a website? Any platform is fine.
82
votes
6answers
206k views

How can I give write-access of a folder to all users in linux?

I installed apache2 on Ubuntu just now, and noticed that the /var/www folder is protected. I can just sudo everything but I would rather just give it write access. How can I do this? I tried sudo ...
13
votes
14answers
93k views

How to easily remove hyperlinks from multiple cells?

I have data exported from a tool as XLS. In this, one of the column has text which is a hyperlink to information in the tool. I can remove the hyperlink for each cell. But I want to remove the ...
17
votes
6answers
174k views

The Outlook data file can't be accessed, how do I repair it?

I am using the beta 2010 Office Outlook. When I try receive or send, I get the following error. Outlook data file cannot be accessed. Repairing and reinstalling Office and trying to use any ...
12
votes
11answers
178k views

Recovering Excel documents that were closed without saving

Can I ensure that if I mistakenly close a Microsoft Excel document without saving the latest version, that I can recover some of the work I've done? I'm using Excel 2003.
14
votes
9answers
98k views

Chrome new tab page changed but I want it back

I'm using Google Chrome version 21.0.1180.89 m (on Windows 7). The problem is that I installed an anti-virus program that accidentally changed the home page (I didn't uncheck the option). Now every ...
24
votes
5answers
197k views

How to write multi lines in one Excel cell?

I want to write multi-lines in one MS Excel cell. But whenever I press the Enter key, the cell editing ends and the cursor moves to next cell. How can I avoid this?
25
votes
3answers
203k views

Where does Chrome save its bookmarks on Windows?

I'm trying to recover a Windows system from backups and can't seem to find where Chrome saves its bookmarks. Does anybody know where Chrome saves its bookmarks on Windows?
11
votes
4answers
80k views

How to delete $RECYCLE.BIN folder on external hard disk?

I have a $RECYCLE.BIN folder on my external hard disk that takes up space and contains files that should be deleted permanently. I know that I am allowed to delete this folder, but how do I do that? ...
97
votes
9answers
49k views

Revert New Tab Page Behavior in Google Chrome 29+

I don’t like the behavior of the new tab page in Google Chrome 29+. How can I restore the old behavior? The new tab page (if you have Google set as the default search engine) now shows the Google ...
85
votes
7answers
49k views

Turn on the link hover statusbar in Google Chrome

I want to turn on the feature where whenever I hover over a hyperlink and in the bottom lefthand corner it shows a light blue hover tooltip about where that link goes. It looks like that since some ...
3
votes
4answers
124k views

How can I find a lost folder in Outlook?

How can I find a folder that was accidentally moved into an unknown folder in Outlook? I can find messages in the folder and looking at their properties gives me the name of the folder but not where ...
49
votes
8answers
119k views

How do I stop the Windows 8 restart clock; '15 minutes' and counting…?

The question is pretty much in the title. Windows 8 is restarting, I probably only have like 13 minutes by now, but I can't have my computer shut off, doing like 20 different things on a couple of ...
10
votes
3answers
97k views

How can I unlock a Microsoft .docx document?

I have a Microsoft .docx document that is locked down and can't even be viewed without the forgotten password. I'm wondering if there is an easy way to unlock it or get the computer to remember the ...
25
votes
7answers
36k views

How do I fix the Shellshock security vulnerability in debian testing/jessie?

The test command x='() { :;}; echo vulnerable' bash shows that my Debian 8 (Jessie) installation is vulnerable, even with the latest updates. Research shows that there's a patch for stable and ...
173
votes
10answers
287k views

How can I do a Cache Refresh in Google Chrome?

I dunno what exactly it's called, by cache refresh I mean, refresh the page after clearing its cache. I don't want to clear the entire browser cache. I prefer Chrome's Dev panel against firebug... ...
180
votes
10answers
28k views

Is there still a reason to choose a 10,000 RPM hard drive over an SSD?

For anyone who's serious about storage performance, SSDs are always the fastest solution. However, WD still makes their 10,000 RPM VelociRaptor hard drives, and a few enthusiasts even use ...
15
votes
3answers
233k views

How can I check a system's current NTP configuration?

I need to verify the current NTP configuration on some Windows systems. Ideally, I'd like to be able to do this via command line instead of navigating through configuration screens. (I'm working on ...
6
votes
5answers
144k views

How to enter BIOS setup in Sony Vaio SVT11125CGS

I wanted to install Ubuntu in Sony Vaio T series 11.6 ultrabook (SVT11125CGS). But I could not get into BIOS setup to change by booting option to USB. How do I get into BIOS setup?
196
656
votes
3answers
130k views

Transatlantic ping faster than sending a pixel to the screen?

John Carmack tweeted, I can send an IP packet to Europe faster than I can send a pixel to the screen. How f’d up is that? And if this weren’t John Carmack, I’d file it under “the interwebs being ...
31
votes
14answers
152k views

How to change the background color of a single page in Word 2010?

I can easily change the page color of every pages in my document thanks to the Page Layout Tab in the Ribbon, but I would like to change the color of a single page. Any idea about how to to this with ...
10
votes
6answers
114k views

How to disable the Java “Security Warning” popup?

Is there a way to disable this Java Security popup? I only use sites on my intranet and each page is home to 40+ applets that generate a new ID with each load. Because of this, every time the page ...
95
votes
7answers
56k views

How do you prevent the dock from switching monitors in OSX Mavericks?

In Mavericks, Apple introduced a "feature" where if you hover at the bottom of any screen the dock pops up on that screen. This is disrupting my workflow as I am constantly having the dock pop up ...
32
votes
3answers
91k views

Change from IDE to AHCI after installing Windows 8

I had my drive controller configured for IDE when I installed Windows 7. This didn't change when I upgraded to Windows 8. I now need to enable AHCI, but doing so causes Windows to fail to start. It ...
63
votes
9answers
175k views

What is the Linux command to find out hardware info?

I need to find out hardware information for the below items under Linux: CPU (and cores) CPU speed Memory Hard disks OS version Any advice?
257
10
votes
4answers
76k views

Setup static IP under Ubuntu 14.04 Trusty

How to setup static IP address under Ubuntu 14.04 Trusty? My setting is not working. What special about Ubuntu 14.04 Trusty is that I found it now using the "source-directory" keyword to source ...
1
vote
3answers
67k views

How to reformat HD from GPT partitions to NTFS partitions for Windows 7 install?

I want to install Windows 7 on a brand new machine that is currently running windows 8. The drive is divided into 6 partitions: one for the OS, three reserved for OEM, one for MRS and one as primary. ...
82
votes
10answers
200k views

How do I get an entire directory in sftp?

I'm just learning to use sftp, and I want to copy a directory from the remote computer to my local computer. If I try get [directory] it gives me this error: Cannot download non-regular file: ...
299
1
vote
3answers
107k views

How do I enable the Windows 7 taskbar hover preview?

In Windows 7, when you hover over an application in your task bar, a preview is generated showing the contents of the application window. Another option just displays the names of the windows. ...
56
votes
3answers
146k views

What is the difference between i686 and x86_64?

I have an AMD Turion and do not know what to choose between these two versions to install Arch Linux. Thank you.
141
votes
25answers
132k views

What can I do to stop the Play / Pause button from opening iTunes?

In Snow Leopard the Play / Pause media button (on the F8 key) opens up iTunes. How can I disable that? Preferably keeping the old Leopard behaviour, so I can use it to control other media applications ...
113
votes
6answers
116k views

In Mac OS, what is the keyboard shortcut to switch between windows of the same application?

I often use the Cmd+Tab shortcut to switch between different applications (for example: Xcode and Google Chrome), but is there a shortcut to switch between different windows of the same application ...
1
vote
1answer
106k views

Can't access Extender via www.mywifiext.net

I have a NetGear WN2000RPT wireless Extender and I am having trouble getting to its initial configuration page. The instructions to configure the device are: Power on the device. Connect a ...
120
votes
14answers
202k views

How to download files from command line in Windows, like Wget is doing?

How can I download something from the web directly without Internet Explorer or Firefox opening Acrobat Reader/Quicktime/MS Word/whatever? I'm using Windows, so a Windows version of Wget would ...
3
votes
4answers
121k views

How to format Windows XP without CD?

I have only one partition called C, that drive holds the operating system and all the documents. I don't have a CD-ROM hence I can't use the installation CD. Is there any way to format the drive or ...
31
votes
4answers
127k views

How to remove the print preview lines in Excel 2010?

Somehow or other I have managed to switch on the print margin lines in Excel 2010. I cannot seem to turn them off. I went to Page Layout->Page Setup->Print Area->Clear Print Area but the lines remain ...