InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
How Can You Increase The Number Of Rows And Columns In A Worksheet? |
|
Answer» The amount of ROWS in a worksheet is fixed i.e 1,048,576 , so you cannot increase the amount of rows. What you can do is insert rows into part of a SPREADSHEET. It will have the effect of pushing rows down, but it will not increase the amount of rows in the worksheet.And same with COLUMNS they are also fixed(16384) it's not possible to increase,you can start a new Excel workbook and TRANSFER your data. The amount of rows in a worksheet is fixed i.e 1,048,576 , so you cannot increase the amount of rows. What you can do is insert rows into part of a spreadsheet. It will have the effect of pushing rows down, but it will not increase the amount of rows in the worksheet.And same with columns they are also fixed(16384) it's not possible to increase,you can start a new Excel workbook and transfer your data. |
|