ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel Limitation - Inserting Colums - Help (https://www.excelbanter.com/excel-discussion-misc-queries/24139-excel-limitation-inserting-colums-help.html)

Tim Harding

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 !

JulieD

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