Linking from small places on small devices with InDesign

Linking from small places on small devices with InDesign

I thought I would share something that I find useful when creating InDesign documents with links in them for use on mobile devices as they are not always very easy to select. An example is a word in a block of text or a very small image. It is very easy to increase the selection area to more than just the hyperlink item. Here I explain how to do it in a few simple steps so you can still provide a reasonably sized navigation point from a very small place or a tiny navigation item to be hyperlinked. First draw an invisible rectangle around the place you want to show

Adding a hyperlink image button to your Outlook signature

Adding a hyperlink image button to your Outlook signature

I was asked a while back “how to make a graphic in an Outlook signature into a hyperlink button” so I showed the requestor but I wondered if others might find it useful so I thought I would share how to do this here. In preparation you will need a button image and a website or web page address. In this example I am going to add my Linked-in profile, “http://www.linkedin.com/in/howepat” to my signature using a “View My Profile” image (below). If you go to the File tab in Microsoft Outlook and select Options it will bring up the Options dialog box. From here go to the Mail page and

Internal linking to text areas within an InDesign document

Internal linking to text areas within an InDesign document

Yesterday I was asked how to create an internal hyperlink to a piece of text on a page within InDesign from a graphic. I’ve done it many times before but it had completely gone out of my head until I sat down in front of InDesign myself. I figured I would create a short article as a reminder to me but also if anyone else is interested. I’ll use a similar example as I was asked about yesterday. We had a page with a graphic that looked button-like but was an image and numerous text and graphics spread over several pages (the pictures here are not the real document). So,

Straightening images using Photoshop

Straightening images using Photoshop

Something that I use Photoshop for quite often is to straighten up wonky images. Most pictures don’t really need straightening but sometimes they look silly or need to be straight to fit in with another part of a design. In this article I will show you show to straighten an image using Photoshop. It involves a bit of rotation and a bit of cropping but is quite simple and effective. Let’s get started. First you need to open your image in Photoshop. I always work on copies so if you are not working on a copy of the image, not is the time to save it as another filename. In

Finding a value in a range using Microsoft Excel functions

Finding a value in a range using Microsoft Excel functions

Following on from my other Microsoft Excel articles, this one is devoted to looking up information from within a range of values such as a table of data but using the functions that Excel provides. We will look at four functions used for finding operations within Excel; VLOOKUP, HLOOKUP, MATCH and INDEX. First we will have an explanation of each and then walk through some examples of their usage. Finally in this article I will explain how to look up a value in a table based on multiple criteria using SUMPRODUCT. Excel finding function descriptions INDEX(array of values, row number, column number) The INDEX function allows you to find a

Using cell reference names and named ranges in Microsoft Excel

Using cell reference names and named ranges in Microsoft Excel

Everyone who uses Excel and that has written a formula (you might think that must be everyone but there are some people who just use Excel for sorting rows of data) will have used the row and column reference at some point (i.e. A1 or R1C1) or a cell range (A1:C2 or R1C1:R3C2). Anyone that has gone back to their workbook after a long time to make modifications or anyone that has to modify or decipher someone else’s workbook will curse those row and column references. So what can you do about it? Using the naming feature within Excel you can make your life (and those of reviewers) a lot