How to track changes in a word document

When there are multiple persons working on a document, it may be difficult to know who made which changes and where its been made. The ‘Track Changes’ feature in Microsoft Word allows you to see the changes made to the document and who made them.

To enable ‘Track Changes’ feature, follow the steps

  • Click the Review tab in the Ribbon 
  • Under the Tracking Group click on Track Changes or use shortcut key Ctrl + Shift + E. Any changes made to this document will be shown highlighted in different colour with user information

  • After enabling Track Changes and the document is edited by a user, the insertion will be highlighted in red colour and with underscore.
  • To review the changes made in the document, click on Reviewing Pane under Tracking Group to show up the Review pane with the list of changes made to the document by which user
  • You can Accept the changes or Reject the changes by clicking on respective buttons in the Tracking Group under Review tab

 

How to set different formats of page numbers in a single MS Word Document

This tutorial tested under MS Word 2010

Step 1:

Open Microsoft Word 2010

Step 2:

Type “Ctrl + Enter” multiple times (Each time a new page will open)

Step 3:

Goto First page of your document

Step 4:

Goto “Insert” tab -> “Header and Footer” Section -> Click “Page Numbers” to display page numbers in a header or footer section with a default formats.

Now all the pages will have a page numbers with a default format in your document

Step 5:

Now break the pages into a two different page formats and page numbers

Goto the page where you want the break.. here I will take page 2 to show the break

Goto the page 2, now select “Page Layout” tab and select “Breaks” drop down from “Page Setup” section. In that drop down goto “Section Break” and select “Next Page”.

Now Your document will have section break from the page 3.

Step 6:

Goto the page 3 and double click on the heater or footer where your page number exists.

“Heater and Footer Tools” Tab will activated automatically on the menu ribbon. In that Click the “Link to Previous” button from the “Navigation” section. (This will remove the connection between the different sections)

Step 7:

Select the Page number and then select “Page Number” drop down menu from “Heater & Footer” section of “Heater and Footer Tools” Tab. From that drop down menu select the “Format Page Numbers…” option

Step 8:

Page Number Format dialog box will open. Choose some different page number format and you may continue the page number from the previous section or you can decide the starting number.

A Sample document with different page number format is attached for the reference: Sample Document

Courtesy:
M.Anandha kumar

3 Useful Excel Tips For Dummies – How-To

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 cell.

Step 1: Select the text to be wrapped.

excel word wrap

Step 2:  Click Wrap text button (as shown in the image)

excel wordwrap

Tip 2 : Remove Duplicates

To remove the duplicate rows in excel and get only unique rows we can use remove duplicate feature.

Step 1 : Select the column and click Remove duplicates button in Data tab.

excel remove duplicate

Step 2 :

excel remove duplicateexcel remove duplicate

After clicking OK we get only the unique rows as the result shown below.

excel remove duplicate

Tip 3 : Merge Cells

When we need to merge cells in excel to show some heading or for other uses we can use this merge cell feature in excel.

Step 1 : Select the cells to be merged.This can we done we clicking on a cell and dragging the mouse till the cell to be merged.

excel mergecell

Step 2 : Right click and select format cells option.In the format cell window select Alignment tab(as shown in the image).

Then check Merge cells option under Text control section.Click OK.

excel mergecell

After applying the merge cell option we would get the output as the below image.

excel mergecell

How to create a Jar file in command prompt

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:
jar cf JAR_NAME INPUT_FILENAME(S) OR DIRECTORY_NAME

c – create JAR file
f – Output should go to file rather than stdout (terminal)
JAR_NAME – Name of the Jar file (can give any filename you want). Filename should be given .jar extension
INPUT_FILENAME(S) – One or more files to be included in the JAR file and each file will be separated by a space
DIRECTORY_NAME – If the “input files” are directory, then the contents of the directory (given in the DIRECTORY_NAME) are added to the jar recursively.

Note : c and f should be in any order but should not have any space in between them

