Sunday, June 2nd, 2013

Lightroom Tip – harness the power of the Target Collection

Learn how to create and use the Lightroom Target Collection feature

Lighroom’s target collection feature makes it easy for you to add images to a collection. If you make a collection the target collection you can add an image to that collection by simply pressing the letter B on the keyboard. But, be warned, once it is added if you press B again you will remove the image from the target collection.

To make a Collection the Target Collection: right click it and choose Set as Target Collection.

Any Collection (except a Smart Collection) can be designated as the Target Collection but there can only be one Target Collection at the one time.

If you deselect the current Target Collection: by right clicking its name and disabling Set as Target Collection, then the Quick Collection becomes the Target Collection, by default.

Helen Bradley

Monday, May 20th, 2013

Lightroom Tip – Create an Import Preset

Save Time when importing photos by Creating an Import Preset

If you use the same options every time you import your images into Lightroom, you can create an Import Preset to speed up this task.

Start by selecting Import to open the Import dialog and go ahead and select those options you generally want to use and then locate the Import Preset option at the foot of the Import dialog. Click the drop-down list and choose Save Current Settings as New Preset. Type a name for the preset and save it.

In future you can select this preset when you are importing images. This gives you, at the very least, a starting point for your import as it sets up the import dialog to match the settings you saved. If you wish, you can make changes to the settings without altering the preset, allowing you to use it anytime.

You can create multiple import presets for different situations so you can select the most appropriate one to use each time you import photos.

Helen Bradley

Wednesday, June 27th, 2012

Excel fill intermittently empty cells

Often when you’re working in Excel you won’t enter all the data because it is repetitive.

In this example, the cells in column B really should be filled with the months but because the month only changes periodically I have only typed it when the change occurs. If I need to work with this data such as in a PivotTable it may be necessary to fill the data down column B.

This can be done easily by selecting the cells in column B and choose the Home tab  on the Ribbon, click Find & Select > Go To Special > Blanks to select the blank cells.

Type =B2 in the cell, this represents the first cell in column B with the data in it.

Press Control + Enter.

Now, to fix the cells so they contain words and not cell references, select all the filled cells in column B, choose Edit > Copy and then Paste > Values and click Ok.

 

 

Helen Bradley