| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 A1:D1) aargh! How can I stop this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 C1:D1 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 A1:D1) aargh! How can I stop this? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Center across selection frustrations
OR
Select C1:D1 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 C1:D1 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 A1:D1) aargh! How can I stop this? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 C1:D1 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 A1:D1) aargh! How can I stop this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Merge and Center and Center Accross Selection | New Users to Excel | |||
| Center across selection | Excel Discussion (Misc queries) | |||
| center across the selection | New Users to Excel | |||
| Center Across Selection Vertically Help. I am trying to center te. | Excel Discussion (Misc queries) | |||
| How do I UN Center a Selection | Excel Discussion (Misc queries) | |||
Hybrid Mode
