+ Reply to Thread
Results 1 to 2 of 2

how to see the hidden columns in the excel work sheet

  1. #1
    Forum Contributor
    Join Date
    07-27-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    141

    how to see the hidden columns in the excel work sheet

    Hi,

    How to view the column headings in the sheet enclosed herewith. I tried format, visibility option and all possible . But it does not help. But when i hover the cursor, it shows the column headings a,b c and row nos in cell etc
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    02-08-2012
    Location
    Newcastle, Australia
    MS-Off Ver
    Excel 2007 and Excel 2010
    Posts
    1,429

    Re: how to see the hidden columns in the excel work sheet

    Hi,

    On the View tab on the Ribbon, click the Split button. This will disable the worksheet split.

    Alternatively, place your cursor near where the column headings should be until it changes its image (a horizontal line with an up and down arrow on it), and then click and drag down.

    If this solves your problem, please don't forget to mark this thread as solved (Thread Tools --> Mark As Solved), and please click on the * next to my post to say thanks.

    I hope this helps

+ 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. Will Macro work on a hidden spread sheet
    By schmidtpainting in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 12-16-2013, 04:39 PM
  2. How to work with a hidden sheet?
    By bryan444 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-04-2012, 10:43 AM
  3. Printing Excel sheet including hidden columns
    By johngr55 in forum Excel General
    Replies: 0
    Last Post: 09-29-2010, 05:29 AM
  4. SUBTOTAL function to work with hidden columns
    By e_lad in forum Excel General
    Replies: 4
    Last Post: 03-08-2010, 06:40 AM
  5. Range.Value doesn't work in hidden columns
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-10-2006, 03:05 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