Multi line

Make cell multi line Use ALT+ENTER to add a lin break. Ensure “Wrap Text” is turned of for the cell

Read More

Freeze panes

Don’t select all the rows, just select the row below the row or rows you want to freeze. If you want to freeze columns, select the cell immediately to the right of the column you want to freeze. View tab > Freeze Panes command > choose “Freeze Panes.”

Read More

Cell Formatting

Don’t allow cell content to overflow cell (hide excess) Select Cells > Right click > Format Cells > Alignment > Horizontal = Fill

Read More