#Paste list into excel rows not column series#

To preserve memory, Fill is limited to an area of 127 rows by 31 columns. Autofill takes the content of the first cell in the selected row or column and copies it down or across the rest of the selection. With Autofill you can quickly fill cells with repetitive data such as numbers or repeated text.

If you selected Date or Number, in Step value, select the increment you want.

#Paste list into excel rows not column series#

In Series type, tap the type of series you want, Autofill, Date, or Number.In Direction, tap the direction you want.In an Excel Mobile workbook, select both the range containing the data you want to reference and the adjacent destination cells.The result appears in the AutoCalculate area. Tap the AutoCalculate arrow and tap the type of calculation you want to perform.The AutoCalculate area, on the right side of the status bar, contains a function and a value, for example: SUM=0. Select the range of values you want to calculate.In an Excel Mobile workbook, tap View > Status Bar.You can quickly calculate the largest number, smallest number, average number, and sum of the numbers in a selected range of values. To specify an exact column width and row height, tap and hold the column or row, tap Format Cells and enter the measurements on the Size tab. If you selected a row or rows, adjust the height by dragging the lower border in the row heading.If you selected a column or columns, adjust the width by dragging the right border of the column heading.In an Excel Mobile workbook, select the column or row you want to change.Tap View > Zoom and select a percentage so that you can easily read the worksheet. Work in full-screen mode to see as much of your workbook as possible. You can easily rename the workbook with a more meaningful name and move it to another folder or a storage card. When you close a newly created workbook, it is automatically named and placed in the Excel Mobile workbook list. Freeze the top and left-most panes in a worksheet to keep row and column labels or other data visible as you scroll through a sheet.Split panes to view different parts of a worksheet at the same time.Enter formulas and functions, and then filter data to see the subset of information you want.

View, edit, and create charts and graphs, which can be embedded as objects in a worksheet or placed on a separate worksheet.Not only can you edit Excel workbooks and templates created on your PC, you can create and edit workbooks and templates on your device with Excel Mobile. Pocket Excel Help Overview of Excel Mobile