| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there an easy way to switch the contents of cells in Excel?
I'd like to be able to switch the contents of cells, say between column A to
column B, without having to move the contents of column A to C, moving contents of B to A and then moving contents from C to B. Is there an easy way to do this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Is there an easy way to switch the contents of cells in Excel?
Say you want to swap A1 to A10 with B1 to B10, and leave A11 to B100
untouched. Select A1:A10, Right click and choose "Cut", Right click in C1 and choose "Insert Cut Cells", And you're done! -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Susan" wrote in message ... I'd like to be able to switch the contents of cells, say between column A to column B, without having to move the contents of column A to C, moving contents of B to A and then moving contents from C to B. Is there an easy way to do this? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Is there an easy way to switch the contents of cells in Excel?
Move the information from column A to column C and then delete column A
-- Wag more, bark less "Susan" wrote: I'd like to be able to switch the contents of cells, say between column A to column B, without having to move the contents of column A to C, moving contents of B to A and then moving contents from C to B. Is there an easy way to do this? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Is there an easy way to switch the contents of cells in Excel?
Cool!!
Never would have come up with that. Gord On Thu, 19 Jun 2008 12:44:50 -0700, "RagDyer" wrote: Say you want to swap A1 to A10 with B1 to B10, and leave A11 to B100 untouched. Select A1:A10, Right click and choose "Cut", Right click in C1 and choose "Insert Cut Cells", And you're done! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Is there an easy way to switch the contents of cells in Excel?
This is way easier than my suggested approach!
-- Wag more, bark less "RagDyer" wrote: Say you want to swap A1 to A10 with B1 to B10, and leave A11 to B100 untouched. Select A1:A10, Right click and choose "Cut", Right click in C1 and choose "Insert Cut Cells", And you're done! -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Susan" wrote in message ... I'd like to be able to switch the contents of cells, say between column A to column B, without having to move the contents of column A to C, moving contents of B to A and then moving contents from C to B. Is there an easy way to do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there an easy way to swap the contents of two cells in Excel? | Excel Discussion (Misc queries) | |||
| Allow user to "switch" contents of two boxes in Excel | Excel Worksheet Functions | |||
| Easy Printer Switch Question | Excel Discussion (Misc queries) | |||
| How easy is it to loop in VBA based on cell contents? | Excel Worksheet Functions | |||
| Excel should provide an easy way to switch a column into a row, n. | Excel Discussion (Misc queries) | |||
Linear Mode
