Technology Insights

Microsoft Office Excel Keyboard Shortcut For Adding Hyperlink To A Cell

Earlier I was analyzing a bunch of data and needed to go through a couple hundred columns and fill out specific data in each column. One of the tasks I needed to complete was adding a URL to a single cell and once that URL was added to the cell I needed to then create a hyperlink for each specific cell to a configuration application that had specific data about each URL. Do complete this easier I needed a keyboard shortcut to initiate the hyperlink addition configuration window in Office Excel. Below I describe what the keyboard shortcut is and what it does.

Code Snippets

How To Make Microsoft Excel Open Multiple Windows on Windows 7

At my job we use more excel spread sheets than I care to comment on. I have always used excel for various tasks but lately I have needed to learn it more. One thing I found really anoting is that you cannot open multiple windows with excel spread sheets. This makes transfering and comparing data in between the tough. So thanks to some vetern guys at my work, they showed me a little registry hack to get this working.

Technology Insights

How To Export From PGAdmin, Export PGAdmin Data To CSV

This afternoon I was using PGAdmin and needed to export some data from a query I had run but realized I wasn’t even sure if PGAdmin had this capability. Typically I would export data using the PSQL command line but since I was already working in PGAdmin I wanted to try and figure out if the capability existed and if so how to do it. After some playing around I was able to figure out how to export PGAdmin data to a CSV (Comma Separated Value) format that would be Microsoft Excel friendly. Follow the directions below to export PGAdmin data to a .CSV file to open in MS Excel.