LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default Having Trouble Inserting a Column

Hoping someone can help me with this......

In Excel 2003 working in a spreadsheet, I cannot insert a new column. I get
this error message:

'To prevent possible loss of data Microsoft Office Excel cannot shift
nonblank cells off the worksheet.'

'Try to locate the last nonblank cell by pressing CTRL & END and delete or
clear all in cells between the last cell and the end of your data. Then
select cell A1 and save your workbook to reset your last cell used.'

'Or you can move your data to a new location and try again.'

I did try to move the spreadsheet into another blank page and it still did
not work.
--
Elisa
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Column Comparison Trouble RH Excel Worksheet Functions 2 November 1st 07 01:55 AM
Inserting a column Diane Goncalves[_2_] Excel Discussion (Misc queries) 1 March 8th 07 10:48 PM
inserting new column newyorkjoy Excel Discussion (Misc queries) 0 March 8th 07 08:22 PM
Inserting row/Column d_kight Excel Discussion (Misc queries) 1 December 11th 06 06:20 PM
Trouble returning to Normal view after inserting a header and foot Eazy-E Excel Worksheet Functions 0 July 26th 06 11:58 PM


All times are GMT +1. The time now is 04:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"