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. 

How to speed up your LAN in Windows?

How to speed up your LAN in Windows?

(Speed Up Your LAN)

Hi, everyone! How are you? Hope all is well by the grace of Almighty. I hope all of you are enjoying all the PC Tips & Tricks provided by us. Today, I am describing a little pc tips to speed up your LAN.

1)      At first open your “Control Manager”.

2)      Click on “Device Manager”.

3)      Now, click on “Continue”.

4)      Go to “Network Adaptor” from Device Manager and double click on it.

5)      There will open a new window and click on the tab named “Advance”.

6)      Now Identify “Speed and Douplexe” and select value 100 MBPS from the right corner.

7)      Finally click on “OK”.

Now, your LAN speed has increased. This is very small pc tips. If you like my post, please don’t forget to leave your feedback. Thanks for being with the “Universeof PC Tips & Tricks”. Thanks to all. 

How to disable your USB device?

How to disable your USB device?

The best way to enter viruses in PC is USB devices like pen drive, card reader or others removable devices. If you and many others are using your PC then it will be very easy to enter. But, if you are using Windows XP/7/Vista, then here I can give you a PC tips to keep your PC viruses free. You can disable your USB devices. Again you can activate also them. That means, only you can use USB devices in your PC. No other can.

To disable your removable devices in windows XP/7/vista, Go to “Start” menu and then click “Search”. Type there “Regedit” and press “Enter”. If you are a XP user, go to “Run” and type there “Regedit”. A new window named “Registry Editor” will open.

Go to “HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\services\USBSTOR”. Click on the file named “Start” and edit the value. Give there the value 4. Then, no removable device will work in your PC.

To enable your USB device, please go there and type 3 in the values box. This is the magic. From now, no other can use your USB device. If you enjoyed my PC tips, please don’t forget to leave your valuable comments.

Easily Boot Your Computer from Pen drive/How to make your Pen Drive Bootable

Easily Boot Your Computer from Pen drive/How to make your Pen Drive Bootable

Hi, everybody, take my love at first. With a lot of happiness, today I am starting my new twit. Many of us can not set up windows in our desktops or laptop notebooks due to the reason of unworkable CD/DVD Rom or unavailability of CD/DVD Rom. For that reason, we have to loss our time to set up windows. Many times, we have to do this work by joining an external CD/DVD Rom. But, it is very rare opportunity to find out an external CD/DVD Rom. As this reason, we have to depend on pen drive. But, we don’t know the correct policy to set up windows from pen drive. So, please today learn this PC tips. I am telling you here how to boot your PC or Laptopfrom a pen drive easily or how to make your pen drive bootable?

Needed components:

1)      Personal Computer

2)      A bootable CD/DVD disk of windows 7/windows XP

3)      Minimum 4 GB pen drive (1 piece)

 Now complete the steps below carefully:

1)      At first format your pen drive

2)      Download the useful software from Here.

3)      Now, open the “.zip” folder. Then double click on the file named “wintoflash.exe”. Run the software and select “Advance mode”.

4)      To set up “windows XP” select “Transfer Windows XP/2003 setup to USB drive” from task option and click on “Run”.

5)      To set up “windows 7/Vista or the later version of windows select “Transfer Windows Vista/2008/7/8 Setup to USB drive” from task option and click on “Run”.

6)      Show your CD/DVD drive in place of “Windows Source path”. [e.g. H:]

7)      In the place of USB dive show your pen drive’s drive letter. [e.g. I:]

8)      Select “I accepted the terms of the license agreement” and press “continue”

9)      There will open a warning window. Click on “OK”. When it finishes file transfer, then press “OK”.

Now, your task is finished. Your Pen drive is now a cousin of your windows bootable disk. Now, set up windows to your PC or notebooks. If you have learned a new PC tips from here, please don’t forget to leave your valuable comments. Your comments will help us to make our PC Tips website better in the near future. Bye for today. 

Change the “log on” Screen of Windows 7

Change the “log on” Screen of Windows 7

We are doing many things everyday to make our computer gorgeous and different from others. We are applying new themes, icons or wallpapers and many more. Today here I am describing a PC tips to make your computer different, exclusive and beautiful than others.

Can you change the “Log on” screen of windows 7? If you can do this, your Pc will wear a great look. But, if your answer is no, please come with me to learn this great PC tips to make your computer more gorgeous. I am giving you software to change your windows 7 “log on” screen.  

Steps to do:

1. Click on the “link”. After 5 seconds press “skip”. Wait for 3 seconds and your download will start automatically.
2. After download install the software and open it.
3. Click on “Change log on screen”.
4. Select a .JPG format file.
5. Now, your log on screen is changed and enjoy.

Here, I am also giving you some exclusive log on screen wallpapers.

To download the software please click here.

To download the exclusive wallpapers please click here.

Hide your “Turn off Computer” & “Log Off” Menu

Hide your “Turn off” & “Log Off” Menu

Hey, Assalamualaikum. How are you? Hope all is well. Today, here I have come with a new PC tips to maintain your computer. Here, I will tell you the process to hide your “Turn offcomputer” and “Log off” button. But How? To hide “Turn off” & “Log off” menu, please follow the steps below:

1)      To hide “log off” menu: At first go to “Start” option and then select “Run”. There type “gpedit.msc” and press “Enter”.

There will open a new window named “Group Policy”. Now, go to “User Configuaration → Administrative Templates → Start Menu and Taskbar”.

Now, double click on “Remove Log off on the Start Menu” from the right side. There will open a new window named “Remove Log off on the Start Menu”.

From there, select enable. Then press “Apply” and then “OK”. Now, see, your “Log off” menu is no more in your computer.

2)      To hide “Turn off” menu: At first go to “Start” option and then select “Run”. There type “gpedit.msc” and press “Enter”.

There will open a new window named “Group Policy”. Now, go to “User Configuaration → Administrative Templates → Start Menu and Taskbar”.

Now, double click on “Remove the Prevent Access to Shutdown commend” from the right side. Slect “enable” and then “Apply”.

Now, your “Turn off” menu is also no more.

To regain your system, please follow the steps I described above and select “disable” in change of “enable”.

If you like my PC tips, please don’t forget to leave your valuable comments. Thanks a lot for being with the “Universe of PC Tips & Tricks”.