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.
I have been doing a lot of work in Microsoft Excel lately and there are certain basic tasks that I have never spent the time to learn or at least to remember. One of those items is merging cells together which I typically use for titles of sets of columns in the Excel documentation work that I am performing. Use the steps below to merge cells together.
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.
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.
When working on a project where I was required to merge two sets of like data to make sure there were not any conflicts I needed a way to dump PostgreSQL database tables to Excel formatted .CSV files. Anyhow dumping Postgres tables to excel is easy to do by following the below directions.