13 Killer Excel 2007 Shortcuts

1. Apply the outline border to the selected cells. [ Ctrl-Shift-& ]

2. Apply the Date format with the day, month, and year.[ Ctrl-Shift-# ]

4. Enter the current time. [ Ctrl-Shift-: ]

5. Enter the current date. [ Ctrl-; ]

6. Hide the selected rows. [ Ctrl-9 ]

7. Hide the selected columns. [ Ctrl-0 ]

8. Alternate between displaying cell values and displaying formulas in the worksheet. [ Ctrl-` ]

9. Display the Find and Replace dialog box, with the Replace tab selected. [ Ctrl-H ]

10. Display the Insert Hyperlink dialog box for new hyperlink. [ Ctrl-K ]

11. Display the Print Preview window. [ Ctrl-F2 ]

12. Switch to the next workbook window. [ Ctrl-F6 ]

13. Display the Macro dialog box to create, run, edit, or delete a macro. [ Alt-F8 ]

 

Disable the UAC feature in Vista

Are you tired of those User Account Control (UAC) prompts that appear whenever you're trying to run some admin tool on your Vista computer? They appear even if you're user account is a member of the Administrators group on your machine. That's because Protected Admins (PAs) normally run with the privileges of a standard user on Vista, which means to perform some administrative task or use an admin tool you have to first elevate your privileges to admin level, which is what the UAC prompt is designed to do.

Well, UAC is there for a reason--if your computer got infected by some malware and this malware tried to run an admin tool, the UAC prompt would appear to warn you that someone (you? Malware?) is trying to run a tool designed only for administrators. And a UAC prompt when you don't expect it would be a sure sign that something's gotten into your machine's innards.

Still, some users (especially sysadmins) are likely to find these UAC prompts annoying at best, so here's how to disable UAC on your machine:

1. Open Administrative Tools in Control Panel

2. Double-click on System Configuration

3. Click Continue to accept the UAC prompt

4. Select the Tools tab

5. Scroll down and select Disable UAC

6. Click Launch

7. Reboot your machine

Note that you may not be able to disable UAC if Group Policy configured for enforcing UAC on your computers.

Note: This tip is based on a pre-release version of Windows Vista and may not reflect functionality in the final product.

 

Use Firefox Profiles for different browsing habits

One of the most under-looked features of Firefox is its ability to run different profiles. This is perfect for various reasons. If more than one person is using the same computer, each person can have a different profile where he can have his own customized Firefox setting - such as extensions or bookmarks.

Another reason to use different profiles is when using FireFox for different purposes. Obviously, most people don't use every extension every time they use Firefox. However, the fact that the extension is installed makes Firefox startup and run slower than usual. The more extensions you run, the slower Firefox will run.

Use Firefox Profiles for different browsing habits

You can create Firefox profiles for the different browsing habits that you have. For example, if you are a web developer, you can have all extensions for that on one profile, without the unnecessary ones cluttering your Firefox. Likewise, if you want to browse without leaving any trace -"private browsing" - you can have a profile with the extension distrust or stealther and noscript.

For normal browsing, you can have another profile, and so on. This will keep your Firefox neat and fast - leaving only the necessary extensions and bookmarks for their respective purposes.

To use Firefox Profiles, follow these steps:

1. Go to Start->Run and type:

Firefox -p

Ffprofile.GIF

2. Click on Create Profile and name it whatever you want (porn mode, work…)

3. Run each profile and set it up exactly how you want it - download the correct extensions and place the bookmarks that you need.

Place desktop shortcuts for each profile:

To create shortcuts for each Firefox profile, put a shortcut for Firefox on your desktop for each profile. So if you have 4 profiles, place 4 shortcuts to Firefox. Right click->Properties on each shortcut and go to the Shortcut tab. In the target field, it will be something like this:

"C:\Program Files\Mozilla Firefox\Firefox.exe"

Simply add -p name to the end where name is the name of the profile. So if the profile name is 'private' the Target field should look like this:

"C:\Program Files\Mozilla Firefox\Firefox.exe" -p private

Ffprofile21.GIF

Do this for every shortcut of Firefox.

Depending on how many extensions you normally use, this can speed up your Firefox significantly (especially how long it takes it to start up) because the extensions are spread over more profiles. Also, it's much less cluttered because you can spread bookmarks also.

 

10 Basic Tips for Internet Explorer

Contributed by: Rajesh (verygood101 @ yahoo.com)

In order to use the Internet Explorer (IE) effectively, we have some basic tips for you to try…

   1. To extend the window area of the IE, you can make it easy by pressing the F11 key. Then you press it again in order to return the IE to the normal window.

   2. Sometimes you want to search a keyword in a long web page that you are surfing. How do you do ?? Just press Ctrl+F and place the keyword you want.

   3. Using Backspace key in your keyboard instead of clicking Back in the IE window.

   4. You can close your IE window that you are surfing by Ctrl+W.

   5. To see the surfing websites history, Press F4 key to see the URL which you have typed.

   6. Press Ctrl+D in order to save the url which you are surfing. And the url will be in the Favorites.

   7. To send a web page to your friend. Do you know we can send it by email from the IE's tools ? Let you try it, go to File > Send > Page by E-mail...

   8. To slide the web page by using the keyboard, try it with the arrow keys. To slide it to the bottom and the top of the web page, try the End and Home key.

   9. If you find a picture that you prefer it to be the desktop wallpaper, you can immediately set it, right click on the picture area and select the Set as wallpaper.

   10. To slide the web page gradually, you may use the Page up, Page down and Spacebar keys. Try it!

 

Microsoft Providing FREE Software to Students

Microsoft is Providing Professional Developer and Designer tools for students at no charge.Microsoft DreamSpark enables students to download Microsoft developer and design tools at no charge.This enables students to unlock there creative potential and set you on the path to academic and career success,by supporting and advancing your learning and skills through technical design, technology, math, science and engineering activities. Download it online or get it from here.