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 ! |
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 ! |
All times are GMT +1. The time now is 03:09 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com