|
|
|
|
New Member
|
|
Jan 5, 2008, 07:18 AM
|
|
Inserting Multiple Columns in Excel
I am working on a very large spreadsheet. I am trying to insert additional columns into the worksheet and I keep getting an error message referring me to cell A2. This spreadsheet is very large and to the right of the last column the area is greyed out. When I try to insert columns in front of prior columns is when I receive the message. It is as if I have run out of columns on the spreadsheet. What can I do to fix this?
|
|
|
Uber Member
|
|
Jan 5, 2008, 10:57 AM
|
|
Try clicking at the top of the greyed out columns and deleting them. Then you should then be able to add columns into the spot where you want to add them. Even in big spreadsheets it is hard to run out of more columns. You might also want to check the page layout mode and adjust the blue dotted line over to the right.
|
|
|
New Member
|
|
Jan 6, 2008, 09:00 AM
|
|
twinkiedooter, I tried your recommendations and I am still having the same issue. My last column is IV, there is no header IW for me to perform your recommended action (clicking at the top of the greyed out columns and deleting them). I also moved the blue dotted line and it will not go into the greyed area, it stops at the solid blue line to the right of column IV. The specific message I receive reads "cannot shift nonblank cells off the worksheet, locate the last nonblank cell by pressing CTL+End and delete or clear all cells between the last cell and the end of my data. then select A1 and save workbook to reset last cell used". I have tried this also and have been unsuccessful.
|
|
|
New Member
|
|
Jan 6, 2008, 03:21 PM
|
|
Originally Posted by twinkiedooter
Try clicking at the top of the greyed out columns and deleting them. Then you should then be able to add columns into the spot where you want to add them. Even in big spreadsheets it is hard to run out of more columns. You might also want to check the page layout mode and adjust the blue dotted line over to the right.
Please respond to my post. Thanks.
|
|
|
Uber Member
|
|
Jan 6, 2008, 04:40 PM
|
|
I'm a pretty good excel tech and in this case I'd open a brand new excel sheet, copy and paste the old one into the new one and try to insert columns into the new sheet. Don't worry about the headers being off format wise just now). If this works, then just keep the new sheet that you made the "improvements" on. Sometimes it works, and sometimes it take a bit of "tricking the program into doing what I want it to do". I've been playing with computer programs since 1982 and have learned a few tricks here and there that sometimes work (even though they are not in the help manuals).
Keep the original spreadsheet in a secure area and then experiment with different with the "clones" all you wish. Trust me, you can't mess up the clone if you save the original properly. If your clone works, then however you had the original sheet set up you can always readjust the headers to your cloned version and have them properly spaced out, etc.
|
|
|
Computer Expert and Renaissance Man
|
|
Jan 6, 2008, 04:48 PM
|
|
Ok, First, IV is the lastmost column in a spreadsheet for Excel 2K-2003. What it sounds like is you have some data in that column which will prevent you from inserting columns. Do you actually have data in Column IV? How did you try to delete all the data as instructed?
|
|
|
New Member
|
|
Jan 7, 2008, 09:26 AM
|
|
Thanks for your help ScottGem and twinkiedooter. I have found out that I have reached the maximum columns in excel and have to create another worksheet to continue.
|
|
|
Computer Expert and Renaissance Man
|
|
Jan 7, 2008, 09:52 AM
|
|
Excel 2003 gives you 256 columns. I wonder what type of data are you working with that requires 256 columns?
|
|
|
New Member
|
|
Jan 7, 2008, 05:37 PM
|
|
Document for work.
|
|
|
Computer Expert and Renaissance Man
|
|
Jan 7, 2008, 08:21 PM
|
|
That really doesn't tellme anything. You don't use Excel for a document, You use it for data.
|
|
|
New Member
|
|
Jan 8, 2008, 05:33 AM
|
|
Sorry that I cannot be more specific. The information is of a confidential nature however it is data. Again, thank you for your help.
|
|
|
Computer Expert and Renaissance Man
|
|
Jan 8, 2008, 06:31 AM
|
|
All right. I'm not really asking for the data itself, just an idea. The reason I ask is that I strongly suspect that you have a problem in the way you have structured your workbook to have used all 256 column. That you might be able to make it work more efficiently.
|
|
Question Tools |
Search this Question |
|
|
Add your answer here.
Check out some similar questions!
2 Columns
[ 15 Answers ]
Having a problem with 2 columns... for some reason it writes some of it in the first column, then the bit following in the second column, then goes back to the first column.
I've tried switching to 1 column and back to 2 and the formatting stays that way. Help! :D:confused:
Inserting a row in Excel
[ 3 Answers ]
I am trying to insert a row and keep getting this error message that it cannot shift non blank cells off worksheet. I have never seen this before and never had a problem inserting a row, what do I do.
Inserting multiple columns on Excel
[ 2 Answers ]
Can anyone help me to insert multiple columns under any particular cell without disturbing other cell data ?
For example it should be like :
---------------------------------------------------------
| A | B | C |...
View more questions
Search
|