Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
A row is missing on a worksheet.
I created a workbook with 4 worksheets. Someone else is inputting the data.
They have managed to create two major problems and I don't know where to look for the solution. 1. The row identified as 66 appears on three of the worksheets but not the fourth. I have checked to see if it was hidden or that opanes were frozen. No luck. How can it just go away? 2. I entered names in column A of the second sheet and formulas to pull the information into col A of worksheets 3 and 4. Somehow the formula got copied into col A of worksheet 2, so I get a circular reference now. The name appears but I have no idea where the information is coming from. If I delete the formula, the name goes away. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
A row is missing on a worksheet.
You can hide rows (or columns) in a couple of ways.
First, they could have applied data|Filter|autofilter to the range and applied a criteria to only see what they wanted to see. You can see everything by: data|Filter|Show All (if show all is greyed out, then this is the solution) Another way hide a row is to select the row and rightclick and choose Hide. One way you can show that row is to edit|Goto type A66 in the reference box hit enter to select that cell--even though you can't see it! Now hit Format|Row|Unhide RitaLee wrote: I created a workbook with 4 worksheets. Someone else is inputting the data. They have managed to create two major problems and I don't know where to look for the solution. 1. The row identified as 66 appears on three of the worksheets but not the fourth. I have checked to see if it was hidden or that opanes were frozen. No luck. How can it just go away? 2. I entered names in column A of the second sheet and formulas to pull the information into col A of worksheets 3 and 4. Somehow the formula got copied into col A of worksheet 2, so I get a circular reference now. The name appears but I have no idea where the information is coming from. If I delete the formula, the name goes away. -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
A row is missing on a worksheet.
If Dave's suggestions don't work, another way to "hide" a row is to reduce
the height of the row to say 0.1 If that's the case, simply select the row above and the row below the missing row, and right click in the selection and choose "Row Height", and enter say, the default 12.75 in the dialog box. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Dave Peterson" wrote in message ... You can hide rows (or columns) in a couple of ways. First, they could have applied data|Filter|autofilter to the range and applied a criteria to only see what they wanted to see. You can see everything by: data|Filter|Show All (if show all is greyed out, then this is the solution) Another way hide a row is to select the row and rightclick and choose Hide. One way you can show that row is to edit|Goto type A66 in the reference box hit enter to select that cell--even though you can't see it! Now hit Format|Row|Unhide RitaLee wrote: I created a workbook with 4 worksheets. Someone else is inputting the data. They have managed to create two major problems and I don't know where to look for the solution. 1. The row identified as 66 appears on three of the worksheets but not the fourth. I have checked to see if it was hidden or that opanes were frozen. No luck. How can it just go away? 2. I entered names in column A of the second sheet and formulas to pull the information into col A of worksheets 3 and 4. Somehow the formula got copied into col A of worksheet 2, so I get a circular reference now. The name appears but I have no idea where the information is coming from. If I delete the formula, the name goes away. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Retrieve data from all of the worksheet within the file | Excel Worksheet Functions | |||
rows 1-2 missing from excel worksheet | Excel Worksheet Functions | |||
Worksheet Tabs Missing! | Excel Discussion (Misc queries) | |||
Search/Match between 2 x separate Worksheets and populate result in third worksheet | Excel Discussion (Misc queries) | |||
Weekly Transaction Processing | Excel Worksheet Functions |