How to copy formats for a cell?

  • Thread starter Thread starter topstar
  • Start date Start date
T

topstar

Folks,

Our office has a workbook which schedules my teams tasks. There is
workbook for each year, and each workbook has 12 worksheets - for eac
month. Each workbook contains months from Jan to Dec. So the workbook
Schedule2004.xls contains 12 worksheets Jan04 to Dec04

The first row in each worksheet contain headings - Date, Mike, Dale
Peter, Angela etc From the second row is the data, for ex as show
below

Date Mike Dale Peter Angela
01/01/04 coding coding testing documentation
02/01/04 coding coding testing documentation
03/01/04 coding coding testing documentation
04/01/04 coding coding testing documentation
 
You can use the Format Painter to copy formats.

Select a cell, or range of cells, that have a format you want to copy
Click the Format Painter
Click on the cell(s) to which you want to apply the copied format.
 
Hi! "topstar >"
How about these as follows:
Tips1: *
Try
"format painter" Icon of tool bar.
1. Select all cells of the original(or previous) sheet
{select the sheet and click the intersection of rows and columns
(left of the column-A, or above row-1)}
2. Click "format painter" Icon of tool bar.
3. Select the new sheet,
click A1
{or,
select the sheet and click the intersection of rows and columns
(left of the column-A, or above row-1)}
4. (done)
**
Tips2:
Try "Paste_special"l of Edit Menu, or short-cut menu Function
or you can try this:
step1: Select original sheet,
step2: Edit | Copy
step3:Then Select new sheet, and;
step4: Edit | Paste-special then dialog opens;
step5: tick "format only" radio-button on the Dialog.
(done)
***
Good Luck!
 
After selecting a cell with the format that you wish to duplicate, you can
*double click* on the format painter icon, which then permits you to click
on individual cells and / or ranges of cells, without "exiting" the copy
mode between clicks.

When you're finished copying the formats, hit <Esc>, or you *will* create a
"mess"!
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



format painter icon after
Folks,

Our office has a workbook which schedules my teams tasks. There is a
workbook for each year, and each workbook has 12 worksheets - for each
month. Each workbook contains months from Jan to Dec. So the workbook -
Schedule2004.xls contains 12 worksheets Jan04 to Dec04

The first row in each worksheet contain headings - Date, Mike, Dale,
Peter, Angela etc From the second row is the data, for ex as shown
below

Date Mike Dale Peter Angela
01/01/04 coding coding testing documentation
02/01/04 coding coding testing documentation
03/01/04 coding coding testing documentation
04/01/04 coding coding testing documentation
 
Back
Top