Prevent Your Sheet from Scrolling

A while ago, we showed you how to copy data from one sheet to another. You simply hold down the Alt key while you drag the cell or cells to the appropriate sheet tab at the bottom of your screen. Excel automatically jumps to that sheet and continues to drag the data to its new home in the target sheet.

You can also use the Alt key while dragging data to prevent the sheet from scrolling. If you’ve ever had to drag data right to the edge of the worksheet, you already know that Excel can overreact and send you scrolling into oblivion. Holding down the Alt key allows you to move a block of data right to the edge without all that trouble.

Command Prompt Tip

In a command window you can use the TAB key as “complete” key – like in unix/linux.

Example:
Start a cmd window and go to root (c:\)
type cd – hit TAB key – and you will now scroll the directories, also hidden ones.

Try: cd doc – hit TAB key – You get up “Documents and Settings” – hit enter. in Documents and Settings type cd and hit key several time – and you will scroll through the names of the directories – also the hidden ones.

Setting Capslock, Numlock, Scroll Lock

If you want to set the startup state for any or all of these keys,
you just need to edit the registry.
Start Regedit
Go to HKEY_CURRENT_USER \ Control Panel \ Keyboard
Open InitialKeyboardIndicators
Change the value to one of the following numbers
0 – All Keys off
1 – Caps Lock on
2 – Num Lock on
4 – Scroll Lock on
For multiple keys, add their values:
3 – Caps Lock and Num Lock on
5 – Caps Lock and Scroll Lock on
6 – Num Lock and Scroll Lock on
7 – Caps Lock, Num Lock, and Scroll Lock on
Log off and back on again

Hiding the Last User Logged On

If you use the standard NT style of login and want to hide the last user:
Start the Group Policy Editor (gpedit.msc)
Go to Computer Configuration / Windows Settings / Security Settings / Local Policies / Security Options
Scroll down to Interactive logon: Do not display last user name
Set it to Enable