T.J.L.
  • Member for 6 years, 4 months
  • Last seen this week
  • New Hampshire
2 answers
30 votes
6k views
"Run as Administrator" vs "Run (As Admin!)"
107 votes

"Run as administrator" appears to be a normal Windows 10 context menu entry. "Run (As Admin!)" is very much not a normal entry - Microsoft does not use exclamation points in commands like that. ...

View answer
2 answers
4 votes
391 views
Excel vlookup reference purposely missing shows #N/A - stop it
9 votes

You want to use the IFERROR function: =IFERROR(VLOOKUP($P5,GW30!$CI:$CL,2,FALSE),"") If there's no error, it will return the value as normal. If there is, it will return what's after the comma, in ...

View answer
1 answers
0 votes
3k views
HP charger burnt?
5 votes

If the machine is new (rather than new-to-you) and only a month old, it should still be covered under warranty. You need to contact HP Worldwide Limited Warranty and Technical Support. They may be ...

View answer
9 answers
4 votes
6k views
Why I can't access 8.8.8.8 IP address?
4 votes

You can access 8.8.8.8, but it only responds to the right questions. A DNS server is akin to a telephone book. Pointing your web browser directly at 8.8.8.8 is like smacking the telephone book with ...

View answer
1 answers
2 votes
9k views
How do I roll back to a specific version of Office 2016?
Accepted answer
2 votes

The techniques described in magicandre1981's answer to Office 2016 Advanced Setup can be applied to accomplish a rollback, too. You just need to know the specific version number you want. Fortunately, ...

View answer
2 answers
2 votes
4k views
Reprogramming Keyboard to Create Right Click
2 votes

Short answer: Probably not. Long answer... The Fn key is generally found on laptops and other small-form factor keyboards. In most It is not sent to or processed by the OS, but rather internally to ...

View answer
3 answers
-2 votes
5k views
Can i setup cluster for windows 7?
Accepted answer
2 votes

Clustering is for massively parallel computing tasks. In order to take advantage of clustering, you would need to be running specific software designed to do so. You will gain no performance ...

View answer
1 answers
0 votes
26 views
Group multiple worksheets under one sheet in excel
Accepted answer
1 votes

No. An Excel workbook contains one collection of worksheets. You cannot nest one worksheet inside/under another worksheet.

View answer
1 answers
1 votes
40 views
Understanding monitor and secondary monitor resolutions
1 votes

Generally speaking, secondary (or tertiary, or...) displays can either be set up as duplicates or as additional displays. What's actually going on in the internals is mostly irrelevant, because the ...

View answer
2 answers
2 votes
2k views
How to get print screens on Win 10 without (black) borders in MS paint?
1 votes

The single-pixel "border" you're trying to remove is part of the window. The Windows window manager is going to report that as part of the window to any automated capture tool. You're not going to ...

View answer
1 answers
1 votes
8k views
Is there an alternative way to span three displays when using a Nvidia Graphics card?
1 votes

I use a piece of software called DisplayFusion to manage multiple monitor profiles. It can save and restore preset configurations, including spanning and even virtual sub-monitor splits. It also has ...

View answer
2 answers
2 votes
928 views
Excel on Mac - conditional formatting only works until other condition
0 votes

Note that my experience is entirely in the Windows-based version, so if the Mac version has any inexplicably different behaviors, it may just be Mac-version-strangeness. That said, I can't think of ...

View answer
2 answers
1 votes
2k views
Excel - conditional formatting between two columns of numbers (greater or less than)
0 votes

By default, when you select cells to create Conditional Formating it uses static cell references - $B:$B for example. You need to edit the appropriate references in your formula to remove the static ...

View answer
2 answers
1 votes
584 views
One keyboard / mouse for 2 desktops, how?
Accepted answer
0 votes

Using multiple ports in the display is a more cumbersome approach than simply buying a cheap two-port KVM switch. Units with four, eight, or more ports exist, but the price ramps up quickly.

View answer
1 answers
-1 votes
531 views
can i use a laptop charger with same input voltage but differen input amperage?
0 votes

Your best bet is always to replace it with an identical device from the original equipment manufacturer. However, the entire point of the power brick that comes with a laptop is to convert wall power ...

View answer
3 answers
0 votes
83k views
excel 2013 leave cell blank if it has no data
0 votes

Not much to this one... Check for blankness, use "" if the reference is blank, otherwise do your math. =IF(ISBLANK(A2),"",A2*15) ...adjust references to taste.

View answer
1 answers
1 votes
847 views
Subdomains on .io domain
Accepted answer
0 votes

Despite some (ab)uses - *.tv probably being the most notorious - two-letter Top Level Domains are assigned to specific countries. Some registrars are more permissive than others about what may be done ...

View answer