Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
plot graph from multiple worksheet as embedded chart object on every worksheet | Charts and Charting in Excel | |||
plot graph from multiple worksheet as embedded chart object on every worksheet | Excel Discussion (Misc queries) | |||
plot graph from multiple worksheet as embedded chart object on every worksheet | Excel Worksheet Functions | |||
plot graph from multiple worksheet as embedded chart object on every worksheet | New Users to Excel | |||
Upload multiple text files into 1 excel worksheet + put the filename as the first column in the worksheet | Excel Worksheet Functions |