Most Popular
1500 questions
94
votes
14 answers
Selecting whole column except first X (header) cells in Excel
I know I can select all cells in a particular column by clicking on column header descriptor (ie. A or AB). But is it possible to then exclude a few cells out of it, like my data table headings?
Example
I would like to select data cells of a…
Robert Koritnik
- 2,096
94
votes
2 answers
What do the upstream/downstream USB ports on a monitor do?
I came across few configuration of a monitor and they include many different port along with some USB ports.
Monitor: DELL P2214H, DELL P2414H
In the monitor description it mentions that there are both USB 'upstream' and 'downstream' ports. What is…
dotnetstep
- 1,139
94
votes
7 answers
How do I use ffmpeg to get the video resolution?
I am trying to get resolution of the video with the following command:
ffmpeg -i filename.mp4
I get a long output, but I need just the width and height for my bash script. How should I filter out those parameters? Maybe there's a better way to do…
Vladimir Stazhilov
- 1,075
94
votes
9 answers
Can a 7 days full 100% CPU load "burn-in" / "stress test" damage a modern notebook?
When I buy new computers, I usually do a "burn-in" with 100% CPU load for, say, seven days, in a well ventilated place.
This is to
find out if the computer has problems before I invest time into setting it up for me
let it "steam out" some of the…
Tom Stevens
- 965
94
votes
2 answers
Is there a way to identify the busy (CPU-consuming) tab in Firefox?
Sometimes there's a nasty, guilty, CPU-hogging tab in Firefox that's maxing one of my CPU cores and making the whole browser sluggish. I'd like to find it and close it.
Sometimes I get lucky, but not often enough. So even the slightest hint of…
gojomo
- 1,126
94
votes
14 answers
Turn off change file extension warning in Windows 7
Is there a way to turn off the file extension rename dialog in Windows 7?
The one that prompts you
Rename: If you change a filename extension, the file might become unusable. Are you sure you want to change it?
Simon
- 2,477
94
votes
11 answers
Why does RAM have to be volatile?
If computer RAM was to be non volatile like other persistent storages, then there would be no such thing as boot up time. Then why is it not feasible to have a non volatile RAM module?
Chintan Trivedi
- 873
94
votes
8 answers
"FATAL: lock file "postmaster.pid" already exists"
I just reinstalled postgres via brew install postgres
I ran initdb /usr/local/var/postgres -E utf8 but got this:
The files belonging to this database system will be owned by user "atal421".
This user must also own the server process.
The database…
AdamT
- 1,103
94
votes
2 answers
What do ALSA devices like "hw:0,0" mean? How do I figure out which to use?
I've searched over and over and can't find any explanation of what "hw:0,0" means. How do I determine the number of my USB audio card? MPD requires me to enter something like this:
audio_output {
type "alsa"
name …
endolith
- 7,704
94
votes
1 answer
How do I extract fingerprints from .ssh/known_hosts?
My laptop has a well-populated ~/.ssh/known_hosts file. I'd like to leverage that when connecting to remote hosts from my desktop, since tracking down the fingerprints can be a real chore. However, I can't seem to find a way to ask ssh-keygen or…
94
votes
5 answers
How can I stop Mac OS X overriding my hostname when I receive a DHCP request on Snow Leopard?
Whenever I go on a network where the DHCP server assigns hostnames then it overrides the settings I've set for my hostname on my Mac in the "Sharing" section of System Preferences.
How do I stop this behaviour from occurring and always have the same…
Mike McQuaid
- 4,187
94
votes
5 answers
How can I pass an environment variable through an ssh command?
How can I pass a value into an ssh command, such that the environment that is started on the host machine starts with a certain environment variable set to my choosing?
EDIT:
The goal is to pass the current kde desktop ( from dcop kwin KWinInterface…
Ross Rogers
- 4,807
94
votes
5 answers
How to switch between two latest windows in tmux?
GNU Screen has Ctrl-a,Ctrl-a to switch between the two latest windows.
How to do it in tmux?
kev
- 13,200
94
votes
8 answers
How can I see a visual overlay of shortcut keys I've pressed?
I've seen several screencasts (recorded on Mac OS X) which show a nice little "toast" indicating which shortcut key is being pressed by the screencaster, typically in the middle of the screen. Is this a feature of the screencasting software? Is…
lyricsboy
- 1,042
94
votes
10 answers
Are there keyboard shortcuts to scroll to the top and bottom of a document?
I'm using a Macbook and want to scroll to the top and bottom of documents using the keyboard. Is there a keyboard shortcut that does this?
danny
- 949