Nathan DeWitt
  • Member for 12 years, 5 months
  • Last seen more than 2 years ago
  • Hampton, VA
7 answers
326 votes
973k views
How do I get the distinct/unique values in a column in Excel?
138 votes

Excel 2007 and 2010: Use the Remove Duplicates menu option under the Data header. Excel 2003: Easy way: Make sure your data has a header Data --> Filter --> Advanced Filter Check Unique Records ...

View answer
9 answers
15 votes
52k views
Fastest way to type in math formulas out of the box?
20 votes

I love using the built-in Equation Editor in Word 2007. Alt + = brings up the editor, then you type this: (a+b)^n=\sum_(k=0)^n (n\atop k)a^k b^(n-k) This will produce the following: It doesn't ...

View answer
7 answers
2 votes
11k views
Best freeware to remove redeye in images?
Accepted answer
16 votes

Picasa will do this. Check out this tutorial.

View answer
3 answers
2 votes
21k views
Will Windows 7 Home Premium access company domain?
Accepted answer
10 votes

Check out this feature comparison chart. You can see if you scroll to the bottom that joining a domain requires Pro, Enterprise or Ultimate. All versions can use Remote Desktop to connect to another ...

View answer
2 answers
8 votes
979 views
2 different laptops, 1 home office setup
8 votes

You can get an HDMI KVM. This will let you plug one monitor/mouse/keyboard into two computers.

View answer
3 answers
9 votes
131k views
How do I uninstall Windows 8 Consumer Preview?
8 votes

If you install to a VHD, then getting rid of it is a simple matter of booting into Windows 7, deleting the VHD file, and deleting the Windows 8 entry using msconfig.exe. I'm not trying to be snarky,...

View answer
4 answers
7 votes
467 views
Is there any 64-bit software for Windows that is much preferable to its 32-bit counterpart in a 64-bit OS?
8 votes

Photoshop performs better in a 64-bit system. You can see some numbers if you scroll to the bottom here. Word on the street is that the 64-bit edition of Photoshop is 8-12% faster.

View answer
2 answers
4 votes
966 views
It is possible to reproduce the Windows 8 Fast Hybrid Boot into Windows 7?
Accepted answer
7 votes

From the Windows 8 Build Blog: The new Windows 8 Hybrid Boot is fast because of the new feature called Hybrid boot. Generally in hibernation mode, all files are saved in the same state, but in ...

View answer
3 answers
2 votes
2k views
How does a hard drive compare to Flash memory working as a hard drive in terms of speed?
Accepted answer
7 votes

One big difference is that the flash drive is using the USB bus, while the drive is using the SATA bus. So even if your flash memory was the same speed in both cases, the drive would have a higher ...

View answer
2 answers
4 votes
8k views
How to add a checkbox for a row in Excel?
Accepted answer
6 votes

Yes, you can do this. I will demonstrate using Excel 2007. Using fonts: I went to Wingdings and added a Checkmark in A1 (character code is 0252). In regular text, this is ü. Then in cell B1 I put ...

View answer
2 answers
5 votes
395 views
Is Windows Server 2003 on 96 MB possible?
Accepted answer
6 votes

Yeah, it's possible. In a cluster computing class a few years ago, we set up 8 computers running Windows XP and one computer running Server 2003, all of them well below their stated minimum RAM ...

View answer
6 answers
2 votes
21k views
Word does not maximize to full screen
Accepted answer
6 votes

I've seen this before. I had a system where I was messing around with the resolution and Word "remembered" the current resolution incorrectly. I don't remember exactly what I did to fix it, but I ...

View answer
3 answers
4 votes
4k views
How can I make Vista look like XP?
Accepted answer
6 votes

Create a virtual machine and install Windows XP. Then they will look exactly the same.

View answer
6 answers
7 votes
7k views
Windows 7 default programs won't let me choose Firefox as my default browser
Accepted answer
6 votes

Do you have Firefox installed? Ok, now that that's out of the way... Try this after exiting Firefox completely: firefox.exe -silent -setDefaultBrowser That will set firefox as the default browser ...

View answer
2 answers
23 votes
33k views
In Excel, can I provide a "default value" in case my formula returns #NA?
5 votes

