Suisui_Cell Alignment

Front 1

Cell alignment

Back 1

Choose format ->
choose cell ->
in alignment tab, it can change displaying the text to any degrees; or in horizontal or vertical format; or choose wrap text, merge cells or shrink to fit

Front 2

Clear cell formatting

Back 2

choose edit -> clear
it can choose to clear all the thing in the cell; or just clear the format, or contents or comments in the cell

Front 3

Add the comments to the cell

Back 3

choose insert -> comments
then type the comments ->
if want to hide the comments, then right click the cell and choose hide the comments

Front 4

Find and replace

Back 4

choose edit ->
choose find (ctrl F) or
replace (ctrl H)

Front 5

Go to cells quickly

Back 5

type'ctrl G'
or
choose edit ->
choose go to ->

in reference, type the cell you want to go to
or
choose special -> then choose specific types of cell to go to like formula cell

Front 6

change the size of column and row

Back 6

choose format ->
choose column or row width

or click the left top 'gray' empty cell (ie the empty cell right above the A1 cell); this allow you to change the size of all rows and columns

Front 7

Freeze panes - to freeze the row and column headings

Back 7

click cell 'B2'
choose window ->
choose freeze panes

Front 8

Create custom automatic list

Back 8

choose tool ->
choose options -> custom list
in the custom list, click import to create own list and then click okay; then Excel will memorize this list; each time when we type the first item in the list and drag the cell, the rest of items will be entered automatically

Front 9

Fill in series

Back 9

right click and drag a cell at the same time ->
choose series->
choose data type ->
or can choose the step value which means the difference in the series

Front 10

Insert a chart

Back 10

choose 'inser' ->
choose chart