two simple questions line insert and gridlines default

[Pete]

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

 

[Bob Greenblatt]

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.

 

[CyberTaz]

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.