| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Across Worksheets Again
How would I make my name appear in cell D9 on every worksheet in the workbook with out manually inputting my name into every worksheet (there are 240!). -- Triptanes ------------------------------------------------------------------------ Triptanes's Profile: http://www.excelforum.com/member.php...o&userid=33849 View this thread: http://www.excelforum.com/showthread...hreadid=536285 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Across Worksheets Again
O nm I figured it out, select first worksheet hold down shift click last worksheet, enter my name in D9, voila! -- Triptanes ------------------------------------------------------------------------ Triptanes's Profile: http://www.excelforum.com/member.php...o&userid=33849 View this thread: http://www.excelforum.com/showthread...hreadid=536285 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Across Worksheets Again
Type your name in once.
Name that cell <insert<Name<Define Type in name for cell (say 3 characters to keep it short)<OK In each of the worksheets- Highlight the cell to contain your name Click on "=" Highlight the cell containing your name Hit enter This puts in a reference to that cell. Regards. Bill Ridgeway Computer Solutions "Triptanes" wrote in message ... How would I make my name appear in cell D9 on every worksheet in the workbook with out manually inputting my name into every worksheet (there are 240!). -- Triptanes ------------------------------------------------------------------------ Triptanes's Profile: http://www.excelforum.com/member.php...o&userid=33849 View this thread: http://www.excelforum.com/showthread...hreadid=536285 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy Worksheets from one Workbook to Another | Excel Worksheet Functions | |||
| Adding same cells across multiple worksheets | Excel Worksheet Functions | |||
| Changing a Link Mid-way Across Worksheets | Excel Worksheet Functions | |||
| How to protect and unprotect 30 worksheets in a file every month . | Excel Worksheet Functions | |||
| HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) | |||
Linear Mode
