See to know the total number of rows and columns in a worksheet in Excel 2007

If you had gone through web sites or books for Excel 2007 then you will be informed that a worksheet in Excel 2007 has 1048576 rows and 16384 columns. If you decide to check this out and had started pressing the right arrow key till the end of the columns or if you press the CTRL + RIGHT arrow key, you will see XFD in the column header. When you press the CTRL + DOWN arrow, you will see that the last row number is 1048576. Now, you had verified the row number count but not for the column number. You can do the following to see the rows by columns count:
Click cell A1 and press the CTRL + SHIFT + DOWN arrow keys. Keeping the CTRL and SHIFT keys in pressed state, press the RIGHT arrow key. You will see the selected number of rows by columns number just above the row number 1.

Automatically moving the cell pointer after entering data in Excel 2007

After entering the data and pressing the Enter key, Excel activates the cell that is just below the data entered cell. In other words, when you press the Enter key then by default Excel moves the cell pointer to the next cell down. You can change this setting and make Excel to move to the cell that is to the right or left or top. Perform the following steps to automatically move the cell pointer after pressing the Enter key:
1. Open Microsoft Excel.
2. Click the Microsoft Office Button and click Excel Options.

Keyboard shortcut for Excel Options: Press Alt + F + I (Alt F I).

3. From the Excel Options dialog box, click Advanced from the left pane.
4. From the right pane, under Editing options, click the Direction: dropdown down that is just below the After pressing Enter, move selection checkbox.
5. Choose one of the following: Down, Right, Up, Left.
6. Click OK.

As mentioned in the very first sentence that after entering the data and pressing the Enter key, Excel activates the cell that is just below the data entered cell. If Excel does not move the cell direction to right or left or top or bottom then the After pressing Enter, move selection checkbox mentioned in step 4 is not checked. Click the After pressing Enter, move selection checkbox to place a tick mark besides it and click OK.