Keyboard Shortcuts in Microsoft Excel

Microsoft Excel

Here is a list of shortcut keys in Microsoft Excel.

1. F1: Opens a help task pane
2. F1 + Ctrl: Opens or closes the help window
3. F2: To edit the text in the active cell
4. F2 + Shift: To write a comment in the active cell
5. F2 + Alt: Opens the save as dialog box
6. F3 + Shift: opens the insert dialog box
7. F3 + Ctrl: Opens the define name dialog box
8. F3 + Shift + Ctrl:  Opens the create name dialog box
9. F4:  To redo the last command
10. F4 + Ctrl: To close the workbook window
11. F4 + Alt: To close the excel program
12. F5: Opens the Goto dialog box
13. F5 + Ctrl: brings back to the first level of workbook
14. F6: To shift between help taskbar and the excel window
15. F6 + Shift: To goto the previous square in the open worksheet
16. F6 + Ctrl: If more than one workbook is open to switch between them
17. F7: To open spelling correction window
18. F7 + Ctrl: When workbook window is not maximised it will move the window
19. F8: To activate / deactivate extended mode
20. F9: Will calculate all the worksheets in all open workbooks
21. F9 + Shift: Will calculate the active worksheet
22. F9 + Ctrl: To Minimise the workbook window
23. F10: Will select the menu bar
24. F10 + Ctrl: To open minimised window
25. F11: Will create a chart using the current range
26. F11 + Shift: To select a new worksheet
27. F11 + Alt: To switch between visual basic editor and the worksheet
28. F11 + Alt + Shift: Opens microsoft script editor
29. F12: Opens save as dialog box
30. F12 + Shift: Saves the active workbook
31. F12 + Ctrl: To open the Open dialog box
32. F12 + Ctrl + Shift: Opens the print dialog box.

Original Post here.

How to Disable Windows Vista and 7 Login at Startup?

When you start your Windows Vista or Windows 7 computer, by default the system makes you enter your password to log in. Here’s a way to get around it.

When you first install Vista or 7 and start using it, you are required to enter in a password for your account. But after that, you’re not really given a choice to remove the password if you don’t want it. You’re just sort of stuck typing it in every time and that can get old rather quickly!

If you’re not the only one who uses your computer, consider leaving it this way. It is a good security feature and it helps to keep all of the different accounts, files and preferences separate from each other. But if you’re the only one who ever uses your computer, you should be able to get rid of the password prompt if you want.

If you’d like to bypass the Windows Vista and 7 log on process and remove your password, just follow these steps:

1. Go to Start, Control Panel.
2. Click on the User Accounts and Family Safety link.
3. Next, click on the User Accounts link.
4. Under the “Make changes to your user account” section, click on the Remove Your Password link for your account.
5. On the next screen that comes up, enter in your current password.
6. Click on the Remove Password button to confirm everything.
7. Close out of all the open windows and restart your computer. That will allow you to test the system to make sure your password really was removed.

From now on, when you start up your Vista computer, you will be taken to your desktop automatically and you will no longer have to worry about a password.

Please click here to read the original post.