Format Worksheet

Task: Format Worksheet
No	Steps
C1.1 Create New Workbook
01	Open spreadsheet package
02	Click office button  à Click New àSelect Blank workbook
03	Click Create button
04	Rename the Worksheet
05	Type content
06	Click office button à Click save
07	Select and open folder
08	Give your workbook a new name in “File Name:”
09	Select the version and format from “Save as type:”
10	Click save button
C1.2 Save a workbook as a different Name, Version, or Format
01	Open spreadsheet package
02	Open exiting workbook
03	Click office buttonà Save as
04	Select and open folder
05	Give your document a new name in “File Name:”
06	Select the version and format from “Save as type:”
07	Click save button
08	Open exiting workbook
09	Click office button
C1.3 Save a Workbook with Password
01	Open spreadsheet package
02	Open exiting workbook
03	Click office buttonà Save as
04	Select and open folder
05	Give your workbook a new name in “File Name:”
06	Select the version and format from “Save as type:”
07	Click tools àgeneral option
08	Type password to openàok
09	Reenter password to openàOk
10	Click save button
C1.4 Open Exiting Workbook
01	Click office button
02	Click open
03	Select and open folder
04	Select file
05	open
C1.5 Insert/Delete/Rename/tab color the worksheet
01	Open spreadsheet package
02	Create or open exiting Workbook
03	Right Click Sheet tab
04	Then select suitable command Insert/Delete/Rename/tab color
05	Save the worksheet
C1.6 Insert/Delete/Change column width/Clear content/Hide the Column
01	Open spreadsheet package
02	Create or open exiting Workbook
03	Right Click column heading tab
04	Then select suitable command Insert/Delete/Change column width/Clear content/Hide

05	Save the worksheet
C1.7 Insert/Delete/Change Row height/Clear content/Hide the Row
01	Open spreadsheet package
02	Create or open exiting Workbook
03	Right Click Row heading tab
04	Then select suitable command Insert/Delete/Change Row height/Clear content/Hide
05	Save the worksheet
C1.8 Number Format
01	Open spreadsheet package
02	Create or open exiting Workbook
03	Type following numbers and others A B C D 1 5000000 0.75 0718249323 2 15000000 0.25 0712450123 3 -25000 0.125 0751254898 4 11/25/1980 1250000 0914578556 5 8/12/2010 0.000125 0777466544 6 0.25 1.25 0726465444 7 0125
04	Select A1:A3
05	Select Number option (Decimal place/use thousand separator /negative number style)àOK
06	Repeat the steps 4 and 7
07	Select currency (Decimal place/Currency symbol /negative number style)àOK
08	Repeat the steps 4 and 7
09	Select accounting ( Decimal place/Currency symbol)àok
10	Select A4:A5à Repeat the steps 5 and 7
11	Select date (Select date Type)àOK
12	Select A6:A7 àRepeat the steps 5 and 7
13	Select percentage  ( Decimal place )àOK
14	Select B1:B3à Repeat the steps 5 and 7
15	Select fraction ( select type )àOK
16	Select B4:B6à Repeat the steps 5 and 7
17	Select scientific  ( decimal place )àOK
18	Select C1:C6à Repeat the steps 5 and 7
19	Select custom  à type “(“000”)-(“0000000”)”àOK
C1.9 Cells Formatting
01	Open spreadsheet package
02	Create or open exiting Workbook
03	Select cells
04	click home ribbon ànumber group
05	Click dialog box launcher àClick number tab
06	Select desired category and its properties
07	Click 'Alignment' tab
08	Select desired 'Text Alignment', 'Text control' and 'Orientations'
09	Click 'Font' tab
10	Select desired features (size, font style, underline, color, effects, font)
11	Click 'Border' tab
12	Select desired features (Presets, Line style, border, color)
13	Click 'Pattern' tab
14	Select desired feature (Cell shading, Pattern)
15	Click 'Protection' tab
16	Select 'Locked' option
17	Click 'OK' button