How to excel ‘Format Menu’ works?
‘Format Menu’ is very important menu of the ‘Menu Bar’. You can create or change your cell, row and column in the excel program by using the ‘Format Menu’. You can also change your document format styles.
Describe the details of ‘Format Menu’ in the MS excel.
‘Cell’ option or press (Ctrl + 1) is used for adding numbers, adding alignment, text direction, changing or modifying font type, font style, font size, font color, font effect and font effect, adding a border with different line styles, applying cell color with different patterns in the MS excel document.
‘Row’ option is used for changing the height of a row or set auto fit, hiding your desire row from excel document. You can also use to unhidden your hide rows of the MS excel document.
‘Column’ option is used for changing the weight of a column or set auto fit, hiding your desire column from excel document. You can also use to unhidden your hide column of the MS excel document. You can also set the standard weight of the column.
‘Sheet’ option is used for renaming your excel sheet name, change your sheet background color and sheet tab color. You can also use to hide your desire sheet from document and unhidden your hide sheet of the MS excel document.
‘Style’ option is very important sub-menu of the ‘Menu Bar’ in the MS excel. It is used to change your document setting, such as alignment, font, border, patterns etc.
Now describe the ‘Tools Menu’ in the MS excel.
‘Tools Menu’ is another necessary menu of the ‘Menu Bar’. It is used for spelling check and changing or modifying different settings of your document.
‘Spelling’ is used for checking word spell in your document.
‘Protection’ option is used for saving your document with a great protection to better security.
‘Customize’ option is very important sub-menu of MS excels. It is used to add, edit or delete function menu or create a custom toolbar, make commands and modify command and many more.
‘Option’ is used for setting and modifies general option, edit option, view option, print option, save option, security option, spelling and styles option of MS excel.
1 comment
Lyhaneg
February 19, 2013 at 7:40 pm (UTC 6) Link to this comment
Just to note:In the second half of the video, inestad of having to copy and paste in order to have the SUM formula applied to new cell entries, you can simply go to the EDIT preferences and look for Extend data range formats and formulas and have it checked so that Excel will do it for you automatically. Excel will know that any item you enter above the SUM formula wants to be added up.