Microsoft EXCEL
                          --------------------------

-File->Info->Protect WorkBook to lock the excel sheet

-File->Share->Email

compatible with office 2007/10..etc.
-File->Check for issues->check compatibility


Tab to go to next column.
Enter to go to next row.
Alt + Enter to enter a new line in the same column.
Ctrl+ END for ending of sheet
CTRL+HOME for beginning of sheet

CTRL+ Ri8 Nav-> last-cell of the current row

ctrl+ g : enter cell-name like A1 to focus first cell
ctrl +f : for finding entered text and also for replacing the content


create New sheet: Ri8Click->Insert (SHIFT + F11)
copy as picture: Home->copy ->copy as picture

Review ➪ Spelling or press F7 : spell checker

Insert » Symbols » Symbol to insert available symbols
Insert » Symbols » Special Characters

Right click-> inert comment  (or) SHIFT + F2 OR  (we can format comment text by selecting the content)
Choose Review » Comments » New Comment : comment for particular cell and also we can edit the comment in review menu

Choose Insert » Text Box » choose text box or draw it.
(we can also format this text box)

 8008301919
 Formatting cells » Font Tab » Effects cells like strike-through, Super script, Sub script

 Rotating text:  Home tab » Alignment
                              :merge&cener, wrap text, orientation, alignment
 (While merging discards the data of second cell)

 Home tab » Font Group » Select the Colour: background colour (shading)
 Right Click » Format cells » Border Tab » Select the Border Style.

 Home Tab » Style group » Conditional Formatting dropdown like equal, greater..etc.

 PRINT:
 --------
 Printing: Page Layout » Sheet Options group » Grid-lines » Check Print.
  Layout » Page Set up » Margins drop-down list, you can select Normal, Wide, Narrow, or the custom Setting.
  Margins are the unprinted areas along the sides, top, and bottom
  while Printing page set-up option: we can choose header and footer of the page
  --------------------------------------------------------
 
  Page Layout » Page Set-up » Background command: Bgc Image
 
 
  Freezing Panes: headings will not be visible when you scroll down or to the right.
  ---------------- ----------------------------------------------------------------
  - Freezing panes keeps the headings visible while you’re scrolling through the worksheet.
  -View Tab » Freeze Panes.(usually we freeze first row/column)
 
 
  Ctrl+ pageup: move to previous sheet
  Ctrl+ pageDown: move to Next sheet
 
  Formulae:
  --------------