Archives for Productivity Tips - Page 5
Creating and Using Drop Down lists in Excel
Using the drop down list values in a cell In the Cell, Click Data >Data the Settings tab, in the Allow box, click List. In the Source box, type and…
DisplayPort or HDMI port takes over audio of PC
You can either revert back to your PC speakers or you can continue to use your HDMI monitor as the audio output you want to revert to the PC speakers…
Add single quotes around values in excel column
Go to Format –> Cells –> CustomType '@'
Hide gridlines in Excel
Select multiple sheets , On the View tab, in the Show/Hide group, check/uncheck the Gridlines check box.
.NET Framework 2.0 and 3.5 feature install fails on Windows 8.1
I tried to enable this feature on Windows ( as part of a SQL Server 2014 installation) - it failed. I tried downloading the redist executables separately - and installing.…
Windows Server–Adding Roles and Features Hangs
This seems to be a common occurrence. The workaround I have found invovles Powershell . Simply Export the Configuration Settings – into say c:\ Run the following command in a…
PC cleanup
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
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…
Word 2010 Pictures do not show up
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…
Roadmap for Windows Server Products
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…