Shortcut Keys of MS Excel/ Microsoft Office tricks.

F2 : Edit the selected cell.
F5: Go to a specific cell .
F7: Spell check selected text and /or document.
F11: Create Chart
Ctrl+Shift+; : Enter the current time.
Ctrl+; :Enter the current date.
Alt+shift+F1: Insert new worksheet.
Shift+F3: Open the excel formula window.
Shift+F5: Bring up search box.
Ctrl+A: select all contents of the worksheet.
Ctrl+B: Bold highlighted Selection.
Ctrl+I : Italic highlighted Selection.
Ctrl+K: Insert link.
Ctrl+U: Underline highlighted  selection.
Ctrl+5: Strike through highlighted selection.
Ctrl+P: Bring up the print dialogue box to bring printing.
Ctrl+Z: Undo last action.
Ctrl+F9: Minimize current window.
Ctrl+F10: Maximize current window.
Ctrl+F6: Switch between open work books/windows.
Ctrl+Page down: Move between Excel worksheets in the same excel document.
Ctrl+Tab: move between two or more excel files.
Alt+=: Create a formula to sum all of the above cells.
Ctrl+'  : Insert the value of the above cell into the cell currently selected.
Ctrl+shift+! : Format number in comma format.
Ctrl+Shift+$ : Format number in currency format.
Ctrl+Shift+# : Format number in date format.
Crtl+Shift+% : Format number in percentage format.
Crtl+Shift+^ : Format number in scientific format.
Crtl+Shift+@ : Format number in time format.
Crtr+Arrow key : move to next section.
Ctrl+Space: Select the entire colum.
Shift +Space : Select entire row.

Read More

Trick to Safeguard Your Email Address/Gmail tricks

We find it a safe measure to share our personal information and images through emails  which is the common thing that most of the time we follow but what if your email is been hacked by hackers , as in today's day to day life its common. Today I'm gonna share a trick which helps you to  protect your mails just by following few simple steps.

• Fist you need to Edit Profile
• Contact Information
• Clicking on the icon beside your email address
• Checking 'Only Me'.

    

Now change your primary email address to a one that is only known to you by going to Account Settings>Email> and changing your primary email to the new one (known only to you) and removing your previous email address.

    For additional security, when in Account Settings, check 'Secure browsing' and 'Send me an email when a new computer or mobile device logs into this account' and click Save.

Some of the safety measures:

• At last Be careful before clicking on suspicious links. 
• Always check the URL in the address bar before signing in. 
• Avoid logging in through various "Facebook widgets" offered by websites and blogs.  
• Facebook's homepage to sign in. 
• Always try to use Safe Search while searching. 
• If you do manage to get phished, report the website so that others may get a warning before visiting it

Read More

Trick to Reboot Your Android Device!! Android tricks

 

 Today's trick is very simple and much useful for all android users its about rebooting your device in just two steps to overcome  the problems like freeze or becomes responsible. check out below  that how you can do by following steps.

1. Press and hold the Power button of your device.
2.  Pop-up menu will  appear.
3. Select 'Power off' and tap 'OK' to confirm then the system will turn off.
4. Turn the system on by pressing and holding the Power button until the Google logo appears.
5. Now You are done with it.

Read More

Trick to Unlock MS Word File/ Hacking Tricks 2015

Hello friends,

 Most of the time we forget the password  in Microsoft Word document and fail to get back those documents , even it had happened with me so with one of my experience i tried this trick and it works so i decided to share with you and enjoy your work even after that.check out below steps to perform this trick.

 1. Right-click on the file you have forgot the password to.

2. Click 'Rename'

3. Rename the file to whatever.rtf

4. The file should now have a new name and a new type. It is now a Rich Text File instead of a Word file.

5. Right-click on whatever.rtf and hover the mouse over "Open With".

6. Pick WordPad.

Now your  file should open up for you in WordPad. But you won't have all of the styling you had before in your document , Now you can copy and paste the text into a new Word document and re-style it however you want.
 
Note: This Hack works only when you rename the file with the .rtf  file extension.

Read More

Free download TouchPal Keyboard app for androids/ Fastest keyboard in the world

 Download HERE for free

TouchPal Keyboard is Fastest keyboard in the world  which  increase the typing speed in androids by Contextual prediction and Sliding Input perfectly. It has a coolest look and feel, highly customizable with multiple skins, multiple layouts and Innovative features & shortcuts .

 Features tagged below:

