Blog under construction. Visit back soon...

Thursday, February 3, 2011

Automatically move the cell pointer after entering data in Excel 2007

After entering data in a cell or in a blank active cell, once you press the Enter key then by default, the cell that is below the data entered or blank active cell now becomes the active cell (Active cell has a black border). You can also change this setting and make the active cell to move to the right or left or top. Perform the following steps to move the cell pointer to one of the directions that you prefer:
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.

How to remove Label Count in blogger?

By default the Labels gadget displays the number of posts associated with a particular label. If you do not want the number to be displayed so as to have a professional look plus the visitors should not be aware of the label(s) that has fewer number of posts due to the reason that it grabs less attention.
You can make the visitors curious by not letting them know how many posts are present in a particular label and making them go through all or most of the posts that are available in that label. You can remove the label count by deleting a single line of code. Perform the following steps to do so:
1. Login to blogger.
2. In the blogger Dashboard page, click the Design link for the blog to which you need to remove the label count.
3. Click Edit HTML.
4. Click to place a checkmark besides Expand Widget Templates.
5. Find this piece of code:
<span dir='ltr'>(<data:label.count/>)</span>
Tip: Copy the exact line of code and paste in the Find part of the browser so that you do not have to scroll the code to find the above line of code.
6. Remove the code and click SAVE TEMPLATE.