Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member

Selectively applying a cell style

From: InDesign CS3 One-on-One: Style Sheets

Video: Selectively applying a cell style

In this final exercise of the chapter, we are going to highlight the best songs on this 2-CD collection what I consider to be the best songs, by applying the Best songs Cell Style that we created in the previous exercise. Now, if you're just joining me, I don't know why you would join me at this point in time, but if you are, I like to keep it convenient. I have got this catch up document called Highlights to highlight.indd, found inside the 06 Table Styles folder, so called, because we are about to highlight the highlights and the highlights are ready to highlight.

Selectively applying a cell style

In this final exercise of the chapter, we are going to highlight the best songs on this 2-CD collection what I consider to be the best songs, by applying the Best songs Cell Style that we created in the previous exercise. Now, if you're just joining me, I don't know why you would join me at this point in time, but if you are, I like to keep it convenient. I have got this catch up document called Highlights to highlight.indd, found inside the 06 Table Styles folder, so called, because we are about to highlight the highlights and the highlights are ready to highlight.

That's really the reason. Alright, so let's go ahead and grab the Type tool. I'm going to caution you upfront. You are going to have to slavishly, if you're going to work along with me, you're going to have to slavishly follow my instructions and highlight exactly the same songs I do, if you want things to match up in the end; otherwise things are going to go haywire. So just go your own way at your own peril, is basically the idea. I want you to go ahead and select from Lola to Sugababes right there. Sugababes, an incredibly popular girl group in England that nobody has ever heard of over here. But anyway, go ahead and grab that group of six cells as you can see right there, so, three deep and two wide, and I want you to go ahead and click on Best songs, here inside the Cell Styles palette to apply it.

Then press Ctrl+Shift+A, or Command+Shift+A on the Mac and you can see what we've got. I'm going to go ahead and zoom in here and scroll the table up a little bit and you can see that we've got some dark red text that is framed by some bright red strokes, and that's all being conveyed by the Cell Style. What isn't being conveyed, is the milky-white interiors that we need to apply. We do need some sort of fill to set these things up. As I said, I wanted to be translucent and you can only create translucency in a table by manually creating a few rectangles as we're going to do in just a moment, but you can't do with Cell Styles.

So anyway, I'm going to go ahead and move down just a little bit here. We also want to grab these songs right there. I'm going to drag from The Raconteurs to Can't Stand Losing You, which is this great Police cover, by the way. Let's try applying the Cell Styles using the keyboard shortcut, so I'll press Ctrl+1; that would be Command+1 on the keypad of course on the Mac. Now I'll Ctrl+Shift+A or Command+Shift+A, in order to deselect that text. Next, let's go down here to Careless Whisper through The Pigeon Detectives and let's go ahead and apply the Cell Style, in this case using the Quick Apply function, so I'll go ahead and hide the Cell Styles palette and I'll press Ctrl+Enter, that would be Command+Return on the Mac and initially you're going to look at this potentially, and then you're going to go, "Hey! I can't find anything. It's just Last Page Number, in my case and no styles are showing up whatsoever." We'll go ahead and back step away any text that you've entered into this Quick Apply field right there and then notice at the very first item at the top right there, it's called Best songs but just to make sure that it's selected, go ahead and press B, for Best songs and then press the Enter key or the Return key on the Mac in order to apply that style.

I'm going to press the Enter key on the keypad or the Escape key if you did not load Deke keys and let's scroll down a little bit to this track three right here in disc two. I'm going to press the T key to get the Type tool and drag across Lullaby and the Editors. If you're familiar with Lullaby by the Cure then you know what it's just a wonderfully happy song about getting eaten by a spider. Then I'm going to press Ctrl+Enter+Enter; that would be Command+Return+Return. So you can see how just fantastically easy Quick Apply is, for applying the same style over and over again. I'm going to select those two guys right there, that is these two songs and both the name of the song and the artist of course.

Then I'll press Ctrl+Enter+Enter, Command+Return+Return on the Mac and I'm going to Alt+Spacebar, drag the page up, that would Option+Spacebar, dragging the page on the Mac. I'm going to select Drinking in LA, very interesting song by the way, and then I'm going to go ahead and apply the style to it. Of course, Drinking in LA is an anti-drinking song that became a huge hit in England, like number three or something like that, because of it's inclusion in a beer commercial. Who would have thought such things possible? Alright, then I'm going to select Teenage Dirtbag through Maximo Park, Ctrl+Enter+Enter, Command+Return+Return on the Mac and then Toxic through The Enemy, Ctrl+Enter+Enter, Command+Return+Return on the Mac. The beautiful, wonderful thing about this is, this version of Toxic, Britney Spears meets the Clash, how's that for an unlikely meeting? Almost as unlikely as Yusuf Islam, who of course is Cat Stevens, meeting Chaka Khan, in this version of Father and Son; so some interesting stuff on this album.

