| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
DISPLAY TWO DIFFERENT SHEETS ON SCREEN
i AM TRYING TO TRANSFER DATA FROM ONE SHEET TO ANOTHER. I CANNOT FIGURE OUT
A FORMULA TO DO THIS, SO WILL COPY MANUALLY BUT WOULD LIKE HAVE BOTH SHEETS DISPLAYED AT ONCE ON THE SCREEN SO THE INFO IS EASILY ACCESSIBLE. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
DISPLAY TWO DIFFERENT SHEETS ON SCREEN
To copy data from one sheet to another by formula.........
In any cell of Sheet2 enter =Sheet1!A1 to get what's in A1 Or if you want to cut and paste go to............... Excel 2003.....................WindowNew Window WindowArrangeVertical Put a sheet in each window. Excel 2007....................ViewNew Window Arrange AllVertical. Put a sheet in each window. Gord Dibben MS Excel MVP On Sun, 22 Mar 2009 13:01:15 -0700, m wrote: i AM TRYING TO TRANSFER DATA FROM ONE SHEET TO ANOTHER. I CANNOT FIGURE OUT A FORMULA TO DO THIS, SO WILL COPY MANUALLY BUT WOULD LIKE HAVE BOTH SHEETS DISPLAYED AT ONCE ON THE SCREEN SO THE INFO IS EASILY ACCESSIBLE. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| DEFAULT DISPLAY ON SCREEN | Excel Discussion (Misc queries) | |||
| can i put sheets on the left and right of my screen | Excel Discussion (Misc queries) | |||
| In 3 active sheets in wkbk, determine& display the # of sheets that have data | Excel Discussion (Misc queries) | |||
| How can I set the screen size to always display @ 110%- a default | Excel Discussion (Misc queries) | |||
| Worksheet won't display full screen | New Users to Excel | |||
Hybrid Mode
