ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Missing Row (https://www.excelbanter.com/excel-worksheet-functions/9015-missing-row.html)

Debbie Humphrey

Missing Row
 
I have a spreadsheet, and when I opened it up, row 1 is missing. I have
tried to unhide it but it does not seem to be hidden. I can go to the row
but it just is not on the spreadsheet

JulieD

Hi Debbie

it's possible that the row height has been changed to 0,
go to A1
choose format / row / height
type in 12.75 and press OK

Cheers
JulieD

"Debbie Humphrey" <Debbie wrote in
message ...
I have a spreadsheet, and when I opened it up, row 1 is missing. I have
tried to unhide it but it does not seem to be hidden. I can go to the row
but it just is not on the spreadsheet




cmart02

Debbie,

It sounds like your panes have been frozen whilst the first row was scrolled
up. Unfreeze the panes (Windows -- Unfreeze Panes) and then scroll row one
again.

If you wish, you can freeze the panes once it has been scrolled to the
correct position.

Regards
Robert

Cgbilliar

Point cursor on blank space in upper left corner. left click and hightlight
down to row 2 right click then unhide.


All times are GMT +1. The time now is 03:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com