ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Move Column Retain Formula (https://www.excelbanter.com/excel-discussion-misc-queries/189286-move-column-retain-formula.html)

mslv

Move Column Retain Formula
 
Excel adds coumns b,c,&d and enters the total into column d. I need to move
column d to column a. How can I copy or move column d and still retain the
formula to total it there? Thanks.

PCLIVE

Move Column Retain Formula
 
Highlight your column. Then move your mouse pointer to the edge of the
highlighted section (on the black border). Your pointer should turn to a
four way arrow. Click and hold. Now drag to the desired location. Your
formulas should remain in tact.

HTH,
Paul

--

"mslv" wrote in message
...
Excel adds coumns b,c,&d and enters the total into column d. I need to
move
column d to column a. How can I copy or move column d and still retain
the
formula to total it there? Thanks.





All times are GMT +1. The time now is 05:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com