Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i enter data in multiple sheets simultaneously
..
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i enter data in multiple sheets simultaneously
Hi Usman, Normally you would do this by referencing the subsequent sheet cell to the one where you have entered the data, so if in sheet1 cell A1 you input a value, then in sheet2 A1 you would enter =sheet1!A1 HTH Ed -- EdMac ------------------------------------------------------------------------ EdMac's Profile: http://www.excelforum.com/member.php...o&userid=30736 View this thread: http://www.excelforum.com/showthread...hreadid=522605 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i enter data in multiple sheets simultaneously
Hold down the Ctrl key and select the sheets of interest.......then enter
data in cell you want .......it will go in same cell on all selected sheets.......... Vaya con Dios, Chuck, CABGx3 "Usman Satti" wrote: . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data from multiple sheets | Excel Worksheet Functions | |||
How do I transfer data from multiple excel sheets to powerpoint | Excel Discussion (Misc queries) | |||
Lookup data from multiple sheets | Excel Worksheet Functions | |||
combining data from multiple sheets | Excel Worksheet Functions | |||
sumif to add data in multiple sheets | Excel Worksheet Functions |