E.G:
jar cf sample.jar D:\Java\sample.class

or

jar cf sample.jar D:\Java

D:/Java is a Directory

2.
Format:
jar cvf JAR_NAME INPUT_FILENAME(S) OR DIRECTORY_NAME

v – with “verbose” output which tells the names of all the files that is added to the jar.

E.G:
jar cvf sample.jar D:\Java

added manifest
adding: D:/Java/(in = 0) (out= 0)(stored 0%)
adding: D:/Java/audio/(in = 0) (out= 0)(stored 0%)
adding: D:/Java/audio/amma.wav(in = 46480270) (out= 43382835)(deflated 6%)
adding: D:/Java/audio/sampath.wave.wav(in = 626251) (out= 592538)(deflated 5%)
adding: D:/Java/Images/(in = 0) (out= 0)(stored 0%)
adding: D:/Java/Images/bike22.jpg(in = 48241) (out= 45154)(deflated 6%)
adding: D:/Java/Images/Desert.jpg(in = 845941) (out= 842691)(deflated 0%)
adding: D:/Java/sample.java(in = 94) (out= 89)(deflated 5%)
adding: D:/Java/sample.jar

3.
Format:
jar cvf0 JAR_NAME INPUT_FILENAME(S) OR DIRECTORY_NAME

0 – (zero) Jar file will not be compressed

E.G:
jar cvf0 sample.jar D:\Java

added manifest
adding: D:/Java/(in = 0) (out= 0)(stored 0%)
adding: D:/Java/audio/(in = 0) (out= 0)(stored 0%)
adding: D:/Java/audio/amma.wav(in = 46480270) (out= 46480270)(stored 0%)
adding: D:/Java/audio/sampath.wave.wav(in = 626251) (out= 626251)(stored 0%)
adding: D:/Java/Images/(in = 0) (out= 0)(stored 0%)
adding: D:/Java/Images/bike22.jpg(in = 48241) (out= 48241)(stored 0%)
adding: D:/Java/Images/Desert.jpg(in = 845941) (out= 845941)(stored 0%)
adding: D:/Java/sample.java(in = 94) (out= 94)(stored 0%)
adding: D:/Java/sample.jar

4.
Format:
jar cvfm JAR_NAME MANIFEST_FILENAME INPUT_FILENAME(S) OR DIRECTORY_NAME

m – include external manifest file
MANIFEST_FILENAME – Name of the Manifest filename

Note :
M – include default manifest file (need not mention manifest filename)

E.G:
1.
jar cvfm hello.jar MANIFEST.MF hello.java
added manifest
adding: hello.java(in = 2906) (out= 1025)(deflated 64%)

To view the jar file contents
jar tf hello.jar
META-INF/
META-INF/MANIFEST.MF
hello.java

2.
jar cvfM sample.jar hello.java
adding: hello.java(in = 2906) (out= 1025)(deflated 64%)

2. Viewing the contents of a jar file

Format:
jar tf JAR_NAME

t – Display the table of contents of the Jar file
f – Contents of the Jar file should be display on the command line

E.G:
jar tf sample.jar

META-INF/
META-INF/MANIFEST.MF
D:/Java/
D:/Java/audio/
D:/Java/audio/amma.wav
D:/Java/audio/sampath.wave.wav
D:/Java/Images/
D:/Java/Images/bike22.jpg
D:/Java/Images/Desert.jpg
D:/Java/sample.java

3. Viewing the contents in detail of a jar file

Format:
jar tvf JAR_NAME

v – with “verbose” output

E.G:

jar tvf sample.jar

