All of us who use computer at a point of time come across a situation to use Excel due to its efficient way of handling data. Listed are few excel tips for beginners who starts working with excel. For Newbies : What is Excel? Excel is an electronic spreadsheet program used for storing, organizing and manipulating data. Tip 1 : Wrap the Text Wrapping a text feature helps to make the content visible in a cell without increasing the width of the [...]
This article will tell you how to create a jar file using Java’s Jar command in command prompt. Basically jar file format is formed from ZIP file format. Jar files are mainly used for archiving, compression and decompression. Note : Java should be installed in your system to execute Jar command and also correct java path should be set up before starting. Using Jar command you can create,view,delete,update/modify,extract and execute the jar files. 1. Creating a Jar file 1. Format: [...]
To disable right click access in taskbar, in order to prevent users from accessing taskbar and start menu properties, starting task manager and adding any toolbars in taskbar, follow the below mentioned steps. Step 1: Goto “Start -> Run” and Type “gpedt.msc” (this will open Local Group Policy Editor) Step 2: In the left side of the editor, select “User Configuration -> Administrative Templates -> Start Menu and Taskbar” Step 3: In the right side of the editor, Select “Remove [...]
If you do not want to give right click access to the users for some security reasons. Follow the below mentioned steps: Step 1: Goto “Start -> Run” and Type “gpedt.msc” (this will open Local Group Policy Editor) Step 2: In the left side of the editor, select “User Configuration -> Administrative Templates -> Windows Components -> Windows Explorer” Step 3: In the right side of the editor, Select “Remove Windows Explorer’s default context menu” and double click on it. [...]
Step 1: Press “ctrl + A” to select all the contents in the document Step 2: Press “shift + ctrl + F9″ to remove all the hyperlinks in the selected content of the document. This will work in MS Word 2003, 2007 and 2010 ….
When we copy a text from a web page or other source and paste them in a Gmail,the formating of the original text would be same.Some times it may be annoying we need it to be normal.In Gmail there is a simple way by just selecting the text’s and clicking the button ‘Tx’(as in image below) would format the texts to normal format.
Step 1 : Go to command prompt (Click Start and type cmd). Step 2 : In the command prompt window navigate to the folder where the files are located. Step 3 : Type ren *.(current extension) *.(extension to change) Example: ren *.txt *.doc This will change all the .txt files in that folder to .doc extension file
When we type some long text in a excel column it would overlap the other columns.To avoid this and make the full content visible there is a Microsoft office excel tip. Select the cell(s) to wrap. click on Home Tab Wrap Text. We can also see the Microsoft help describing the Wrap Text feature in excel. That’s it.Now the cell is fully visible in the Excel 2007 file.
There are times we need to convert excel rows to columns.Excel inbuilt has a option to do this in easy steps. Rows to Columns Step 1 : Select the all rows to be converted as columns and copy them. Step 2 : Click in any empty cell and right click and select Paste Special option from it. Step 3 : A popup could come, from it check Transpose. That’s it.See the result. The same steps applies for converting columns to rows.
Gmail gives a secure feature to monitor and protect your email account.It provides you with latest 10 IP address that you have logged into the account.By this you can check is some else have logged in your Gmail account.And also it provides the current open location of your Gmail account. To check these details scroll down your email page you would notice the “Last account activity” label and the Details link. Click on details link to check the IP addresses [...]