COPY SAME DATE/CELL TO EVERY SHEET?

S

STEVE

HOW DO i COPY 1 CELL THAT CONTAINS THE DATE TO EVERY SHEET WITH LEAST AMOUNT
OF KEYSTROKES?
 
P

Paul B

One way, select the sheet with the date, right click on the worksheet tab
and group sheets, select the cell with the date, F2, enter, ungroup the
sheets

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
M

Marcelo

select the cell you want to copy

Edit Copy (or ctrl+C) select all sheets where you want the information and
paste.

remove caps from e-mail

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"STEVE" escreveu:
 
S

STEVE

Ok..that will only allow me to paste it manually, how can I do this with
fewest keystrokes to entire 40 sheet workbook?Thanks again
 
S

STEVE

This doesn't work...when i rt click on tab, it doesn't bring up anything
about a group
 
M

Michael

Steve, select the first sheet, hold down the shift key and click on the last
sheet. This will select all sheets in between. Enter the date in any cell
and it will be entered in all 40 sheets. HTH
 
S

STEVE

THANKS!! Now THAT"S what I'M talkin 'bout!!!

Michael said:
Steve, select the first sheet, hold down the shift key and click on the last
sheet. This will select all sheets in between. Enter the date in any cell
and it will be entered in all 40 sheets. HTH
Click to expand...
 
G

Gord Dibben

Right-click and "select all sheets" to group them.


Gord Dibben MS Excel MVP
 
Top