ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   resize worksheet (https://www.excelbanter.com/excel-discussion-misc-queries/4263-resize-worksheet.html)

Andrea

resize worksheet
 
I have way to many columns(need aprox. 200 - not 65536) But there are to few
rows. I need the entiere alphabet 3 times. Is it possible to resize the
worksheet?

Jan Karel Pieterse

Hi Andrea,

I have way to many columns(need aprox. 200 - not 65536) But there are to few
rows. I need the entiere alphabet 3 times. Is it possible to resize the
worksheet?


Nope, that is not possible. You should consider transposing your data
(exchanging rows and columns).

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com


Gord Dibben

Andrea

I think you have rows and columns mixed up.

There are 65536 rows and 256 columns.

These numbers cannot be changed.

The entire alphabet 3 times would be 3*26 = 78

What's the problem?


Gord Dibben Excel MVP

On Thu, 20 Jan 2005 04:19:07 -0800, Andrea
wrote:

I have way to many columns(need aprox. 200 - not 65536) But there are to few
rows. I need the entiere alphabet 3 times. Is it possible to resize the
worksheet?




All times are GMT +1. The time now is 01:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com