Excel automatically updates any references in the workbook to the cells that shift to accommodate the insertion.

Drag the handle upward to make the row shorter or downward to make the row taller.Īfter you populate a data range or table, you can easily insert additional columns or rows into the range or table without overwriting existing data existing columns shift to the right and rows shift down.Notice the handle that appears below the row heading. In this tutorial you will learn how to open and edit the information in Excel for iPhone contained in an already created document.Also check an iPad version. Drag the handle to the left to make the column narrower or to the right to make the column wider.Notice the handle that appears on the right side of the column heading.

Select the column or row, and then tap AutoFit on the shortcut bar. You can’t display or set the specific column width or row height measurements in Excel for iPad you can adjust them only by dragging or by using the AutoFit feature.

View excel on iphone