ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   copy over just columns and headers (https://www.excelbanter.com/setting-up-configuration-excel/99400-copy-over-just-columns-headers.html)

lbierer

copy over just columns and headers
 
How can I transfer columns and headers from several worksheets to another
with out having to copy and paste everything?

Dave Peterson

copy over just columns and headers
 
Maybe just copy the whole sheet?

edit|move or copy sheet
(check that box at the bottom)

Or you can ctrl-click the worksheet tab and drag to its new copied location.

lbierer wrote:

How can I transfer columns and headers from several worksheets to another
with out having to copy and paste everything?


--

Dave Peterson


All times are GMT +1. The time now is 11:57 PM.

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