Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
name box in excel 2003
i am new to excell and i have a document that i got from work that has
multiple worksheets, that drop down in the "name box" it says i get them but i cannot get back to my original document.. sorry dont know how else to describe this. thanks T |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
name box in excel 2003
"that dropdown in the 'name box' it says"....
What is IT? The dropdown? The name box? "it says I get them"... What is THEM? "back to my original document"... Can you see your sheet tabs? I can only envision that you have a workbook with sheet tabs hidden ( to fix, go to Tools--Options--View and make sure sheet tabs is checked) or that you have a workbook that has the sheet tabs "off screen" (to fix, go to Window--Arrange all), and that you're using the name box dropdown to select a named range that's on something besides the sheet that appeared when you opened the file. Also, have you tried: Ctrl+Home to get to the top of the worksheet Ctrl+G and type in Sheet1!A1 to get to the first cell of the first sheet (presumably). **************************** Hope it helps! Anne Troy www.OfficeArticles.com **************************** "quilting2" wrote in message ... i am new to excell and i have a document that i got from work that has multiple worksheets, that drop down in the "name box" it says i get them but i cannot get back to my original document.. sorry dont know how else to describe this. thanks T |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
name box in excel 2003
Just a thought for a quick check
(but I think Anne's response would have nailed your issue) .. In a new sheet, Select A1, then click Insert Name Paste Paste list Check the pasted list for any errors in the defined names, eg: =#REF!$A$1:$B$1 -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "quilting2" wrote: i am new to excell and i have a document that i got from work that has multiple worksheets, that drop down in the "name box" it says i get them but i cannot get back to my original document.. sorry dont know how else to describe this. thanks T |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
name box in excel 2003
Thank you the windows option worked to add the worksheets to the
bottom of my screen so that i could see them. "Anne Troy" wrote: "that dropdown in the 'name box' it says".... What is IT? The dropdown? The name box? "it says I get them"... What is THEM? "back to my original document"... Can you see your sheet tabs? I can only envision that you have a workbook with sheet tabs hidden ( to fix, go to Tools--Options--View and make sure sheet tabs is checked) or that you have a workbook that has the sheet tabs "off screen" (to fix, go to Window--Arrange all), and that you're using the name box dropdown to select a named range that's on something besides the sheet that appeared when you opened the file. Also, have you tried: Ctrl+Home to get to the top of the worksheet Ctrl+G and type in Sheet1!A1 to get to the first cell of the first sheet (presumably). **************************** Hope it helps! Anne Troy www.OfficeArticles.com **************************** "quilting2" wrote in message ... i am new to excell and i have a document that i got from work that has multiple worksheets, that drop down in the "name box" it says i get them but i cannot get back to my original document.. sorry dont know how else to describe this. thanks T |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
name box in excel 2003
Cool. And I just noticed your moniker "quilting2"! I do that stuff, too. :)
**************************** Anne Troy www.OfficeArticles.com **************************** "quilting2" wrote in message ... Thank you the windows option worked to add the worksheets to the bottom of my screen so that i could see them. "Anne Troy" wrote: "that dropdown in the 'name box' it says".... What is IT? The dropdown? The name box? "it says I get them"... What is THEM? "back to my original document"... Can you see your sheet tabs? I can only envision that you have a workbook with sheet tabs hidden ( to fix, go to Tools--Options--View and make sure sheet tabs is checked) or that you have a workbook that has the sheet tabs "off screen" (to fix, go to Window--Arrange all), and that you're using the name box dropdown to select a named range that's on something besides the sheet that appeared when you opened the file. Also, have you tried: Ctrl+Home to get to the top of the worksheet Ctrl+G and type in Sheet1!A1 to get to the first cell of the first sheet (presumably). **************************** Hope it helps! Anne Troy www.OfficeArticles.com **************************** "quilting2" wrote in message ... i am new to excell and i have a document that i got from work that has multiple worksheets, that drop down in the "name box" it says i get them but i cannot get back to my original document.. sorry dont know how else to describe this. thanks T |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
import Excel 2003 file into Outlook 2003 - NO NAMED RANGES?? | Excel Discussion (Misc queries) | |||
Copying Excel 2003 Selection into Outlook 2003 HTML E-Mail Message | Excel Discussion (Misc queries) | |||
Upgrade from Excel 2000 to Excel 2003 without MS Office 2003? | Excel Discussion (Misc queries) | |||
I am running Excel 2003 from Office 2003 Professional | Excel Discussion (Misc queries) | |||
Excel 2003 Database Driver Visual FoxPro 7 on Server 2003. | Excel Discussion (Misc queries) |