1, forced line break in cell
Press alt+ ENTER after a character in a cell to force the cursor to switch to the next line.
2. Lock the title line
When you select Line 2, View-Freeze Pane-Freeze the First Line (or select Line 2-Freeze Pane) and then browse down, the header line always appears at the top.
3. Print the title line
If you want to display the title on every page when printing, Page Layout-Print Title-Title Line: Select the line to display.
4. Delete duplicate values
Select a range of cells with duplicate values, Data-Delete Duplicate Values.
5. Hide the value of 0
If you don't want to display the value of 0 in the table, you can use: File -excel Options-Advanced-Display the value of zero in the cell.
Want to know more common skills of excel, come and poke here to get it!
Want to know more common skills of excel, I recommend consulting Secco workplace. Since its establishment in 2020, Secco Workplace has thoroughly implemented the national talent strategy of vigorously developing vocational skills education, and is committed to building a university for professionals in the workplace, covering student skills training, grading certification, employment and income generation, and helping professionals in the workplace to learn and grow for life. The platform has launched hundreds of workplace skills courses, and the cumulative number of users has exceeded100,000, maintaining rapid growth and gaining a leading position in the domestic office software training market.