i am using excel 2002.
(problem #1)
I copy a small area with 3 columns and 15 rows and then paste it into a new blank worksheet.
but then when i try to insert new columns or rows into the pasted area - the shaded area indicating the area where i want the insert shows up in the area beyond the pasted area, but not in the pasted area and will not insert.
(problem #2)
Some cells have invisible links attached to them.
when i copy the area i see moving dashed lines which encompass areas of varying size - sometimes one row, sometimes multiple rows.
Then if I past the area into a blank area, using 'special pasting' with 'values' chosen - the pasted copy is all mixed up, having no relationship to the original copied area. how can i eliminate the unwanted invisible links?
Bookmarks