| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy formats and formulae from 1 worksheet to all worksheets in f
How to Copy formats and formulae from 1 worksheet to all worksheets in an
Excel file |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy formats and formulae from 1 worksheet to all worksheets in f
select all, copy, right-click sheet tab and "select all sheets", select upper
left cell of whatever sheet you're on, alt-e, S, F, enter. Then again alt-e, S, T, enter. What you'll do is copy the entire first sheet, then tell Excel that what you're about to do, it should do in the exact same way to all sheets. Then you'll be special pasting first the formulae, then the formats, into all sheets. -- Boris "BillFitz" wrote: How to Copy formats and formulae from 1 worksheet to all worksheets in an Excel file |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to copy only values and formats of worksheets to new workbook | Excel Worksheet Functions | |||
| formulae to copy cells from 1 worksheet and paste into another? | New Users to Excel | |||
| copy between worksheets does not copy formulae just values | Excel Discussion (Misc queries) | |||
| copy formats column width & row heights between Excel WORKSHEETS? | Excel Discussion (Misc queries) | |||
| Copy worksheets and formats | Excel Discussion (Misc queries) | |||
Linear Mode
