Text Boxes
Text boxes are special graphic objects that combine the text with a rectangular graphic object. Text boxes and cell comments are similar in displaying the text in rectangular box. But text boxes are always visible, while cell comments become visible after selecting the cell.
Adding Text Boxes
To add a text box, perform the below actions.
Choose Insert » Text Box » choose text box or draw it.
Initially, the comment consists of Computer's user name. You have to modify it with text for the cell comment.
Formatting Text Box
After you have added the text box, you can format it by changing the font, font size, font style, and alignment, etc. Let us see some of the important options of formatting a text box.
Undo Changes
You can reverse the effects of the past 100 actions that you performed by executing Undo more than once. If you click the arrow on the right side of the Undo button, you see a list of the actions that you can reverse. Click an item in that list to undo that action and all the subsequent actions you performed.
Redo Changes
You can again reverse back the action done with undo in Excel by using the Redo command. We can redo changes in following two ways.
From the Quick access tool-bar » Click Redo.
Press Control + Y.
Text boxes are special graphic objects that combine the text with a rectangular graphic object. Text boxes and cell comments are similar in displaying the text in rectangular box. But text boxes are always visible, while cell comments become visible after selecting the cell.
Adding Text Boxes
To add a text box, perform the below actions.
Choose Insert » Text Box » choose text box or draw it.
Initially, the comment consists of Computer's user name. You have to modify it with text for the cell comment.
After you have added the text box, you can format it by changing the font, font size, font style, and alignment, etc. Let us see some of the important options of formatting a text box.
- Fill − Specifies the filling of text box like No fill, solid fill. Also specifying the transparency of text box fill.
Line Colour − Specifies the line colour and transparency of the line.
Line Style − Specifies the line style and width.
Size − Specifies the size of the text box.
Properties − Specifies some properties of the text box.
Text Box − Specifies text box layout, Auto-fit option and internal margins.
- You can reverse almost every action in Excel by using the Undo command. We can undo changes in following two ways.
From the Quick access tool-bar » Click Undo.
Press Control + Z.
Redo Changes
You can again reverse back the action done with undo in Excel by using the Redo command. We can redo changes in following two ways.
From the Quick access tool-bar » Click Redo.
Press Control + Y.
0 Comments