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.

Technology Insights

Outline Every Cell In Every Row Of A Table Using Textile Formatting

Textile formatting is used in numerous wiki applications and other places where easy formatting is needed for text input fields without using a WYSIWYG interface. Currently I am using textile a bunch because I spend at least some time every day adding tickets, updating tickets, and adding/modifying wiki pages in Redmine. In Redmine you have the option of using Textile formatting or no formatting by default. If anyone is on the fence regarding Textile formatting I suggest you give it a chance as it grows on you after a short amount of time.

There are a couple different ways to outline each cell within a table created using textile. Below I will explain two options available to put a border around each cell. First lets explain how to create a basic table of cell provider email addresses using Textile.