#1
|
|||
|
|||
Spreadsheet seems confused--copy to clean sheet?
I haven't run into a similar problem previously.
Manifestations: 1. Format column to wrap text. Copy text from existing cell to new within column. Text does not wrap. Right click/Format/Align--wrap is checked. If I uncheck then check, the cell wraps. 2. Create a 'Sum of' in a cell encompassing ~ 1/2 dozen cells above, 2 of which have values, the Sum cell correctly indicates the range Sum value. However, copy a value from another cell and paste within the referenced Sum range, the Sum does not automatically reflect the addition. If I then click on the menu bar Sum function to overwrite that which is not working and paste to the cell, then click to expand the range to what was initially established Excel's reaction is strange. The dotted line range indicator will instantaneously, correctly go to the top of the column range but then 'snaps' back in an instant to encompass just the first value of the column range. Is there a way that I can copy the contents of this sheet to a new sheet but not bring along whatever is causing the above irregularities? Thanks, Mark |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to copy excel sheet withe HEADER and Paste into new sheet? | cloudforgiven | Excel Programming | 6 | 01-05-2017 07:30 PM |
How to send "clean" copy after tracking/ redlining changes in review mode | lindapaul | Word | 2 | 06-09-2016 02:34 PM |
Find matching criterior in sheet 1 and copy to Sheet 2 | Auto | Excel Programming | 3 | 03-19-2016 01:41 PM |
Macro to copy specific columns in Excel from another spreadsheet | KD999 | Excel Programming | 1 | 07-20-2012 08:58 AM |
copy cell from sheet 2 to sheet 3 macro | slipperyjim | Excel Programming | 1 | 02-18-2010 01:31 AM |