Pedro writes about a nice little trick in Calc that I wasn't even aware of:

In Calc, one often wants to enter data quickly on several lines. Hence, once you have entered the first line, you click on the beginning of the second line and so on for each line. As, using the mouse is too exhausting for power users, here is a trick for you :

- Select a range of cells
- Press the tabulation key

Each time you press the tabulation key, you will move to the next cell and once you are at the end of a line, the selection will go back at the beginning of the selection on the following line without clicking.

Just tried it and it works great!

See here for the original.

Merci beaucoup!

Comments:

and if you drag the selection box starting at the bottom right cell and up to the top left cell, you can just go ahead typing your data. Really cool.

Posted by ufi on May 18, 2006 at 01:31 PM CEST #

you are welcome ;-)

Posted by Pedro (Pierre-André) on May 19, 2006 at 12:40 PM CEST #

Post a Comment:
  • HTML Syntax: NOT allowed

This blog copyright 2009 by fpe