Anyway, Ctrl+Shift+A, Command+Shift+A on the Mac, in order to deselect everything on a page, and now, let's go ahead and fill the cells with that translucent what I was telling you about. I've done that in advance for you, go ahead and bring up the Layers Palette, which you can do by pressing F7 if you like, and there is that Highlights layer right there. I want you to show it, by clicking in its eyeball column, and if you did everything slavishly the way that I did it, the way that I told you to do it anyway, then your cells will exactly line up with their backgrounds there, with their milky-white backgrounds. And what I did was I basically drew these backgrounds in as rectangles, but I also spent some time making sure that they were the right width, because I know the column width, for example, is exactly 13 picas and I know the cell height is exactly 1 pica, 4.7 point, so I was able to just click with the Rectangle Tool and enter that information into the Rectangle Options dialog box here.

So I would just enter, 13p0 for the Width and the Height would be 1p4.7 and then you get a rectangle with right size and then you put it where it needs to be. You go ahead and drag it in the position of course, and then you go ahead and fill it with white, lower the opacity value, so you have some translucency built-in and you're good to go. Anyway, that's what's happening inside of this table. This is a completed version of this table, probably, a more complicated intricate table than anything you're going to run into. But it is worth noting, that first things first, you've got to set up your Color Swatches and establish your Paragraph Styles, then you set up your Cell Styles, then you put the Cell Styles into a big Table Style and then of course you bear in mind that Table Styles cannot affect row height or column width.

If you do all that, you're going to be in great shape where mass table production is concerned.

Show transcript

This video is part of

Image for InDesign CS3 One-on-One: Style Sheets
InDesign CS3 One-on-One: Style Sheets

89 video lessons · 10836 viewers

Deke McClelland
Author

 
Expand all | Collapse all
  1. 49m 7s
    1. How style automation works and why every file needs it
      2m 26s
    2. Installing the DekeKeys shortcuts
      3m 58s
    3. Meet the Eyedropper tool
      5m 43s
    4. Using the "loaded" Eyedropper
      2m 23s
    5. Loading new attributes
      1m 33s
    6. Lifting some attributes (and not others)
      4m 19s
    7. Eyedropper FYIs
      4m 51s
    8. The five kinds of style sheets
      3m 16s
    9. Meet the paragraph style
      2m 46s
    10. Applying the Find/Change command
      3m 41s
    11. The style sheet domino effect
      4m 10s
    12. Meet the object style
      4m 19s
    13. Appending a paragraph style to an object style
      2m 5s
    14. The power of the local override
      3m 37s
  2. 30m 5s
    1. The most common and useful style sheet
      40s
    2. Creating a paragraph style
      3m 57s
    3. The Paragraph Style Options dialog box
      3m 56s
    4. Assigning a keypad shortcut
      3m 9s
    5. The better way to create a style
      1m 30s
    6. Basing one style on another
      3m 16s
    7. Assigning a Next Style setting
      2m 31s
    8. Creating a closed style loop
      1m 40s
    9. Using the Quick Apply function
      3m 30s
    10. Formatting an entire story in one click
      2m 43s
    11. Auto-formatting as you type
      3m 13s
  3. 20m 44s
    1. Style sheets are dynamic
      39s
    2. Changing the font for multiple style sheets
      4m 29s
    3. Updating a shared attribute
      2m 24s
    4. Type style, skew, and tracking
      4m 12s
    5. Clearing and integrating local overrides
      3m 6s
    6. Removing widows with Balance Ragged Lines
      2m 47s
    7. Additional tricks for clearing overrides
      3m 7s
  4. 35m 13s
    1. Styling words, numbers, and symbols
      1m 16s
    2. Organizing style sheets
      6m 14s
    3. Character styles protect overrides
      5m 21s
    4. Creating a character style
      3m 44s
    5. Prioritizing style sheet shortcuts
      5m 24s
    6. Applying your new character style
      2m 51s
    7. Updating two styles in one pass
      4m 24s
    8. When in doubt, be obsessive
      5m 59s
  5. 1h 17m
    1. Character styles on steroids
      1m 15s
    2. Repeating style elements
      4m 0s
    3. Establishing a nested style
      3m 32s
    4. Setting the range of a nested style
      4m 3s
    5. Troubleshooting the nested range
      6m 49s
    6. Assigning automatic numbers
      2m 13s
    7. Assigning automatic bullets
      4m 49s
    8. Starting and restarting numbered sequences
      4m 16s
    9. Nesting a number or bullet style
      4m 45s
    10. Setting precise guidelines
      6m 24s
    11. Right-aligning numbers
      7m 31s
    12. Center-aligning bullets
      4m 10s
    13. Auto-numbering figures
      3m 0s
    14. Creating a custom Number setting
      4m 18s
    15. Specifying a chapter number
      3m 9s
    16. Numbering across threaded frames
      4m 5s
    17. Using a "list" to number across stories
      4m 29s
    18. What you can and can't do
      4m 37s
  6. 53m 18s
    1. If you make tables, listen up
      1m 1s
    2. A tale of two tables: Introducing the document
      2m 15s
    3. Creating a cell style
      5m 8s
    4. Adjusting the Inset values
      3m 37s
    5. Formatting the body of a table
      4m 22s
    6. Creating and applying column styles
      5m 32s
    7. Creating an all-inclusive table style
      4m 42s
    8. Converting and styling a table
      4m 49s
    9. Fixing formatting errors
      4m 21s
    10. Fixing row height and column width
      5m 25s
    11. An argument for independent cell styles
      2m 33s
    12. Making a dependent cell style
      3m 26s
    13. Selectively applying a cell style
      6m 7s
  7. 1h 10m
    1. The convergence of very nearly everything
      1m 18s
    2. Updating a style from the Find Font command
      4m 24s
    3. Step, Repeat, and Distribute
      4m 57s
    4. Adding text; removing style
      3m 3s
    5. Object-level formatting attributes
      3m 48s
    6. Creating an object style
      3m 43s
    7. Creating paired paragraph styles
      6m 28s
    8. Nesting paired paragraph styles
      3m 9s
    9. Inline and above line graphics
      5m 19s
    10. Creating an anchored object
      6m 29s
    11. Viewing frames and threads
      3m 52s
    12. Creating an anchored object style
      3m 48s
    13. Establishing anchored object defaults
      3m 44s
    14. Problems? Fit the frame to the contents
      4m 35s
    15. Employing a highly selective object style
      5m 27s
    16. The best way to anchor objects
      2m 23s
    17. Moving and anchoring text and objects
      4m 4s
  8. 1m 7s
    1. Goodbye
      1m 7s

