ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   HOW DO I HIDE THE ABC ( TOP ROW ) AND MAKE MY HEADDINGS PERMANENT (https://www.excelbanter.com/excel-worksheet-functions/22910-how-do-i-hide-abc-top-row-make-my-headdings-permanent.html)

TheBankerGuy

HOW DO I HIDE THE ABC ( TOP ROW ) AND MAKE MY HEADDINGS PERMANENT
 
I am trying to create a web sheet for the very first time. I want to hide the
very top row where is shows ABC and I want to make my column headdings
stationary so they do not more when I scroll down.

Also, I need to create drop down boxes in some of the cells. Is this at all
possible?

If possible please email me at:

peace :-)



Gary Brown

- TOOLS / OPTIONS / VIEW
uncheck the 'row & columnheaders' checkbox

- WINDOWS / FREEZE PANES

- DATA / VALIDATION

HTH,
Gary Brown


"TheBankerGuy" wrote:

I am trying to create a web sheet for the very first time. I want to hide the
very top row where is shows ABC and I want to make my column headdings
stationary so they do not more when I scroll down.

Also, I need to create drop down boxes in some of the cells. Is this at all
possible?

If possible please email me at:

peace :-)




All times are GMT +1. The time now is 10:20 AM.

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