+ Reply to Thread
Results 1 to 7 of 7

how to hide toolbar, Column and Row Heading

  1. #1
    Forum Contributor
    Join Date
    07-25-2019
    Location
    Dhaka, Bangladesh
    MS-Off Ver
    2016
    Posts
    200

    how to hide toolbar, Column and Row Heading

    Hello all,
    im looking for a help to hide toolbar, Column Heading (A, B, C, ect) and Row Heading (1, 2, 3 etc) from my excel, only "Sheet1", "Sheet2" etc will shown, how i can do this
    TIA

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,647

    Re: how to hide toolbar, Column and Row Heading

    View ribbon > deselect Headings.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Forum Contributor
    Join Date
    07-25-2019
    Location
    Dhaka, Bangladesh
    MS-Off Ver
    2016
    Posts
    200

    Re: how to hide toolbar, Column and Row Heading

    Thanks a lot AliGW

  4. #4
    Forum Contributor
    Join Date
    07-25-2019
    Location
    Dhaka, Bangladesh
    MS-Off Ver
    2016
    Posts
    200

    Re: how to hide toolbar, Column and Row Heading

    is it possible to hide the right & bottom side scroll as well?

  5. #5
    Forum Guru
    Join Date
    04-23-2012
    Location
    New Jersey, USA
    MS-Off Ver
    Excel 365
    Posts
    2,408

    Re: how to hide toolbar, Column and Row Heading

    Quote Originally Posted by emmr View Post
    is it possible to hide the right & bottom side scroll as well?
    Go to...

    "Excel Options/Advanced/Display options for this workbook"

    Uncheck the checkboxes for the horizontal and vertical scroll bars.

  6. #6
    Forum Contributor
    Join Date
    07-25-2019
    Location
    Dhaka, Bangladesh
    MS-Off Ver
    2016
    Posts
    200

    Re: how to hide toolbar, Column and Row Heading

    Rick Rothstein, tnx a lot

  7. #7
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,647

    Re: how to hide toolbar, Column and Row Heading

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Hide all toolbar after restoring
    By fshbet in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-16-2015, 01:14 PM
  2. Hide ribbon and toolbar
    By NathalieF in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-21-2013, 04:34 AM
  3. [SOLVED] Hide Heading and should not allow to change
    By sachin parab in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-19-2012, 08:49 AM
  4. Can't hide toolbar!!
    By barrows00 in forum Excel General
    Replies: 1
    Last Post: 03-11-2011, 03:45 PM
  5. Hide toolbar with 2 buttons remaining
    By dsrt16 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-15-2009, 02:51 PM
  6. How do I hide or unhide row and column heading in Excel?
    By Maharaj in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-25-2006, 01:05 PM
  7. [SOLVED] In a table produce an value by column heading and row heading
    By naflan in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-27-2005, 01:25 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1