WPS Office

Free All-in-One Office Suite with PDF Editor

correct-icon

Edit Word, Excel, and PPT for FREE.

correct-icon

Read, edit, and convert PDFs with the powerful PDF toolkit.

correct-icon

Microsoft-like interface, easy to use.

Free download

Windows • MacOS • Linux • iOS • Android

banner

How to add, resize, and remove a text box in excel

July 31, 2023
13.3K Views

Users of WPS Excel can insert or add a text box into a spreadsheet. A text box is a distinct area with adjustable bounds and positioning in your spreadsheet. At the box's edges, the text you place inside wraps to the following line.You can make a block of text that appears above, below, or next to information, graphs, or other objects by using a text box. Text boxes enable varied text positioning, assisting you in designing a more engaging and informative spreadsheet.

You can choose to adjust the text box's size or remove it after you've added one. How to insert a text box in excel is written below.

How to add a text box in excel:

1.Open WPS spreadsheet.

2.Click the Insert tab in the Ribbon.

3.Select the Text Box option under the Text option on the Insert tab's far right side.

4.Place the text box where you want it by moving the mouse pointer there. 

5.To draw the text box, click and hold the left mouse button while dragging the mouse downward and to the right.

6. The size of the text box increases as you drag the mouse further.

How to resize a text box in excel:

1.The text box's Excel spreadsheet should be opened.

2.To choose a text box, locate it and click its outer edge. There are little circles on the text box's corners and in the centre of each side that appear when it is chosen.

3.Place the mouse pointer over one of the outermost or corner circles of the text box to for the cursor to transform into a double-headed arrow.

4.To expand or contract the text box, press and hold the left mouse button on the circle and then move the mouse pointer in that direction.

How to remove a text box in excel:

1.The text box's Excel spreadsheet should be opened.

2.To choose a text box, locate it and click its outer edge. 

3.There are little circles on the text box's corners and in the centre of each side that appear when it is chosen.To delete the text box from the spreadsheet, use the keyboard's Backspace or Del keys.

Note: This above written article is an attempt to show you how to add, resize and remove a text box in excel online, 2016 and 2019, in both windows and mac.You just need to have a little understanding of how and which way things work and you are good to go. With having this basic knowledge or information of how to use it, you can also access and use different other options on excel or spreadsheet. Also, it is very similar to Word or Document. So, in a way, if you learn one thing, like Excel, you can automatically learn how to use Word as well because both of them are very similar in so many ways. If you want to know more about WPS Office, you can download WPS Office to access, Word, Excel, PowerPoint for free.                                    

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.