When I press Control End the cursor goes to final maximum cell of the
worksheet. I can't understand why. I have tried deleting the rows and columns
but that doesn't work. I am running a conversion program that reads every
active cell. In the above scenario, it takes it too long to read upto row
65k+, and for each column. So, how can I reduce the actual size of the
worksheet to say 10 columns and 100 rows? Hiding/Grouping doesn't work.
Thanks.

To reduce the actual size of the worksheet to 10 columns and 100 rows, you can follow these steps:

1. Select the row number below the 100th row that you want to delete.
2. Hold down the Shift key and select the last row number in your worksheet.
3. Right-click on any of the selected row numbers and choose "Delete" from the context menu.
4. A dialog box will appear asking you to confirm the deletion of the selected rows. Choose "Delete entire row" and click "OK".
5. Similarly, select the column letter to the right of the 10th column that you want to delete.
6. Hold down the Shift key and select the last column letter in your worksheet.
7. Right-click on any of the selected column letters and choose "Delete" from the context menu.
8. A dialog box will appear asking you to confirm the deletion of the selected columns. Choose "Entire column" and click "OK".

This will delete all the rows and columns beyond the 100th row and 10th column, respectively. This will reduce the size of your worksheet and make it easier for the conversion program to read every active cell.

You need to save the file after deleting the unused rows and columns -
Debra Dalgleish has some more notes he

http://www.contextures.com/xlfaqApp.html#Unused

You cannot actually reduce the number of rows and columns - you can
hide them, but they are still there.

Hope this helps.

Pete

On Jun 26, 10:53*am, Faisal wrote:
When I press Control End the cursor goes to final maximum cell of the
worksheet. I can't understand why. I have tried deleting the rows and columns
but that doesn't work. I am running a conversion program that reads every
active cell. In the above scenario, it takes it too long to read upto row
65k+, and for each column. So, how can I reduce the actual size of the
worksheet to say 10 columns and 100 rows? Hiding/Grouping doesn't work.
Thanks.

Thanks, Pete. At least, got the desired result.

"Pete_UK" wrote:

You need to save the file after deleting the unused rows and columns -
Debra Dalgleish has some more notes he

http://www.contextures.com/xlfaqApp.html#Unused

You cannot actually reduce the number of rows and columns - you can
hide them, but they are still there.

Hope this helps.

Pete

On Jun 26, 10:53 am, Faisal wrote:
When I press Control End the cursor goes to final maximum cell of the
worksheet. I can't understand why. I have tried deleting the rows and columns
but that doesn't work. I am running a conversion program that reads every
active cell. In the above scenario, it takes it too long to read upto row
65k+, and for each column. So, how can I reduce the actual size of the
worksheet to say 10 columns and 100 rows? Hiding/Grouping doesn't work.
Thanks.

You're welcome - what did you actually do in the end?

Pete

On Jun 26, 4:50*pm, Faisal wrote:
Thanks, Pete. At least, got the desired result.



"Pete_UK" wrote:
You need to save the file after deleting the unused rows and columns -
Debra Dalgleish has some more notes he

http://www.contextures.com/xlfaqApp.html#Unused

You cannot actually reduce the number of rows and columns - you can
hide them, but they are still there.

Hope this helps.

Pete

On Jun 26, 10:53 am, Faisal wrote:
When I press Control End the cursor goes to final maximum cell of the
worksheet. I can't understand why. I have tried deleting the rows and columns
but that doesn't work. I am running a conversion program that reads every
active cell. In the above scenario, it takes it too long to read upto row
65k+, and for each column. So, how can I reduce the actual size of the
worksheet to say 10 columns and 100 rows? Hiding/Grouping doesn't work.
Thanks.- Hide quoted text -

- Show quoted text -