Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
have a spreadsheet made but it wont let me add additional column
i have a worksheet already made up but when i try to add a column it says not
able to due to data |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
have a spreadsheet made but it wont let me add additional column
"mari-claire" wrote in message
... i have a worksheet already made up but when i try to add a column it says not able to due to data If you have something in column IV (the 256th, or last, column) and you try to insert another column you will get a message: "To prevent possible loss of data, Microsoft Excel cannot shift nonblank cells off the worksheet." Is this what you mean? If so, you need to delete some data to free up at least one column. You can use CTRL+END to take you to the last used cell. This will show you if you have anything in column IV. Perhaps you have something there that you didn't mean to have. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF/AND/OR/DATEIF Issue...sorry...long post... | Excel Worksheet Functions | |||
match and count words | Excel Worksheet Functions | |||
Lookup Table Dilemma | Excel Worksheet Functions | |||
flip spreadsheet data from row records to column record fields | Excel Discussion (Misc queries) | |||
up to 7 functions? | Excel Worksheet Functions |