ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   copying sheets (https://www.excelbanter.com/excel-discussion-misc-queries/86983-copying-sheets.html)

fastballfreddy

copying sheets
 

I want to copy and paste a sheet into a new sheet, but I want to keep
the settings the same, like the column width. Is this possible?

Thanks,


--
fastballfreddy
------------------------------------------------------------------------
fastballfreddy's Profile: http://www.excelforum.com/member.php...o&userid=33986
View this thread: http://www.excelforum.com/showthread...hreadid=539174


Gazzr

copying sheets
 

Hi there,

Right click on tab name (Sheet1)

Select "Move or Copy", select the location where you want the sheet to
go. Tick the "Make a copy" button at the bottom and click OK

Everything should stay the same.

Thanks
Gazzr


--
Gazzr
------------------------------------------------------------------------
Gazzr's Profile: http://www.excelforum.com/member.php...o&userid=31075
View this thread: http://www.excelforum.com/showthread...hreadid=539174


James Hamilton

copying sheets
 
I think I know what you want....

On the sheet tab (eg "sheet 1"), right click, choose MOVE OR COPY, and go
from there.

"fastballfreddy" wrote:


I want to copy and paste a sheet into a new sheet, but I want to keep
the settings the same, like the column width. Is this possible?

Thanks,


--
fastballfreddy
------------------------------------------------------------------------
fastballfreddy's Profile: http://www.excelforum.com/member.php...o&userid=33986
View this thread: http://www.excelforum.com/showthread...hreadid=539174




All times are GMT +1. The time now is 12:44 PM.

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