Data Entry Table On MS Excel
Firstly, We open MS Excel by click on Window button ! again click on all Program then click on MS Office as it is we get MS Excel then click on it. Now, the spreadsheet will be open. We create Data what we want to do. (like: TIME TABLE)
We click on cell double click if we just a click means Single click then we can't type in it So we will double click & we see that the typing icon will be show. Now we start to create our Data. Here I'm creating TIME TABLE.
We will type TIME TABLE under A next to 1 (under A is Column and here next to 1 this is Row)
here you can see on Image.
We type TIME TABLE. we want our written TIME TABLE should be show in the middle then we will cut & paste in the middle of table by using {Shortcut key of (CUT- Ctrl+X) & (Paste-Ctrl+V)} Press Enter ! as it is we will come on next cell. Here I have 5 Subjects.
We will click on B2 column type GEN ENG/HINDI then press TAB button we come on C2 column
type GEN KNOWLEDGE, REASONING, MATH and COMP KNOWLEDGE.
Click on A3 type MONDAY Press enter we come on A4 type TUESDAY, WEDNESDAY, THURSDAY, FRIDAY and SATURDAY.
We will type hours on each cell. JUST SEE ON IMAGE.
We can give border in all Data then Select first column and drag the mouse where you want or you can use shortcut key Ctrl+A . We go on font and take border.
 |
THIS IS IMAGE OF SELECT DATA WHERE WE WANT BORDER.
HERE THE BORDER CREATED ON DATA.
|
We want Bold then go on FONT and click on Bold or CHANGE SIZE OF TEXT. It's command also on FONT. We change text click on font face and select anyone. we can change the position from LEFT to RIGHT ; RIGHT to LEFT ; CENTRE OR JUSTIFY. All these command are on FONT and FONT is available on HOME.
At Last, We save the file by click on office button(it's look sign of Window) and click on Save then a Dialogue Box will be open we will give the file name (Eg: abc) and click on save button.
Here we have also Shortcut method by using Shortcut key Ctrl+S and same a Dialogue Box open give file name and Save it.
Comments
Post a Comment