LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default inserting a blank row

I have a 165 row 10 column worksheet. I have been able to insert blank rows
before by right mouse clicking and choosing insert. Now when I try that I
get this message: "To prevent possible loss of data, Excel can't shift
nonblank cells off the worksheet. Try to locate the last non blank cell by
pressing CNTRL+End (I have no end key on my keyboard) and delete or clear all
cells between the last cell and the end of your data. Then select A1 and
save your workbook to reset the last cell used." I don't understand what
this message means and I need to insert blank rows on that sheet. Please,
anyone, help. Using Office Edition 2003.


 
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
Macro Help- Inserting Blank Rows jack Excel Discussion (Misc queries) 3 January 16th 07 09:43 PM
Macro needed for inserting blank rows sunslight Excel Worksheet Functions 2 January 12th 07 05:58 PM
putting a (.) period in blank cells when pasting data nospam Excel Worksheet Functions 8 December 19th 06 01:20 AM
enter numbers in blank cells bill gras Excel Worksheet Functions 2 September 21st 05 01:17 PM
blank cells R.VENKATARAMAN Excel Discussion (Misc queries) 1 April 6th 05 10:25 AM


All times are GMT +1. The time now is 08:51 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"