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

Friday, January 27th, 2012

Smarter Content Aware Fill

If you’re like me, you’ve tried out the new Content Aware Fill feature in Photoshop CS5 and you’ve been left just a little bit disappointed.

What Content Aware Fill does is to replace unwanted areas of an image in a smart way. It can reduce the amount of time you spend working with the Clone Stamp and other fixing tools when you have something you need to get rid of in an image. However, where the Content Aware Fill feature appears to fail is when you want to remove a large portion of an image – those very times you wish it would work perfectly.

Well, last week I learned a cool technique to use with Content Aware Fill that solves these problems, thanks to Adobe’s Bryan Hughes. So here’s a way to make Content Aware Fill behave a whole lot smarter.

In this balloon image, if I want to remove the trees at the bottom of the image, I would make a selection around them with, for example, the Lasso tool.

Then, in Photoshop CS5 – even though the bottom layer of the image is a Background layer I would press Delete to open the Fill dialog. Here I can choose Use: Content Aware Fill and press Enter to have Photoshop remove the trees for me.

The problem is, that as often as not, part of one or more balloons will appear in the filled area. What I want is blue sky and not balloons. I could repeat the “Select and Delete” process until the image looks as I want it to but there is an alternative way to use the Content Aware fill feature. This way of working is great when you are trying to remove a large object and where there is not a lot of clean image data for Photoshop to use to do the fill with.

This solution involves removing any part of the image I don’t want the content aware fill feature to use – here that is the balloons – temporarily leaving only the content I want it to use – here that is blue sky. To do this I converted the background layer to a regular layer by double clicking it and pressing Enter.

Then I added a layer mask using Layer > Layer Mask > Reveal All and painted on the mask in black to remove the balloons – a hard edge brush is a good choice here.

Now I’ve reselected the image – not the mask – and made a selection around the trees again using the Lasso tool. Pressing Delete this time won’t work – it just deletes the selection so, instead, I need to press Shift + F5 or choose Edit > Fill to open the Fill dialog. Make sure that Use: is set to Content Aware and click Ok.

This time Photoshop uses only the visible content to fill the area and because the balloons aren’t visible they aren’t used to fill the area when the trees are removed.

Once you are done, you can bring back the balloons by dragging and dropping the layer mask into the trashcan – select Delete when prompted so you remove the mask – don’t apply it.

Now the content aware fill tool works as you would expect it to – allowing you to remove large portions of an image and have the area filled in an intelligent way.

Helen Bradley

Wednesday, April 20th, 2011

Photoshop – How to fill a shape with a gradient

Tricky this one. There are three ways to create a shape in Photoshop and I’ve been working with shape layers so I can warp the result. So far so good. You select the Custom shape tool and then from the tool options you select the Shape Layer option and create your shape. You get a Fill layer with a vector mask showing the shape.

To change the color – double click the Fill layer thumbnail and choose another color. Again – so far so good.

To fill the shape with a gradient – yikes.. there is no obvious option. Here’s a hint – Layer styles! Click the shape layer so you have it selected, choose Layer > Layer Style > Gradient Overlay. Select the gradient to use or make your own custom gradient and click Ok.

Now you know…

Helen Bradley

Page 2 of 212