Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
hi community
can anybody guide this.... when i open a workbook, there is only 1 sheet1 display with data. and clicking on, example, a cell and use the Trace Dependent tool, the selected cell has an Arrow pointing to it. The other cell with the pointer, had a small icon (squarish shape with gridline & the arrow line is black color with dash style & at the bottom right side, there is a small black dot) and i use the Formula display option, the selected cell has a formula indicating the data was from sheet2. however, i tried using the Format Sheet to display the sheet2, but the command was dimmed. is it that Sheet2 was hidden and how do i display out the hidden sheet2 ? the workbook seems not using Macro because i went to the Macro and check, there is nothing in the Macro dialog box?? hope my explaination is clear thanks community for the assistance :) -- oldLearner57 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Hidden Columns No Longer Hidden after Copying Worksheet? | Excel Discussion (Misc queries) | |||
How do I detect hidden worksheets or hidden data on a worksheet? | Excel Discussion (Misc queries) | |||
Hidden Worksheet | Excel Worksheet Functions | |||
hidden worksheet? | Excel Worksheet Functions | |||
Where's the hidden worksheet? | Charts and Charting in Excel |