Sliding input experience and contextual prediction saves up to 80% keystrokes.
Mistyping correction on QWERTY.
Multiple skins available.
Toolbar plugins for social sites sites like Facebook and twitter

Gesture shortcuts (slide up/down) for numbers or punctuations.

Multi languages support (download language packs after installation)
Numbers of delicate themes for you to choose
Outstanding dictionary with online update
Import contact list to your user dictionary
Backup/restore user dictionary in SD card
Voice input (Android 2.2+)

Read More

New trick to Manage Multiple Twitter Account 2020

Hello friends,

 Twitter is one of the famous social networking site used by us,we use it for promoting our works and I'm sure many of us have many account in that  but to manage all at a single go is not possible in a same browser so  today I'm sharing a simple trick  to manage multiple twitter account.

Step 1: Install Google Chrome in your computer if you haven't.

Step 2: Now install the "Quick Tweet" Extension in your browser (Google Chrome) by click on "Add to Chrome" button.

Step 3: After adding extension in your browser, click on Twitter Icon shown in right corner of your browser window. Right click on the icon and then click on "Options".

Step 4: In the Option menu, write your twitter account's name/email and Passwords and then click on "Save".

Step 5: Now whenever you want to sign in into different account, just click on Twitter icon shown in right side corner of your browser and then select your account. This will automatically sign you in into the account you have chosen. You don't have to enter your email and password again and again.

NOTE: You can add up to 10 accounts in this extension and use whenever you want.

Read More

Edit Java file .Jar and .jad file on Nokia Mobiles.

Hello Friends,

Today going to share a trick where you don't need to have a PC or laptop to edit or translate Java applications as now after reading this post  you can  edit in your mobile,just check out below how

Java applications have an extension .jar. JAR is a ZIP archive format. So an application which can unzip a Zipped file, can also unzip a Java application.

Copyxpert dot tk Java applications usually contain class files with many other associated files. If we can change or edit the class files and other files, then we can change an application. As the java file system, we cannot edit files with extension .jar. 

So we must have the application with its extension.zip. Our Ucweb can do his. When you download an application through Ucweb, just rename it to .zip (e.g.-mini.jar to mini.zip). Now you can edit.You know differences between .jar and .jad. Jar is Java Archive, while .jad is Java application descriptor

Read More

Trick to use Blocked Website/New tricks 2020

Friends If you wanna  visit blocked website using a web proxy, you do not need any setup. However, if you wish to use a proxy server that can only be accessed by using its IP address and port number, you must configure your browser to use it. so here is a simple trick for your browsers to where by follow the simple instructions given below to setup proxy server in your browser:

Google Chrome and Internet Explorer Users:

Google Chrome uses the same network settings as Internet Explorer. So, in order to configure Google Chrome to use a proxy server, you have to configure Internet Explorer. You can configure a proxy server in Internet Explorer by following the instructions given below:-

• Start Internet Explorer.
• Click on Tools, Internet Options.
• Click on Connections Tab, select your Network Connection and click on Settings.
• Check on Use a Proxy Server for this Connection.
• In the Address field, add the IP Address of your Proxy server. In the Port field, enter the Port Number.
• Click on OK and OK again.

Mozilla Firefox Users:

Mozilla Firefox users can configure their browser to use a proxy by following the instructions given below:-

• Start Mozilla Firefox.
• Click on Tools, Options.
• Click on Advanced Tab.
• Click on Network tab.
• Click on Settings.
• Encircle Manual Proxy Configuration.
• Enter the IP Address and Port Number at the appropriate place. In most cases, it will be a HTTP server.
• After you have successfully configured your browser to use the proxy server, you will be able to access blocked websites whenever you browse the internet with your browser.

Read More

Trick to Root Your Samsung Galaxy Device

Hello friends,

Sharing a trick which i came across recently that how we can root our Samsung Galaxy Device in just few simple steps...
                                  Note : keep charge about 70%

1. Find update.zip file for your device from Google (type phone model root).

2.Place it into your phone memory.

3.Turn off Your device.

4.Press vol.up+home screen+power button.

5.Now your touch will not work so use volume button for scroll and home to choose.

6.Choose update from Phone Memory(sd card).

7.Choose update.zip

8.Choose reboot.

9.Enjoy.

Read More