Excel workbook setup

  • Thread starter Thread starter sheri \(removethis\)
  • Start date Start date
S

sheri \(removethis\)

I have workbook with multiple pages (10+) and I want to
type in client's name & acct # in once, but the info
appearing on all sheets. How is this done? I am now
copying and pasting-must be a quicker way! Thanks in
advance!
 
You need to group the worksheet. Click on the tab of the
first worksheet, hold down the shift key and click on the
last worksheet tab. Type the information in the desired
cell and all worksheet will have that information in the
same location. Right click on any tab to ungroup the
worksheet.
LOL
Charlie o'Neill
 
Sheri, one way is to group the sheets, right click on one and select all,
now what you type in one sheet will go in all of them, click on a sheet to
ungroup them

--
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 97 & 2000
** remove news from my email address to reply by email **
 
Back
Top