Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
to format one sheet using other sheet
How to duplicate a sheet by using other sheet? I have 30 sheets (for ex
100108, 100208, 100308 etc), one for each day in a month. I have 15 users working for me and every month, an user will join in team. Every month i have to insert a row for the new user and format all the cell for that user. Is there a solution if i format one sheet (100108), will the changes reflect in all the other sheets. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
to format one sheet using other sheet
Put the phrase "select sheets" into Excel help.
-- David Biddulph "Lakki" wrote in message ... How to duplicate a sheet by using other sheet? I have 30 sheets (for ex 100108, 100208, 100308 etc), one for each day in a month. I have 15 users working for me and every month, an user will join in team. Every month i have to insert a row for the new user and format all the cell for that user. Is there a solution if i format one sheet (100108), will the changes reflect in all the other sheets. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
to format one sheet using other sheet
Hi,
A few things to consider the following options. 1. You may be able to use the Format Painter to speed up the process. - select the data that is format as you want and click the Format Painter (paint brush) 2. Click the other sheet's tab and "paint" the range you want formatted. You can select as large a range as you want to start with or end with, but you many need to experiment. If the entire sheets are identical you can select the whole sheet (top left corner) and click the paint bars, and then click the same spot on the other sheet. You can put your sheets in Group mode and then anything you do to one get done to all of them. It maybe too late for this, but... Select all the sheets you want to format in the same manner, by Ctrl+Clicking each one. Then format any one of the selected ones and all will be formatted exactly the same. Then ungroup the sheets by right-clicking any tab and choosing Ungroup. The sheets must be laid out exactly for this to work. A third idea is to copy a previously formatted sheet to create the new sheet, and then remove unneccessary data from the new sheet. Copy the sheet by holding down the Ctrl key and dragging the sheet tab. If any of these help please click the Yes button -- Thanks, Shane Devenshire "Lakki" wrote: How to duplicate a sheet by using other sheet? I have 30 sheets (for ex 100108, 100208, 100308 etc), one for each day in a month. I have 15 users working for me and every month, an user will join in team. Every month i have to insert a row for the new user and format all the cell for that user. Is there a solution if i format one sheet (100108), will the changes reflect in all the other sheets. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Duplicate sheet, autonumber sheet, record data on another sheet | Excel Worksheet Functions | |||
How to format sheet to show first box whilst tabbing across sheet | Excel Discussion (Misc queries) | |||
VB code to copy sheet format to another sheet | Excel Discussion (Misc queries) | |||
how can I format sheet 1 if the value is found in sheet 2? | New Users to Excel | |||
How do I copy a print format from sheet to sheet in excel ? | Excel Discussion (Misc queries) |