Start learning today

Get unlimited access to all courses for just $25/month.

Become a member
Sometimes @lynda teaches me how to use a program and sometimes Lynda.com changes my life forever. @JosefShutter
@lynda lynda.com is an absolute life saver when it comes to learning todays software. Definitely recommend it! #higherlearning @Michael_Caraway
@lynda The best thing online! Your database of courses is great! To the mark and very helpful. Thanks! @ru22more
Got to create something yesterday I never thought I could do. #thanks @lynda @Ngventurella
I really do love @lynda as a learning platform. Never stop learning and developing, it’s probably our greatest gift as a species! @soundslikedavid
@lynda just subscribed to lynda.com all I can say its brilliant join now trust me @ButchSamurai
@lynda is an awesome resource. The membership is priceless if you take advantage of it. @diabetic_techie
One of the best decision I made this year. Buy a 1yr subscription to @lynda @cybercaptive
guys lynda.com (@lynda) is the best. So far I’ve learned Java, principles of OO programming, and now learning about MS project @lucasmitchell
Signed back up to @lynda dot com. I’ve missed it!! Proper geeking out right now! #timetolearn #geek @JayGodbold
Share a link to this course

What are exercise files?

Exercise files are the same files the author uses in the course. Save time by downloading the author's files instead of setting up your own files, and learn by following along with the instructor.

Can I take this course without the exercise files?

Yes! If you decide you would like the exercise files later, you can upgrade to a premium account any time.

Become a member Download sample files See plans and pricing

Please wait... please wait ...
Upgrade to get access to exercise files.

Exercise files video

How to use exercise files.

Learn by watching, listening, and doing, Exercise files are the same files the author uses in the course, so you can download them and follow along Premium memberships include access to all exercise files in the library.


Exercise files

Exercise files video

How to use exercise files.

For additional information on downloading and using exercise files, watch our instructional video or read the instructions in the FAQ.

This course includes free exercise files, so you can practice while you watch the course. To access all the exercise files in our library, become a Premium Member.

Are you sure you want to mark all the videos in this course as unwatched?

This will not affect your course history, your reports, or your certificates of completion for this course.


Mark all as unwatched Cancel

Congratulations

You have completed InDesign CS3 One-on-One: Style Sheets.

Return to your organization's learning portal to continue training, or close this page.


OK
Become a member to add this course to a playlist

Join today and get unlimited access to the entire library of video courses—and create as many playlists as you like.

Get started

Already a member?

Become a member to like this course.

Join today and get unlimited access to the entire library of video courses.

Get started

Already a member?

Exercise files

Learn by watching, listening, and doing! Exercise files are the same files the author uses in the course, so you can download them and follow along. Exercise files are available with all Premium memberships. Learn more

Get started

Already a Premium member?

Exercise files video

How to use exercise files.

Ask a question

Thanks for contacting us.
You’ll hear from our Customer Service team within 24 hours.

Please enter the text shown below:

The classic layout automatically defaults to the latest Flash Player.

To choose a different player, hold the cursor over your name at the top right of any lynda.com page and choose Site preferencesfrom the dropdown menu.

Continue to classic layout Stay on new layout
Exercise files

Access exercise files from a button right under the course name.

Mark videos as unwatched

Remove icons showing you already watched videos if you want to start over.

Control your viewing experience

Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.

Interactive transcripts

Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.

Are you sure you want to delete this note?

No

Your file was successfully uploaded.

Thanks for signing up.

We’ll send you a confirmation email shortly.


Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

Keep up with news, tips, and latest courses with emails from lynda.com.

Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

   
submit Lightbox submit clicked
Terms and conditions of use

We've updated our terms and conditions (now called terms of service).Go
Review and accept our updated terms of service.