0 Fri Mar 22 18:18:18 IST 2013 META-INF/
68 Fri Mar 22 18:18:18 IST 2013 META-INF/MANIFEST.MF
0 Wed Mar 20 18:00:14 IST 2013 D:/Java/
0 Wed Mar 20 17:13:24 IST 2013 D:/Java/audio/
46480270 Sun May 02 20:13:38 IST 2004 D:/Java/audio/amma.wav
626251 Wed Nov 26 17:46:00 IST 1997 D:/Java/audio/sampath.wave.wav
0 Wed Mar 20 17:26:26 IST 2013 D:/Java/Images/
48241 Sat Jun 28 06:44:54 IST 1986 D:/Java/Images/bike22.jpg
845941 Tue Jul 14 11:02:30 IST 2009 D:/Java/Images/Desert.jpg
94 Wed Mar 20 17:11:28 IST 2013 D:/Java/sample.java

4. Extracting the contents of a jar

1.
Format:
jar xf JAR_NAME

x – Extract from the Jar file (mentioned in the JAR_NAME)
f – Extracted files should be displayed on the command line
JAR_NAME – Name of the jar file from which the files to be extracted

E.G:
jar xf sample.jar

2.
Format:
jar xvf JAR_NAME

v – with verbose output

E.G:
jar xvf sample.jar

created: META-INF/
inflated: META-INF/MANIFEST.MF
created: D:/Java/
created: D:/Java/audio/
inflated: D:/Java/audio/amma.wav
inflated: D:/Java/audio/sampath.wave.wav
created: D:/Java/Images/
inflated: D:/Java/Images/bike22.jpg
inflated: D:/Java/Images/Desert.jpg
inflated: D:/Java/sample.java

5. Extracting the specific file from a jar

1.
Format:
jar xf JAR_NAME ARCHIVED_FILE(S)_FROM_JAR

ARCHIVED_FILE(S)_FROM_JAR – Space separated list of files to be extracted from the Jar

E.G:
jar xf sample.jar sample.java

2.
Format:
jar xvf JAR_NAME ARCHIVED_FILE(S)_FROM_JAR

v – with verbose output

E.G:
jar xvf sample.jar sample.jar
inflated: sample.java

6. Updating the Jar

1.
Format:
jar uf JAR_NAME ARCHIVED_FILE(S)_FROM_JAR

u – Update an existing file
f – Update to jar file to be displayed on the command line
JAR_NAME – Existing jar file to be updated
ARCHIVED_FILE(S)_FROM_JAR – Space separated one or more files to be added to the existing jar file

E.G:
jar uf sample.jar hello.java

jar tf sample.jar
META-INF/
META-INF/MANIFEST.MF
D:/Java/
D:/Java/audio/
D:/Java/audio/amma.wav
D:/Java/audio/sampath.wave.wav
D:/Java/Images/
D:/Java/Images/bike22.jpg
D:/Java/Images/Desert.jpg
D:/Java/sample.java
hello.java

2.
Format:
jar uvf JAR_NAME ARCHIVED_FILE(S)_FROM_JAR

v – with verbose output

E.G:
jar uvf sample.jar hello.java
adding: hello.java(in = 2906) (out= 1025)(deflated 64%)

jar tf sample.jar
META-INF/
META-INF/MANIFEST.MF
D:/Java/
D:/Java/audio/
D:/Java/audio/amma.wav
D:/Java/audio/sampath.wave.wav
D:/Java/Images/
D:/Java/Images/bike22.jpg
D:/Java/Images/Desert.jpg
D:/Java/sample.java
hello.java

7. Executing a Jar file

Format:
java -jar JAR_FILE_NAME

-jar – jar flag tells the java launcher that the application is packaged as a jar file. (Only one jar file will be executed at time)
JAR_FILE_NAME – Name of the jar file to be executed

E.G:
java -jar sample.jar

How to disable right click in taskbar in Windows xp / Windows 7

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 access to the context menus for the taskbar” and double click on it.

Step 4:
Select “Enabled” and Press “OK”

Step 5:

How to disable right click in Windows xp / Windows 7

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 4:
Select “Enabled” and Press “OK”

Step 5:

Remove Text Formatting from Gmail – Copy/Paste – Tips and Trick

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.