OpenOffice.org Calc Tip : typing data
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
- Click on 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.
Labels: Calc, OpenOffice.org, Tips, tricks
2 Comments:
From
http://www.translate.org.za/blogs/david/archives/2006/05/23/T20_00_53/index.html
there are:
The only problem - I can't see how to get it to work nicely with the AutoComplete that happens when you start typing the same text as an entry above. Pressing Enter or arrow key all lose the selection, and pressing Tab gives a beep. Any ideas?
I test this problem, and you can input AutoComplete text, then you press delete key to delete what you do not want, and tab can go to next. You can test(to David Fraser).
By opentiss, at 5:22 AM
# Tools -> Cell Contents -> AutoInput
From
http://nowacki.org/blog/2004/05/disable_autocomplete_in_openoffice.html
By Unknown, at 5:58 AM
Post a Comment
<< Home