A text box, picture, table, or shape that you can select and then move and resize

The first three options will work with photos/images as well as shapes.

A text box, picture, table, or shape that you can select and then move and resize

To move it, click on it, hold, and then drag it to the desired location.

To resize it, click and drag one of the little squares that appear in the corners. Hold down the Shift key before you start dragging the corner to keep the image proportionate. Note that depending on the file type, your image may become distorted if you make it bigger.

To rotate the image/shape, click and drag on the circle at the top.

A text box, picture, table, or shape that you can select and then move and resize

To modify the proportions of a shape, click, hold, and drag one of the yellow squares that appear on the shape. 

To change the color (inside or out), use the appropriate Fill (inside) or Outline (line around the image) options in the Shape (or Picture) Format Ribbon or at the right of the Home Ribbon. If you want just the outline of a shape, choose No fill from the dropdown menu.

A text box, picture, table, or shape that you can select and then move and resize

To add text to a shape, right-click and choose Edit Text…. A cursor appears in the shape - start typing. The text will automatically fit inside the shape. To edit or modify the text (color, size, font, etc.), highlight the text and make the change.

Numerous users face a problem when, after inserting, deleting, and resizing some cells on a spreadsheet, Excel changes the dimensions of a chart, the position of a shape or image, etc. Objects in Excel are positioned on the drawing layer that covers cells on a worksheet.

Moving, resizing, coping, and deleting objects on the drawing layer do not affect other worksheet elements. But, moving, resizing, coping, and deleting certain cells (related cells - located to the left, above, or covered by the object, even partially) in the worksheet affect the objects:

  • Objects, such as a picture, have a default setting that keeps the object's dimensions and simply moves the object if the cells above or to the left of its bottom right corner are resized:

    A text box, picture, table, or shape that you can select and then move and resize

  • Other objects, such as a chart, are resized automatically after resizing, moving, or deleting any of the related cells:

    A text box, picture, table, or shape that you can select and then move and resize

To fix the object dimensions or freeze an object on the spreadsheet, do the following:

   1.   Right-click on the object, then select Format ***... in the popup menu (or double-click the object to open the Format *** pane).

*** varies depending on the object. For example:

  • Right-click on the picture or shape, then select the Format Picture... or Format Shape... in the popup menu:

    A text box, picture, table, or shape that you can select and then move and resize
      or  
    A text box, picture, table, or shape that you can select and then move and resize

  • Right-click on the chart area, then select Format Chart Area... in the popup menu (or double-click the chart border):

    A text box, picture, table, or shape that you can select and then move and resize

   2.   On the Format *** pane, in the Size & Properties group, in the Properties section, select the option you prefer:

A text box, picture, table, or shape that you can select and then move and resize
  or  
A text box, picture, table, or shape that you can select and then move and resize

  • Move and size with cells (selected by default for charts, shapes, SmartArt diagrams, and text boxes): If this option is selected, the object can be automatically resized and moved after changes of the related cells:
    • If you move, resize, add, or delete cells above or on the left of the object, it automatically moves,
    • If you move, resize, add, or delete cells behind or partially covered cells, the object automatically resizes.

    For example:

    • For a shape, picture, or text box: after resizing cells, it moves and resizes the shape:

      A text box, picture, table, or shape that you can select and then move and resize

    • For the chart on a spreadsheet (see how to create a chart on a separate spreadsheet):

      A text box, picture, table, or shape that you can select and then move and resize

      Adding a new column and resizing cells moves and resizes the chart:

      A text box, picture, table, or shape that you can select and then move and resize

  • Move but don't size with cells (selected by default for pictures): If this option is selected, the object moves automatically but does not change its size after moving, resizing, adding, or deleting related cells.

    For example:

    • For a shape, picture, or text box: resizing cells changes the object position but doesn't resize the shape:

      A text box, picture, table, or shape that you can select and then move and resize

    • For the chart: adding a new column on the left and resizing cells behind the chart moves the chart but doesn't change its dimensions:

      A text box, picture, table, or shape that you can select and then move and resize

  • Don't move or size with cells: This option makes the object completely independent of the cells and freezes the object on the spreadsheet.

    For example:

    • For a shape, picture, or text box: resizing cells doesn't change the object and its position on the spreadsheet:

      A text box, picture, table, or shape that you can select and then move and resize

    • For the chart: adding a new column on the left and resizing cells behind the chart doesn't change its position or dimensions:

      A text box, picture, table, or shape that you can select and then move and resize

What is the feature that moves text from the right edge of a paragraph to the beginning of the next line as necessary to fit within the margins?

Glossary.

What is the action of moving your mouse pointer over something on your screen is called?

The action of moving your mouse pointer over something on your screen is called: point. The process of making changes to text or graphics in an Office file is called: editing.

What shows the possible result of applying an editing or formatting change before you actually apply the change?

Live Preview A technology that shows the result of applying an editing or formatting change as you point to possible results—before you actually apply it.

What is the action of pressing and releasing the left button on a mouse pointing device one time is called?

Click – The act of pressing and releasing a mouse-button. Unless otherwise specified, such as in a double-click or a right-click, this term refers strictly to pressing the left mouse button once. See Double-click, Right- click. Close – To end work in a program or file.