#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default End of Worksheet

Has any one experienced not being able to put in any more columns in their
worksheet? I'm at IV and when I try to enter more columns I get the message
that I am at the end of the worksheet.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,268
Default End of Worksheet

I have never used that many columns but yes, unless you have excel 2007 you
are at the end of the worksheet, nothing can change that


--
Regards,

Peo Sjoblom


"Ninfa" wrote in message
...
Has any one experienced not being able to put in any more columns in their
worksheet? I'm at IV and when I try to enter more columns I get the
message
that I am at the end of the worksheet.



  #3   Report Post  
Posted to microsoft.public.excel.misc
LT LT is offline
external usenet poster
 
Posts: 25
Default End of Worksheet

On May 4, 3:31 pm, Ninfa wrote:
Has any one experienced not being able to put in any more columns in their
worksheet? I'm at IV and when I try to enter more columns I get the message
that I am at the end of the worksheet.


Yes, IV is the last column available to you. You only get 256
columns. You may want to try and transpose your work from columns to
rows.

Select your row lable fields, choose copy, then select where you want
your fields to go in a list format. choose paste special, then
transpose. All your columns will now be in one column.

Make:
Model:
Type:
Year:
Exported:
Etc.

Hope that helps!

-LT

  #4   Report Post  
Posted to microsoft.public.excel.misc
bj bj is offline
external usenet poster
 
Posts: 1,397
Default End of Worksheet

for anything except 2007 you are.

You will probably have to change your format of how you want to put things
together

"Ninfa" wrote:

Has any one experienced not being able to put in any more columns in their
worksheet? I'm at IV and when I try to enter more columns I get the message
that I am at the end of the worksheet.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
plot graph from multiple worksheet as embedded chart object on every worksheet [email protected] Charts and Charting in Excel 3 August 24th 06 07:26 PM
plot graph from multiple worksheet as embedded chart object on every worksheet [email protected] Excel Discussion (Misc queries) 2 August 24th 06 05:26 PM
plot graph from multiple worksheet as embedded chart object on every worksheet [email protected] Excel Worksheet Functions 2 August 24th 06 05:26 PM
plot graph from multiple worksheet as embedded chart object on every worksheet jeftiong New Users to Excel 0 August 23rd 06 01:50 PM
Upload multiple text files into 1 excel worksheet + put the filename as the first column in the worksheet Aster Excel Worksheet Functions 3 March 12th 06 09:58 AM


All times are GMT +1. The time now is 05:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"