ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Missing Column Headers / Can't scroll to top (https://www.excelbanter.com/excel-discussion-misc-queries/177793-missing-column-headers-cant-scroll-top.html)

RobynW

Missing Column Headers / Can't scroll to top
 
I have an Excel spreadsheet that is in my powerpoint presentation, and I need
to edit it. However, when I click on it and it opens in Excel, I can't
scroll past line 15 and my column headers (labeled A - Z) and row headers ( 1
- ?) are gone.

How do I get the headers back and be able to scroll to the top ?
--
Robyn

Cimjet[_2_]

Missing Column Headers / Can't scroll to top
 
Hi Robyn
In excel3, see "tools-Option-View- and select Rows&Column Headers.
Also under Tools-Protection, the sheet is probably lock.
Regards
Comet
good lock
"RobynW" (donotspam) wrote in message
...
I have an Excel spreadsheet that is in my powerpoint presentation, and I
need
to edit it. However, when I click on it and it opens in Excel, I can't
scroll past line 15 and my column headers (labeled A - Z) and row headers
( 1
- ?) are gone.

How do I get the headers back and be able to scroll to the top ?
--
Robyn



Gord Dibben

Missing Column Headers / Can't scroll to top
 
Also, maybe WindowUnfreeze Panes to get up to row 1.


Gord Dibben MS Excel MVP

On Mon, 25 Feb 2008 12:53:01 -0500, "Cimjet"
wrote:

Hi Robyn
In excel3, see "tools-Option-View- and select Rows&Column Headers.
Also under Tools-Protection, the sheet is probably lock.
Regards
Comet
good lock
"RobynW" (donotspam) wrote in message
...
I have an Excel spreadsheet that is in my powerpoint presentation, and I
need
to edit it. However, when I click on it and it opens in Excel, I can't
scroll past line 15 and my column headers (labeled A - Z) and row headers
( 1
- ?) are gone.

How do I get the headers back and be able to scroll to the top ?
--
Robyn




All times are GMT +1. The time now is 02:54 AM.

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