Home |
Search |
Today's Posts |
#1
|
|||
|
|||
hidden rows in Excel
I have a multi sheet Excel file and on one of the sheets, I cannot view the
top two rows. I have tried every way I know and in help to unhide these rows but to no avail. I am able to access them. One thing I am unable to do is to try to change their height as I don't get the cursor sign to do this when approching the select all cells button. maybe this has something to do with it. The sheet has been protected but is currently unprotected. Can anybody help please ? |
#2
|
|||
|
|||
hidden rows in Excel
Hi David-
Have you tried this one: Click the cell reference in the Name Box (left end of the formula bar), to select the content appearing there, then type in A1:A2 to replace it, then press Enter. Immediately go to FormatRowUnhide. HTH |:) "David" wrote: I have a multi sheet Excel file and on one of the sheets, I cannot view the top two rows. I have tried every way I know and in help to unhide these rows but to no avail. I am able to access them. One thing I am unable to do is to try to change their height as I don't get the cursor sign to do this when approching the select all cells button. maybe this has something to do with it. The sheet has been protected but is currently unprotected. Can anybody help please ? |
#3
|
|||
|
|||
hidden rows in Excel
Hi Cyber Taz, thanks but I've already tried that and it doesn't work. Thanks
for your input though. "CyberTaz" wrote: Hi David- Have you tried this one: Click the cell reference in the Name Box (left end of the formula bar), to select the content appearing there, then type in A1:A2 to replace it, then press Enter. Immediately go to FormatRowUnhide. HTH |:) "David" wrote: I have a multi sheet Excel file and on one of the sheets, I cannot view the top two rows. I have tried every way I know and in help to unhide these rows but to no avail. I am able to access them. One thing I am unable to do is to try to change their height as I don't get the cursor sign to do this when approching the select all cells button. maybe this has something to do with it. The sheet has been protected but is currently unprotected. Can anybody help please ? |
#4
|
|||
|
|||
hidden rows in Excel
How about
Window Unfreeze Panes HTH "David" wrote: Hi Cyber Taz, thanks but I've already tried that and it doesn't work. Thanks for your input though. "CyberTaz" wrote: Hi David- Have you tried this one: Click the cell reference in the Name Box (left end of the formula bar), to select the content appearing there, then type in A1:A2 to replace it, then press Enter. Immediately go to FormatRowUnhide. HTH |:) "David" wrote: I have a multi sheet Excel file and on one of the sheets, I cannot view the top two rows. I have tried every way I know and in help to unhide these rows but to no avail. I am able to access them. One thing I am unable to do is to try to change their height as I don't get the cursor sign to do this when approching the select all cells button. maybe this has something to do with it. The sheet has been protected but is currently unprotected. Can anybody help please ? |
#5
|
|||
|
|||
hidden rows in Excel
What a man Gary, that was it ! What an idiot I am for not noticing the lines.
Thanks very much David "Gary76" wrote: How about Window Unfreeze Panes HTH "David" wrote: Hi Cyber Taz, thanks but I've already tried that and it doesn't work. Thanks for your input though. "CyberTaz" wrote: Hi David- Have you tried this one: Click the cell reference in the Name Box (left end of the formula bar), to select the content appearing there, then type in A1:A2 to replace it, then press Enter. Immediately go to FormatRowUnhide. HTH |:) "David" wrote: I have a multi sheet Excel file and on one of the sheets, I cannot view the top two rows. I have tried every way I know and in help to unhide these rows but to no avail. I am able to access them. One thing I am unable to do is to try to change their height as I don't get the cursor sign to do this when approching the select all cells button. maybe this has something to do with it. The sheet has been protected but is currently unprotected. Can anybody help please ? |
#6
|
|||
|
|||
hidden rows in Excel
I think that the pane freezing that Gary mentioned is the likely culprit.
If not, you could try highlighting the entire sheet by clicking in the small grey area above row 1 and to the left of column A, then Format Row Unhide. "David" wrote: I have a multi sheet Excel file and on one of the sheets, I cannot view the top two rows. I have tried every way I know and in help to unhide these rows but to no avail. I am able to access them. One thing I am unable to do is to try to change their height as I don't get the cursor sign to do this when approching the select all cells button. maybe this has something to do with it. The sheet has been protected but is currently unprotected. Can anybody help please ? |
#7
|
|||
|
|||
hidden rows in Excel
Thanks, problem is solved, the panes were frozen.
"Pastel Hughes" wrote: I think that the pane freezing that Gary mentioned is the likely culprit. If not, you could try highlighting the entire sheet by clicking in the small grey area above row 1 and to the left of column A, then Format Row Unhide. "David" wrote: I have a multi sheet Excel file and on one of the sheets, I cannot view the top two rows. I have tried every way I know and in help to unhide these rows but to no avail. I am able to access them. One thing I am unable to do is to try to change their height as I don't get the cursor sign to do this when approching the select all cells button. maybe this has something to do with it. The sheet has been protected but is currently unprotected. Can anybody help please ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why are my hidden rows unhidden after I edit a graph? | Charts and Charting in Excel | |||
How can I delete rows from Pivot Tables in Excel 2000 as in 97 | Excel Discussion (Misc queries) | |||
change excel row height without showing hidden rows | Excel Worksheet Functions | |||
hidden rows & columns slow file open | Excel Discussion (Misc queries) | |||
Hidden page bracks in Excel should be deactivated | Excel Discussion (Misc queries) |