How to make a double slashes header in WPS Spreadsheet
A free Office suite fully compatible with Microsoft Office
A free Office suite fully compatible with Microsoft Office
1. Use WPS Office to open the spreadsheet, click the Insert tab and then click theShapes button.Select a straight line from the drop-down menu. Then insert a straight line into the table.
2. Insert a straight line again.
3. Click the drop-down button of Text Box in the Insert tab, and select the Horizontal Text Box.
4. Then draw a text box at the designated position, and enter the needed text in the text box.
We can adjust the text box according to our needs.
If the content in the text box can't show all, we can select the text box first. Then place the mouse cursor on the border. When the cursor's pattern becomes an arrow, click and drag to change the length of the text box.
Or if we find that the text in the text box blocks the content of other cells, we can adjust the font size and text box settingsto perfect the table.
Font size: First select the content we want to adjust the font size. Now find font size in the Home tab. Users can choose the font size they want here.
Text box settings: First select the text box we want to adjust, then right-click to select Format Object. Here we can set the fill color and border line. By selecting No Fill and No Line, the content in other cells will not be blocked.
5. Repeat step 4 and draw the rest text boxes.
To be an office excel advancers, you could learn how to use WPS Office Spreadsheet online in WPS Academy.
Was this helpful?
Yes
No
Trending Tutorials
- 1. How to get month name from a date in Excel (3 easy ways)
- 2. Check if value is in list in Excel (3 easy methods)
- 3. How to Copy File Names in Excel from a Folder?
- 4. How to color cell based on value in Excel?
- 5. How to compare two excel sheets and highlight differences
- 6. How to add text to beginning or end of all cells in Excel