1,453 reputation
61940
bio website blog.richardhartness.com
location Charlotte, NC
age 33
visits member for 3 years, 4 months
seen Dec 16 at 16:08

I am a software architect, living in Charlotte, NC.


Jun
27
comment How can I quickly determine if an Excel spreadsheet contains any formulas or is just “static” text?
Actually, chuff's comment to David Yaw's post is what I am looking for. That will work too.
Jun
27
comment How can I quickly determine if an Excel spreadsheet contains any formulas or is just “static” text?
I understand now. I see that you have a solution. Let me see if there is a way that I can craft a conditional format that can highlight cells that have formulas in them.
Jun
27
comment How can I quickly determine if an Excel spreadsheet contains any formulas or is just “static” text?
Day: No, when you go to show the formulas, it should shows all of the formulas for the entire worksheet, not just one cell. Is this not sufficient?
Jun
27
comment How can I quickly determine if an Excel spreadsheet contains any formulas or is just “static” text?
Oh, I just noticed chuff's original comment. Control + ` (Backtick) is executing the menu command I'm referencing in my answer.
Jun
27
comment How can I quickly determine if an Excel spreadsheet contains any formulas or is just “static” text?
Please see my answer. This feature is integrated into Excel. All you have to do is either show or hide your formulas, rather than display their evaluated values.
Jun
27
answered How can I quickly determine if an Excel spreadsheet contains any formulas or is just “static” text?
Jun
27
answered Retina MacBook Pro 13 inch screenshot resolution is higher than built-in display
Jun
25
awarded  Notable Question
Jun
25
revised User receiving an “Error Code: 403 Forbidden” but no one else is. What can I suggest that they do to fix it?
edited title
Jun
25
awarded  Notable Question
May
27
awarded  Famous Question
May
21
comment How to change Explorer's default location via the registry?
qwilson, thank you for your help. I thought I did mention that I needed this to point to C:, buy I see that I made a mistake. Karan, is there a way that I can update my bounty description? I don't see a modify button.
May
20
comment How to change Explorer's default location via the registry?
qwilson: That's exactly what I did. Thanks for the screen shot. I don't know why this won't work for me. I tried updating the target using both your examples and it still didn't work.
May
20
comment How to change Explorer's default location via the registry?
When you say right-click on the explorer icon on your taskbar, what are you talking about? In my case, I have a pinned folder, but I have to click it, and then right-click on the option that is titled "unpin this option from the taskbar" to see the Properties option. Regardless, modifying the target of the Win Explorer shortcut didn't fix it. Could you add a screenshot?
May
20
comment How to change Explorer's default location via the registry?
This doesn't solve the problem, if you open Windows Explorer by use of the Windows Hotkey.
May
20
awarded  Investor
May
20
comment How to change Explorer's default location via the registry?
I would like for Explorer to default to `c:` for me. I asked this question but I've deleted it so that I could just up-vote and promote this question. Please note, I'd really prefer to do this through the Registry, if this is possible. I'm not interested in doing this with a third-party, hotkey app. Adding a 50 rep bounty.
Apr
15
awarded  Popular Question
Mar
19
comment How can I set a dual-display, single-background when my primary display is on the right?
If what you are stating is that I should drag & drop my monitor orientation from the above screen that, that is what I did. I've long been aware that you could do this with multiple monitors. However, I noticed that this did not function properly when you placed the Task bar on the Right-side AND made it your primary display.
Mar
18
awarded  Notable Question