It may make more sense to you if you checked the first lookup value for NA, and then checked the second, and if they're both valid then multiply them. =IF(OR(ISNA(VLOOKUP(A3,somesheet!G:J,3,FALSE)),...

View answer
1 answers
2 votes
238 views
How to run a command line script every Friday at 3:00 AM automatically?
Accepted answer
5 votes

Use Task Scheduler on a Windows system. Create Basic Task Wizard: Trigger: Weekly Recur every: 1 weeks on: X Friday Start a program Put your two lines into a bat file, then put that file into ...

View answer
10 answers
131 votes
88k views
How do I exit a Modern UI app?
5 votes

I just found a more elegant solution than three-fingered salute... Win+R, then click on the Start icon (Windows icon, bottom left). But I'm ready to use the actual method.

View answer
3 answers
4 votes
33k views
Installing SQL Server 2008 R2 on Windows 8 (Enterprise Evaluation)
Accepted answer
4 votes

According to Install SharePoint 2010 on Windows Server 8 Beta (en-US) on TechNet, you can just click on Run the program without getting help and you should be fine.

View answer
1 answers
4 votes
10k views
Word 2010, Multiple Columns, Vertical center one column only
4 votes

When you set the layout to be centered vertically on the page, it affects the entire page. I cannot find a way to do what you want - having two columns with different vertical heights. Insert a line ...

View answer
1 answers
3 votes
2k views
Increase volume level of WMA audio files
Accepted answer
4 votes

Try Audacity. It's free and you can edit waveforms.

View answer
2 answers
2 votes
357 views
Will a standard wireless router support 12 wireless users?
Accepted answer
4 votes

It should be fine - I think they support like 250 users or so. 12 users is no problem.

View answer
2 answers
2 votes
315 views
Can there be a script imitating Windows 8 fast boot-up(shut down)?
3 votes

The windows 8 fast boot includes starting up device drivers in parallel. They're also hibernating the kernal itself aside from application data. That's what makes it so fast. I don't think you can ...

View answer
2 answers
3 votes
574 views
Navigating Back with the keyboard in a Windows 8 Modern UI app
3 votes

Use Backspace and it should function as the back key like in Windows Phone 7.

View answer
6 answers
17 votes
5k views
Which virtual machine software is preferable for running Windows 8 Developer Preview?
3 votes

I installed it with no problems using Hyper-V on Windows Server 2008 R2. I wasn't able to use RemoteFX 3D Video Adapter, however. I gave it 8 GB of RAM and 120 GB hard drive space. The RAM was ...

View answer
6 answers
3 votes
725 views
What WYSIWYG HTML editor should I give a novice
3 votes

You want Cushy CMS. It's a simple online editor for web pages. You create a shell, add a class name to a div or other tag and voila! it's editable on the Cushy page. It's very easy - I use it with ...

View answer
7 answers
14 votes
11k views
Building a home cluster - hardware and cost analysis
3 votes

Check out the books Beowulf Cluster Computing by Thomas Sterling (one for Linux & one for Windows). They tell you all you need to know about using MPI to get your nodes to talk to one another. A ...

View answer
2 answers
3 votes
12k views
Where does Windows 8 put the exe of the default browser for Modern UI?
2 votes

Creating a new default browser doesn't create a new executable. As you can read on this Building Windows 8 blog entry, there is just one browser engine (the EXE) and two skins. One suitable for ...

View answer
3 answers
3 votes
9k views
Triple booting Windows 8 Consumer Preview with Windows 7 and Ubuntu 11.10
2 votes

Install to a VHD. That's what I'm currently doing. The only thing that gets virtualized is the disk, and I don't notice it at all. I used Hanselman's blog entry as a starting point, but I wrote up ...

View answer
5 answers
6 votes
1k views
Looking for "bitmap-vector" image editor
2 votes

There's a plugin for Paint.NET that allows you to do vector image creation: I don't know if that will meet your needs, but since it's free you could give it a try.

View answer
2 answers
5 votes
2k views
GarageBand Alternative for Windows?
2 votes

Cakewalk Music Creator 5 is $35 or so. I haven't used it, but I've heard good things about Cakewalk software.

View answer