If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Center across selection frustrations
Example
Type in "miles" in cell a1 Center across selection a1:B1 Copy a1:B1 to c1 Delete c1 The center across selection changes for (a1:B1 - now is A11) aargh! How can I stop this? |
#2
|
|||
|
|||
Center across selection frustrations
Delete c1 will remove only the text but not the text alignment format. You
will have to set the horizontal alignment of C11 back to General (FormatCellsAlignment) If your intention is to copy the text alone you could have --Instead of copying A1:B1; copy cell A1 to C1 --Even if you copy A1:B1 togetther paste special values to C1 If this post helps click Yes --------------- Jacob Skaria "Brad" wrote: Example Type in "miles" in cell a1 Center across selection a1:B1 Copy a1:B1 to c1 Delete c1 The center across selection changes for (a1:B1 - now is A11) aargh! How can I stop this? |
#3
|
|||
|
|||
Center across selection frustrations
OR
Select C11 and from menu EditClearClear All If this post helps click Yes --------------- Jacob Skaria "Jacob Skaria" wrote: Delete c1 will remove only the text but not the text alignment format. You will have to set the horizontal alignment of C11 back to General (FormatCellsAlignment) If your intention is to copy the text alone you could have --Instead of copying A1:B1; copy cell A1 to C1 --Even if you copy A1:B1 togetther paste special values to C1 If this post helps click Yes --------------- Jacob Skaria "Brad" wrote: Example Type in "miles" in cell a1 Center across selection a1:B1 Copy a1:B1 to c1 Delete c1 The center across selection changes for (a1:B1 - now is A11) aargh! How can I stop this? |
#4
|
|||
|
|||
Center across selection frustrations
That answered my question - thanks.
I'm creating a quarterly form that the user input weekly information and the last item is to input a $ amount in a cell that would be centered across two columns. In the process of setting up the I had $ amounts in every other cells and then started to clear out the unnecessary values. Based on what you said, the only solution would be to put in a ' in every other column - because I want to retain the center across selection (but to limit it to ONLY two columns) and was trying to avoid macros (I know this wouldn't be hard). But may have to resort to this because the user might get rid of the ' (and the problem would show back up) "Jacob Skaria" wrote: Delete c1 will remove only the text but not the text alignment format. You will have to set the horizontal alignment of C11 back to General (FormatCellsAlignment) If your intention is to copy the text alone you could have --Instead of copying A1:B1; copy cell A1 to C1 --Even if you copy A1:B1 togetther paste special values to C1 If this post helps click Yes --------------- Jacob Skaria "Brad" wrote: Example Type in "miles" in cell a1 Center across selection a1:B1 Copy a1:B1 to c1 Delete c1 The center across selection changes for (a1:B1 - now is A11) aargh! How can I stop this? |
Thread Tools | |
Display Modes | |
|
|