On 9/9/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > On Sunday 09 September 2007 01:58:03 Diabolic Preacher wrote:
> This could be done in OOo by setting up a short cut key that fires > Enter and Home. The cursor would move down and back to the 1st > column. what if your table doesn't start at column A? excel does detect the first heading cell. if you have worked with the solver tool in ms excel which needs you to prepare 2 tables like in transportation model linear programming problems, students are bound to randomly build a table anywhere on the sheet. yet the shift back to first column of the table and not the entire sheet is possible in ms excel. i was trying to find abnormalities in the excel behavior. ways to make it fail. searching for the observations it made. my observations: - 1. the cursor detects the left most occupied cell in the rows above the current row. if your header row is c4 to g4. the cursor will keep coming back to c column after entering data under g column. if at say c7 you press shift+tab and move to the b column (b7). and enter data till g7 (or even further), pressing enter at this point takes you to b column and not to c column anymore. think of cases where you might want to add some text (as a table label) in a cell on the left of where you made a table to just mark what that table is for. the special feature of excel doesn't work as intended. it keeps goin back to the left most cell. 2. After entering few rows. press enter (in c column) a few times to move down say 5-6 rows and try entering a row of data n pressing enter. it still goes back to b column. 3. now using your mouse, click on a cell 10 rows further below in say e column and test the feature. make a 4 table column n as you press enter, it moves back to the next row but in e column. not in c or b column. its not just a simple enter and home key combo. it'll be good if more and more people could test for abnormalities or 'catches' in this feature. -- Diabolic Preacher As Is Blog: http://pintooo15.livejournal.com/ Bookmarks: http://simpy.com/user/dpreacher -----BEGIN GEEK CODE BLOCK----- Version: 3.1 GCS/IT d+(-) s+:+ a22 C++@ UL@ P L+(++) E- W++ !N o? K>++ w(-) !O M-(--) !V PS+ PE++ Y+ PGP t- 5? X>+ R- tv@ b-(+) DI+ D+ G++ e++ h-- !r y- ------END GEEK CODE BLOCK------ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
