Negatives and switching image colours in Photoshop

Photoshop Replace Colour

I quite often forget how to switch between a negative and positive image or how to do an exact colour replacement when using Adobe Photoshop. Each time, I need to, which is not very often, I spend a bit of time working it out. As this has just happened to me, I thought I would make a note of the steps and make that into an article. I needed to switch colours in a 2-colour logo to from blue on a white background to white on a blue background. This would have been fine if the coloured image parts were on separate layers or if it was a vector graphic

Consolidating many Excel sheets into one master sheet

Excel Data Consolidation

A while back we had a situation where we had collected a set of information from various sources and wanted to get all of it into the same Excel Worksheet and I was asked if I could help. There were about 60 spreadsheets all with the same columns but with a variable number of rows and of course, different data. The requester had linked all 60-odd spreadsheets to a master Workbook and wanted to know how to get the information from each transferred to a single master sheet that he could share as a consolidated list. This process needed to be repeatable as the authors of the 60-odd different worksheets

Using Excel’s Paste Special Operations

Excel Paste Special

In this article, I broadly cover Microsoft Excel’s Paste Special functions with an example using the Operations of Paste Special. Before we get to an example some background is needed. Each cell in Microsoft Excel is made up of three parts; values (data), formula and format. Copying and pasting from one cell (or range of cells) to another copies all three exactly as they are. The formula remains the same (but relative to the new cell position), the values/data remains the same (unless it is formula driven) and the format remains unchanged (unless it is conditional on the data). The cell (or cell range) does not need to be copied

Convert or flip data between rows and columns in Excel

transpose rows to columns

One of the things that I have to do periodically and always forget how to do is converting rows of data to columns or columns of data to rows. This quite often occurs when I’m collecting data from different sources and want to put them all in the same format in Microsoft Excel. From the 2007 version of MS Excel (I think), there has been a neat feature to enable you to do this. The reason that I always forget how to convert from columns of data to rows and vice-versa is because I expect it to be on the ribbon as a commonly used function but it is not.

Applying conditions to AVERAGE, SUM and COUNT functions in Microsoft Excel

Excel File

This is my first article on Microsoft Excel in over two years and continues the series with descriptions and examples of applying conditions to the popular Excel SUM, COUNT and AVERAGE functions. I started writing this article about 6 months ago when one of my friends asked me how to count the number of occurrences in a spreadsheet where a condition in another column was true. I had thought that I had already written such an article and was about to point her to it but it wasn’t there. I remember it was on my list of articles to write about Excel but I’d obviously not written it yet. Anyway,

How to use and customise gradients in Adobe Illustrator

Illustrator Tip

Quite often getting gradients to do exactly what you want them to do can be a challenge. In this short article, I’ll cover gradients within Adobe Illustrator but the principles can be used in other Adobe products. First up, what is a gradient? It is the smooth transition from one colour to another colour or more colours. This is done mathematically by apply some of the target colour to the starting colour in the pixels between those colours. A gradient starting out as black and ending as white will go through many shades of grey depending on how many pixels there are between the start and end points. There are

Converting photographs to black and white or sepia using Photoshop

Photoshop Tip

I had to convert a photograph to black and white recently and I remember from many years ago having a problem trying to achieve this. It was a simple automated task in many other photo editing tools (including Photoshop Elements) but I couldn’t figure it out in the full version of Photoshop (I think it was CS2 but may have been earlier). I can’t remember when Camera Raw was introduced to Photoshop but that was where the functionality could be found (Convert to Grayscale option at the top of the HSL/Grayscale tab). It makes a good guess at a black and white conversion and you can use the sliders to

Teeth Whitening your photographs with Adobe Photoshop

Teeth Whitening

I have previously written about improving your photographs digitally by “removing red eye and blemishes with Adobe Photoshop“. There is another action that can make a smiling photograph look better and that is teeth whitening. Yellowish teeth are healthy teeth my dentist always said to me from a young age when I wondered why brushing them several times a day did not give me a dazzling bright white smile. Of course in reality most people will not have that toothpaste-ad sparkle but what I can’t do in real life I can make better with Photoshop. So, in this short article I will make the teeth in a photograph a bit

Red eye removal and photo healing using Photoshop

Photoshop Tip

In this short article I will show you how easy it is using Adobe Photoshop to manipulate a photograph that hasn’t quite come out how you expect. Quite often cameras come with red eye removal flash built in but sometimes the subject still comes out with a red pupils rather than a black ones. Photoshop can sort this out for you in seconds. Another thing that quite often happens is that the photograph’s subject has a blemish such as a spot on the skin or other blemish that you’d rather remove. Photoshop’s healing tools can fix them up as if the blemish never existed, something that’s harder to do in

Getting images to a specified dimension using Photoshop

Photoshop Tip

Quite often I have images that don’t quite fit what I want them for. Sometimes, it’s because they are too big and other times they require some cropping or resizing (or both) to obtain the size that I need. In this short article, I will show a couple of methods that I use in Photoshop to get the result I want. The main thing to remember when resizing is that you’ll probably need to resize to one dimension and crop the other. So, in this first example, I want a 960 pixel wide banner that is 360 pixels high to go at the top of a web page. To achieve