Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro Help- Inserting Blank Rows | Excel Discussion (Misc queries) | |||
Macro needed for inserting blank rows | Excel Worksheet Functions | |||
putting a (.) period in blank cells when pasting data | Excel Worksheet Functions | |||
enter numbers in blank cells | Excel Worksheet Functions | |||
blank cells | Excel Discussion (Misc queries) |