Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel Limitation - Inserting Colums - Help
Having difficulties inserting columes into a document.
Error received To prevent possible loss of data non blank cells , Microsoft Excel cannot shift non blank cells off the worksheet. Any siggestions. many thanks Tim -- Help is always there..youv just got to look for it ! |
#2
|
|||
|
|||
Hi Tim
it sounds like a cell somewhere has got a space in it .. press CONTROL & END and see where you go ... then i would recommend deleting all the columns from your last real entry to that entry & same with the rows and then closing & saving the workbook. When you reopen it it should work fine ... check out http://www.contextures.com/xlfaqApp.html#unused for more details -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "Tim Harding" wrote in message ... Having difficulties inserting columes into a document. Error received To prevent possible loss of data non blank cells , Microsoft Excel cannot shift non blank cells off the worksheet. Any siggestions. many thanks Tim -- Help is always there..youv just got to look for it ! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
quattro pro converter Excel 2003 | New Users to Excel | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
Inserting the date that an excel sheet is saved into a cell | Excel Discussion (Misc queries) | |||
Limitation of Autofiltr option in Excel | Excel Worksheet Functions |