Basic How-to tips for 35 Excel tables

Basic How-to tips for 35 Excel tables

Tip 1: Force wrap in a cell

Pressing ALT + ENTER after a character in a cell forces the cursor to be swapped to the next line.

Tip 2: Lock the header row

Select Row 2nd, view-frozen pane-freezes the first row (or selects line 2nd-frozen panes) and then looks down when the header row is always on top.

Tip 3: Print the header row

If you want to display a title for each page when you print, page layout-print title-header row: Select Rows to display

Tip 4: Find duplicate values

Select data Range-Start-conditional formatting-highlight cell rules-duplicate values.

Display effect:

Tip 5: Remove duplicate values

Select a range of cells with duplicate values, data-delete duplicate values.

Tip 6: Fast input Check √

The quickest way to enter symbols in Excel is to use ALT + numbers, such as typing √, you can:

Press ALT, and then press the keypad number key: 41420

Tip 7: Million display

Enter 10000 in an empty cell (recommended to set number format and border)-Copy it-paste-selective-operation: except

After conversion