45 subscribers

Windows Quirks, Email, Internet Gotchas
  |  Software Dev  |  Science Stuff  |  Travel  |  Golf Tips for Beginners  |  Entertainment  |  Mindfulness  |  Finance and Investing  |  Austin  |  India  |  Diet, Health  |  Miscellaneous  |  Sports (Non Golf)  |  

Creating and Using Drop Down lists in Excel | Posted on by Anuj Varma

Using the drop down list values in a cell In the Cell, Click Data >Data Validation. On the Settings tab, in the Allow box, click List. In the Source box, type and equal sign (=), immediately followed by the name … Continue reading

DisplayPort or HDMI port takes over audio of PC | Posted on by Anuj Varma

You can either revert back to your PC speakers or you can continue to use your HDMI monitor as the audio output source. If you want to revert to the PC speakers for your audio , try Start > Control Panel … Continue reading

Add single quotes around values in excel column | Posted on by Anuj Varma

Go to Format –> Cells –> Custom Type ‘@’

Hide gridlines in Excel | Posted on by Anuj Varma

Select multiple sheets , On the View tab, in the Show/Hide group, check/uncheck the Gridlines check box.  

I tried to enable this feature on Windows 8.1 ( as part of a SQL Server 2014 installation) – it failed. I tried downloading the redist executables separately – and installing. That failed as well.  Here are some workarounds (the … Continue reading

Windows Server–Adding Roles and Features Hangs | Posted on by Anuj Varma

This seems to be a common occurrence. The workaround I have found invovles Powershell . Simply Export the Configuration Settings – into say c:\config.xml Run the following command in a powershell window Install-WindowsFeature -ConfigurationFilePath c:\config.xml

PC cleanup | Posted on by Anuj Varma

Iolo System Mechanic – Comprehensive, License fee required – $39 SlimWare Utilities SlimCleaner   Run Geekbench Score to check if performance truly improved after running these tools.

SwitchySharp–Proxy Manager for Chrome | Posted on by Anuj Varma

SwitchySharp is an advanced proxy manager for Google Chrome. It lets you switch between multiple proxies – detect whether your traffic is going DIRECT or through a PROXY (check the GLOBE icon on the extensions toolbar).

Word 2010 Pictures do not show up | Posted on by Anuj Varma

  I pasted pictures into my documents – only to find that they did not display. It turns out that it has to do with the default wrapping style on the picture and the text. To change the Wrapping style … Continue reading

Roadmap for Windows Server Products | Posted on by Anuj Varma

Windows Server Roadmap 1. Windows Server 2003 approaching end of support in July 2015. 2. Support for Windows Server 2008 ends in Jan  2020 SQL Server Roadmap 3. Support for SQL Server 2005 ends April 2016 4. Support for SQL … Continue reading