ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   I hid row 1 and can't get it back? (https://www.excelbanter.com/excel-discussion-misc-queries/65193-i-hid-row-1-cant-get-back.html)

Nyczoo

I hid row 1 and can't get it back?
 
Any thoughts - can't get it to reappear. Thanks all.

JE McGimpsey

I hid row 1 and can't get it back?
 
Enter

1:1

in the Name box (at the left of the formula bar) and hit Enter. Choose
Format/Row/Unhide.

In article ,
Nyczoo wrote:

Any thoughts - can't get it to reappear. Thanks all.


bpeltzer

I hid row 1 and can't get it back?
 
Click in A2 and drag to the column A header. Then Format Row Unhide.

"Nyczoo" wrote:

Any thoughts - can't get it to reappear. Thanks all.


Dave Peterson

I hid row 1 and can't get it back?
 
And maybe after unhiding row 1:
window|unfreeze panes.

Nyczoo wrote:

Any thoughts - can't get it to reappear. Thanks all.


--

Dave Peterson

Jean

I hid row 1 and can't get it back?
 

I needed to unfreeze my panes. Holy cow, I almost threw the computer
out the window. Thanks!!!!!


--
Jean
------------------------------------------------------------------------
Jean's Profile: http://www.excelforum.com/member.php...o&userid=17585
View this thread: http://www.excelforum.com/showthread...hreadid=501348



All times are GMT +1. The time now is 12:32 AM.

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