Make cell multi line Use ALT+ENTER to add a lin break. Ensure “Wrap Text” is turned of for the cell
Category: Excel
Binary functions
Binary AND type functions You can’t
Convert values
Rounding values Round Down & Convert to 10’s Convert To Hex Convert To Binary
Query cell content
Does Cell Contain Text Segment
Combining cell content
Combining text from different cells
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.”
Cell Formatting
Don’t allow cell content to overflow cell (hide excess) Select Cells > Right click > Format Cells > Alignment > Horizontal = Fill