Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Keeping the same format in linked worksheets
I am linking about 15 separate worksheets into one workbook, but they all
have different formats that they need to be in. The original is in that format, but when I copy it to the next one, the format gets all screwed up. is there anyway to keep the format when linking something like that? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Keeping the same format in linked worksheets
Have you tried the Format Painter? If you use the Format Painter from the
original on the other 15, when you link them to the workbook, they should all look the same and it won't screw up the formulas. "Confused" wrote: I am linking about 15 separate worksheets into one workbook, but they all have different formats that they need to be in. The original is in that format, but when I copy it to the next one, the format gets all screwed up. is there anyway to keep the format when linking something like that? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
keeping cell format with formula | Excel Worksheet Functions | |||
HOW DO I FORMAT WORKSHEETS IN A WORKBOOK TO NUMBER IN A SEQUENCE? | Excel Worksheet Functions | |||
Custom Format Cell | Excel Discussion (Misc queries) | |||
sorting with linked worksheets | Excel Discussion (Misc queries) | |||
Replacing Linked Cell Values w/ Current Values | Excel Worksheet Functions |