When creating a long document with many different sections, it’s often necessary to create a table of contents to make navigation easy. Fortunately, Google Docs can generate a table for you almost entirely automatically.
To do this, you must first create section headers using the list under Format > Paragraph Styles. Simply highlight a section title and apply an appropriate heading style for it. Each style grows progressively smaller from 1 to 6. Major sections, such as chapters, should use the largest headings while smaller subsections should use progressively smaller headings.
Once you have created all of your headings, select where you want the table of contents to be in your document and choose Insert > Table of Contents. The table will automatically fill with links to each heading and arrange itself according to the heading styles chosen. Smaller headings will be indented beneath larger headings in the table, indicating that they are subsections.
How to use linked text boxes to flow text throughout a document automatically
If you’re familiar with using desktop publishing software you’ll know that it is useful to be able to create text boxes and have the text flow automatically from one to the next. You use this feature to start a story on one page of a newsletter, for example, and to have it continue on a later page.
Word 2007, 2010 and 2013 can do this for you too, if you use the built in text box feature. To do this, first choose Insert > Text Box > Draw Text Box and click and drag to draw a text box on the page.
Repeat this and add a second text box on another page in the document.
Now select the first text box, right click and choose Create Text Box Link.
Now click in the second text box to link the two together.
In future, any text which you type into or paste into the first text box and which won’t fit because the box is not large enough to accommodate it, will flow automatically into the second text box.
Learn how to crop and resize in bulk in Lightroom. If you have a lot of images you need to, for example, crop to 5 x 7 and then save at a particular pixel size and resolution, you can learn how to do this quickly and effectively in Lightroom. This makes use of the tools in the Quick Develop panel in the Library module.
Transcript:
Hello, I’m Helen Bradley. Welcome to this video tutorial. In this tutorial I’m going to show you how you can bulk crop and resize images and export them from Lightroom.
A reader recently posed a question to me and that was what do I do if I need to crop all my images to 5 by 7 in size and get them out as 500 by 700 pixel images. In Lightroom that’s not that difficult to do. What I suggest you do is you do it from the Library in Quick Develop mode. So I’m going to select the images here and then I’m going to select Crop Ratio and I’m going to choose 5 by 7. And that will crop all of these images to 5 by 7 images. But look what it’s done with the verticals. It’s cropped them to 5 by 7 but it’s kept that same vertical alignment.
So now let’s go to the Develop module and just see what we’re seeing here. This is the crop marquee. And you can see that this image, each one of these images in fact has been cropped to 5 by 7. And let’s go and find a vertical crop and see how it’s been cropped. Again, it’s been cropped to 5 by 7 but in a vertical direction. So this means that all of these images have automatically been cropped.
All we would do is have a quick look and make sure that important parts of the image have not been cropped off. If these were people we’d have a quick check to make sure that somebody’s head hasn’t been chopped off for example. And having done that now knowing that everything is cropped to 5 by 7, to export these images at 500 by 700 pixels in size or 700 by 500 we would select all of them by clicking on the first and Shift click on the last. I’m going to right click and choose Export and then Export again and we would just set up the Export option. So here I’m going to put this in a folder called 5 by 7.
I don’t want to rename these files. All we want to do is to resize them. But what I do want to do is I want to select Resize to Fit. And the longest edge since I know that these are all 5 by 7s is going to be 700 pixels and the resolution I can set to 100 pixels per inch. So these are then going to be 5 by 7 images at 100 pixels per inch resolution. And all I need to do is to click Export and Lightroom is going ahead and it is cropping and resizing all of those images so that they are all going to be the exact right size that we chose. And here they are including the ones that were verticals. You can see that these are 500 by 700 pixels in size. This one is 700 by 500 because it’s a landscape image.
So in Lightroom you could batch resize and export these images in just a matter of a few seconds by just choosing the right option. And that is here in the Quick Develop module setting a crop ratio for those images. This is not something you can do easily in the Develop module, but it’s something that you can do very, very simply here in the Quick Develop area of the Library in Lightroom.
My name is Helen Bradley. Thank you for joining me for this Lightroom video tutorial. If you liked the tutorial please comment, press the Like button, consider subscribing to my YouTube channel. You’ll also find more of my tutorials, tips and tricks on my website at projectwoman.com.
Do you find that you often make the same typos over and over again? You can increase your typing speed and accuracy with Google Docs and Word’s automatic substitution tool.
To start, if you are using Google Docs, go to Tools > Preferences and ensure that the box next to “Automatic Substitution” is checked. If you are using Microsoft Word, go to File > Options > Proofing > AutoCorrect Options > AutoCorrect tab and check “Replace text as you type”. The rest of the process is the same for both word processors.
This is the automatic substitution dialogue in Word
Now you simply insert any potential typos into the “Replace” table and place the corresponding corrections in the “With” table. For example, if you tend to type “wiht” instead of “with”, you can add “wiht” and “with” to a row on your substitution table. Every time you type “wiht” it will be automatically corrected to “with”.
You can also use this tool to quickly type long strings of text. If you find yourself writing out your email address repeatedly, you can create an automatic substitution for it. Create a short phrase such as “em#” or “email#” for the Replace field, and put your email address in the With field. It is important that your phrase include a special character, such as the number sign at the end, so that the substitution will only occur when you intend it to. If your phrase were simply “email” you would never be able to write the word itself without the substitution taking place!
Learn how to take an image from Lightroom to Photoshop and back again. This will ensure that the image appears back in Lightroom, automatically added to the catalog, with the original version backed up. I also demonstrate the different possible settings so that you may customize this process.
Transcript:
Hello, I’m Helen Bradley. Welcome to this video tutorial. In this tutorial I’m going to show you how you can take an image from Lightroom to Photoshop and back successfully. I’m here in the Develop module in Lightroom and I’ve already done some work on this particular image. And I’m pretty happy with it. The problem is in this animal’s eye though you can see that there’s a little shape here that I want to get rid of.
Now I could get rid of this in Lightroom but it’s going to be a whole lot easier to take this image into Photoshop. So we’re going to do that now. To take an image from Lightroom into Photoshop I’m going to let Lightroom control the process. I’ll right click and choose Edit in. Because Photoshop has already been installed and Lightroom is aware of that I’m going to click Edit in Adobe Photoshop CS6. If I was using a different version of Photoshop I would select that from the list. I’ll click here. And now what’s happening is that Lightroom is asking me what I want to edit, either a copy of this image with the Lightroom adjustments, just a copy of the original or the original itself. In this particular case I want to edit this image with the Lightroom adjustments. So I’m going to edit a copy with Lightroom adjustments and click Edit.
If Photoshop is not already open Photoshop will be opened now. But here’s our image inside Photoshop and I’m just going to size it so that we can see the area in question. And now I’m going to bring in the tools. I have here the spot healing brush tool which is going to be the tool that’s going to help me fix this problem. I think I need to zoom in a little bit closer still so let’s get right into this problem area. And now with the spot healing brush tool I can size it down to suit the problem area and just start working over it. I could also use the clone tool if I wanted to. Any of these tools are going to help me fix this issue. And working with this tool in Photoshop is going to be a whole lot easier than working with the similar tools in Lightroom because I can just be a whole lot more accurate in Photoshop. If I want to undo it I just press Ctrl Alt Z to undo the change.
So when I’m happy with the resulting eye I’m just going to zoom out, make sure it all looks fine, which it does for this particular eye. I’ll probably fix this one while I’m here, but let’s call this good for now. And because I’m ready to go back to Lightroom now I’ve fixed the problem, I’m just going to close this image. So I’m just going to click the X button to close it. I’ll get a message which will say do you want to save changes to the document and I’ll say yes. The important thing at this point is not to choose File, Save as because you want to send the image back to Lightroom in the format that Lightroom sent it to Photoshop.
Now we’re back in Lightroom. The image that we’re looking at is the one that has been the fixed eye. And you can see here it’s called lionanimaleyes edit.tif. What Photoshop has done in conjunction with Lightroom is it’s taken the image, applied the edits to it and then sent it back as a TIF file with -edit after it. This is the original file. We haven’t lost the original. We’ve just got a copy back with the edits applied to it. Now the settings that Lightroom uses when exporting to Photoshop and receiving the image back are in the preferences setting.
I’ll choose Edit and then Preferences. And we’ll go to External Editing. You can see here that edit in Photoshop CS6 is set up as a TIF file. If we wanted to we could bring it back as a PSD file but TIF was selected here. It’s being sent out as proPhoto RGB with a 16 bit depth, a resolution of 240. And here’s the file naming. It’s coming back with the same file name with -edit on it. You can see that we’re using custom settings. Here’s the edit and here are our custom settings, the original file name with –edit applied, and then either PSD or TIF depending on what it is that we have set here for the file format. So all of this is customizable and this is where it’s being controlled as to what it goes out to Photoshop as and what it comes back into Lightroom as. And provided you use that process of just choosing File, Close or File, Save from Photoshop and not Save As so you don’t give it a name, you let Photoshop and Lightroom deal with it, then you’re going to be able to work seamlessly between Lightroom and Photoshop and back again.
I’m Helen Bradley. Thank you for joining me for this video tutorial. If you enjoyed this tutorial place click Like. You can subscribe to my channel and hear more about videos that are launched regularly every week in future.
Learn how to create a Faux Orton Effect in Lightroom, which produces intriguing photos using glowy colors and contrasting details. I also demonstrate how to save the effect as a preset to reuse over and over again.
Transcript:
Hello, I’m Helen Bradley. Welcome to this video tutorial. In this tutorial I’m going to show you how to create the Orton effect or a faux Orton effect on an image in Lightroom.
I have an example of the Orton effect that we’re going to create here in Lightroom. This is the original image and this is the image with the Orton effect applied to it. What I’ve done is I’ve softened the image and then tried to boost the blacks a little bit. You can’t get a true Orton effect in Lightroom because you can’t apply layers in an image. So what I’m trying to do is to bring in some of the characteristics of an Orton effect, a slightly lighter more glowy sort of image with some sharp blacks in it and a sort of hazy look to it. So let’s see how we might do this.
With this image open in Lightroom, first of all I’m going to the Develop module and I’m going to upgrade this one because it’s been worked on in earlier version of Lightroom. So I’m just going to upgrade it to the new process version. And I’m happy with that so let’s just go back to the image that we’re working on. I’m going to make a virtual copy so we can see how far we’ve come. And we’re going to be working on this virtual copy.
Now the first thing I’m going to do is just adjust this image. I’m not so much worried about the histogram as I am about getting some things out of this image that I want to get out of it. But I’m going to turn off the highlight clipping because I’ve got that turned on here. You can see highlight clipping is showing here. So I want to hide this for now. Let’s turn off the histogram and let’s just adjust the image a little bit. I’m just going to set my black point. You can see I’ve got the Alt or Option key held and I’m just trying to darken this to get some blacks in the image. It needed quite a bit of darkness in the image. And let’s go up with the whites right now.
Okay, so once I’ve got the image adjusted reasonably well to get a little bit of contrast and I’m starting to see some blacks let’s start going for this Orton effect. And one of the things we’re going to do is to reduce clarity. So we’re going to bring the clarity right down on this image. I do want quite a bit of vibrance because I want a quite a bit of color. And now let’s go and add some more reduced clarity. I’m going to click the graduated filter. Now this allows me to apply a graduated filter to the image. And it needs to be anchored to a side of the image. So I want it anchored to the top so I’m just going to drag down here to create it. And because it has saturation set to minus one hundred what we’re seeing is that we’re seeing no saturation in this images at all. So that’s convincing us that this is the graduated filter. Of course I do want saturation in that image so I’m going to take it back to normal but I am going to reduce clarity. And that’s adding some more of that softening effect to this image. And I’ll click Done.
Now I can boost that even more by adding a second graduated filter to do exactly the same thing. So again, clicking on Graduated Filter, making sure I select New. This time I’m going to drag up. It doesn’t matter whether I go up or down but I just want two filters on this image. So I want to add the effect. So here’s the second filter. Again, the default on this one is for saturation to be minus one hundred. I just want to take that back to normal. And what I want to do is kill the clarity. And I can also kill the sharpness by taking that down a bit too. I might increase the exposure a little bit more in the way of highlights. And I can go to this one as well, click on this and again, bring down the sharpness on this layer, just tweak that a little bit and maybe add a little bit of exposure and highlights on that one, maybe even some shadows until I get the effect that I’m looking for. And I’ll click Done.
At this point I may want to come back and re-adjust my blacks on the whole of the image. You can see that the blacks have been affected by that adjustment and I don’t have nearly as much black as I had before. So let’s go in and adjust the blacks. Having done that I’ve brought way more black in I think than I want. So let’s just go and bring up the highlights a bit on the basic image underneath all those adjustments, and again, kick up the shadows a little bit.
So there’s the basic Orton effect applied to the image and having done that I could just go onto the next image. But I could also make this a preset that I can use in future. In the Develop module I can go up to presets here and I can click the plus symbol. So here we are New Orton because I think I have an old one, okay, and I’m going to select which options I want in there. I do want graduated filters. I didn’t use split toning. I did use color. I did use process version and calibration. I didn’t use any post-crop vignetting or grain. I didn’t use any lens correction or noise reduction here. I did use some color. I didn’t use any sharpening so I’m going to that out. I didn’t use any tone curve adjustment. But I did adjust clarity and I did adjust these settings. I didn’t adjust white balance. So now that I’ve made a selection of everything that I want added to this particular develop preset, I’m just going to click to create it.
Now this is a new Orton preset. And of course it’s been applied to this image by default. But let’s go and get another image shot in similar circumstances to this and let’s go and apply it to this image. And all I do is to click New Orton, and it is than applied to this image. The process version is applied and all of the settings that we included including the two graduated filters here and here. The reason why I used a graduated filter and not adjustment brush is that adjustment brush cannot be included in a develop preset whereas the graduated filter can. And now I’ve got a new Orton preset that I can use with any of my images. All I do is click on the image and then click on this new Orton preset and it’s automatically applied to the images.
Now if I don’t like it I can Ctrl Z to undo it. In the case of this image that I had already applied it to I kind of like it, but I think the saturation is too much. So I can use that as a starting point for working with this image. And I can then adjust the sliders because all you’re doing by creating a preset in Lightroom is actually recording what the sliders are set at. So you can use that as a starting point and then adjust the sliders as you like from there.
So there’s how to create a faux Orton preset in Lightroom to apply to your images. I’m Helen Bradley. Thank you for joining me for this video tutorial. If you liked the tutorial please like the video here on YouTube. Think about subscribing to my YouTube channel so that you get updates whenever we launch videos which at the moment is a couple of times a week.
When you need to enter data from a small subset of entries into a range in Excel 2007 you can do it more easily using a custom designed dropdown list.
To configure a dropdown list in a cell type the list of items to use in a single column in a spare sheet in the workbook.
Select these cells and choose the Formulas tab Define Name, type DataForList as the name in the dialog, set the scope to Workbook and click Ok.
Switch to the sheet where you want to add your dropdown list to some cells, select the cells that should display a list of data to choose from and choose Data tab > Data Validation > Settings tab.
From the Allow: dropdown list choose List and, in the Source area, type =DataForList and click Ok.
Now, whenever you click a cell in this range you’ll see a dropdown list appear from which you can choose a list entry for that cell.
If you’re using Excel 2003, here is a link to an earlier post explaining how to do this in Excel 2003:
