Re #1 - I've typically found that when someone expresses a "need" to do
this
it's because they are adding new records to a list and want to maintain
the
list in a particular order. That order is normally based on the content of
one of the fields (columns) in the list.
If that's the case here, have you considered just adding the new records
to
the bottom of the list, then Sorting the list based on the key field?
That's
what the A-Z & Z-A buttons are for. Using Data> Sort you can actually do a
multi-level sort on as many as three fields. You might also consider using
the Data> Form feature to facilitate adding records to the list. Just make
sure you have selected a cell in the list range before attempting to use
either feature.
--
HTH |:>)
Bob Jones
[MVP] Office:Mac
"Bob Greenblatt" <bob@[EMAIL PROTECTED]
> wrote in message
news:C47BCA91.AD6C2%bob@[EMAIL PROTECTED]
> On 6/15/08 6:34 PM, in article
> ba885115-5f49-4b9e-a1de-93c6d2381543@[EMAIL PROTECTED]
"Pete"
> <psg2103@[EMAIL PROTECTED]
> wrote:
>
>> hi two simple questions to avoid repetitive tasks.
>> 1 - is there a shortcut for adding lines or rows to a spread sheet?
>> right now i have to go to the toolbar or the palette and add one line
>> at a time or a group of lines at a time. is there a way to set things
>> up so that each time i add a new line of data, i can enter it onto a
>> new line of the spread sheet?
>> 2 - can i set something so that whenever i print a spread sheet, even
>> one that is sent to me, not created by me, it will automatically print
>> with gridlines? right now, print default is WITHOUT gridlines. I'd
>> like to make print default WITH gridlines. thanks - Peter
> 1 - you can customize the toolbar and add an insert icon, so insert is a
> single click.
> 2- unfortunately, you can not set this default. You could write an apple
> script to set the gridlines and then print.
>
> --
> Bob Greenblatt [MVP], Macintosh
> bobgreenblattATmsnDOTcom
>
|
