SUSE Conversations


BrainStorm Cool Tip: Creating a Custom AutoFill Sorted List in OpenOffice.org Calc 2



By: coolguys

June 28, 2007 1:23 pm

Reads:214

Comments:0

Rating:0

brainstorminc_logo_sm.gifeut_sm.gifWelcome to BrainStorm Cool Tips. New tips will be posted regularly to help you more effectively use SUSE Linux Enterprise Desktop. If you have any suggestions for tips, please feel free to let us know by emailing
tips@brainstorminc.com.

Creating a Custom AutoFill Sorted List in OpenOffice.org Calc 2

Need to insert the same data over and over again in your spreadsheet? Does it need to be in a certain order? Calc’s autofill feature can help you add that data with just a drag. Here’s a tip to show you how.

  1. Create the list you want to repeat in cells in your spreadsheet. Make sure it’s in the order you want to repeat.
  2. Select the list you created.
  3. Select Tools | Options.
  4. Expand the OpenOffice.org Calc menu on the left and select Sort Lists.
  5. Click Copy to insert the selected sort list to the lists of already defined sort lists.
  6. Click OK.
  7. Type any item from your sort list anywhere in the spreadsheet.
  8. Grab the autofill handle and drag down or to the right to see the other items in your list in the order you specified.

To see a flash demonstration of this tip, click here.

You can get more OpenOffice.org 2.0 tips and tricks when you order BrainStorm’s new OpenOffice.org 2.0 Computer-Based Training. This Web- and Flash-based training system will work on any browser or platform and includes over six hours of instructor-led training topics. The Computer-Based Training is also completely searchable and includes pre-defined courses according to the level of training you need. For more information, contact BrainStorm, Inc.

VN:F [1.9.22_1171]
Rating: 0.0/5 (0 votes cast)

Categories: Uncategorized

Disclaimer: As with everything else at SUSE Conversations, this content is definitely not supported by SUSE (so don't even think of calling Support if you try something and it blows up).  It was contributed by a community member and is published "as is." It seems to have worked for at least one person, and might work for you. But please be sure to test, test, test before you do anything drastic with it.

Comment

RSS