Click the Insert icon in the Cells group.Click the Home tab and then click the row or column heading where you want to add another row or column.To add a row or column, follow these steps: Adding and deleting rows and columnsĪfter you type in labels, numbers, and formulas, you may suddenly realize that you need to add or delete extra rows orĬolumns.

(A cell defined as 1 character width can display a single letter or number.)Įxcel measures row height by points where 1 point equals 1/ 72 inch. Excel resizes your row or column.Įxcel measures column width in characters. The Row Height or Column Width dialog box appears. Row) or Width (if you selected a column). A pull-down menu appears and then click Height (if you selected a Click the Format icon that appears in the Cells group.Excel highlights your entire row or column. Click the Home tab and then click the row or column heading that you want to resize.To type a value into a Row Height or Column Width dialog box, follow these steps: If you need to resize a row or column to a precise value, it is easier to type a specific value into the Row Height orĬolumn Width dialog box instead. Release the left mouse button when you are happy with the size of your row or column.Hold down the left mouse button and drag (move) the mouse.Over the right line of the column heading, such as A or D.) The mouse pointer turns into a two-way pointing arrow. Move the mouse pointer over the bottom line of a row heading, such as the 2 or 18 heading.To change the height of a row or the width of Using the mouse can be a quick way to modify the sizes of rows and columns. Changing the size of rows and columns with the mouse The Formula bar, which can be more convenient for editing large amounts of data. If you click a cell, Excel displays the contents of that cell in the Formula bar.Edit your data by using the Backspace or Delete key, or by typing new data.Excel displays a cursor in your selected cell. Double-click the cell that contains the data you want to edit.To edit data in a single cell, follow these steps: Edit the physical layout of the spreadsheet, such as adding or deleting rows and columns, or widening or shrinking the.Edit the data itself, such as the labels, numbers, and formulas that make up a spreadsheet.

How to edit on excel spreadsheet