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

August 12, 2022
437 Views
0

A free Office suite fully compatible with Microsoft Office

Free Download

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.