+ Reply to Thread
Results 1 to 3 of 3

How to display hidden areas of a sheet

  1. #1
    Registered User
    Join Date
    02-03-2013
    Location
    Curacao
    MS-Off Ver
    Excel 2007
    Posts
    15

    How to display hidden areas of a sheet

    Hi guys,

    This is not a simple hide or unhide rows and columns,
    I have a sheet that I made 5 years ago, but I can't remember how I hid certain things. All rows and columns are visible. The sheet contains certain information for data input. But when I print it....a lot more stuff appears (that now I need to change) but I don't remember how I hid them, so I don't remember how to unhide them (or make then visible again) so I can edit them. For example there is a picture with the company logo on top, there is the company name, date and stuff.....none of those things are visible in the sheet. But all rows and columns are unhidden. They logo and date and stuff appear only when I print the sheet. There's also a cell that becomes visible (on paper, it is visible on screen) only when the cell next to it has data in it. I really cannot remember how I did that. I do remember that I had to select all the cells I wanted to hide (including the picture with the company logo) but what I did next remains a history. Anyone knows how to undo (make those things back visible) so I can edit the sheet?
    Attached Files Attached Files

  2. #2
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Microsoft Office 2013
    Posts
    3,223

    Re: How to display hidden areas of a sheet

    VBA. It may due to macro. Kindly check.
    Click on sheet name > Right click > View code.


    atul


    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".

  3. #3
    Registered User
    Join Date
    02-03-2013
    Location
    Curacao
    MS-Off Ver
    Excel 2007
    Posts
    15

    Re: How to display hidden areas of a sheet

    I figured how I did it. The print area (with logo and date and stuff) is waaaaayyy down below in the spreadsheet. No wonder I couldn't find it.

+ 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] Display Hidden Sheet(s) based on cell value
    By Craig Stafford in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-18-2014, 10:42 PM
  2. Dynamic Buttons for Choosing Areas to display in Diagram
    By Bim1 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 07-11-2014, 05:12 AM
  3. Replies: 0
    Last Post: 05-23-2014, 01:05 PM
  4. Display Specified Image In Multiple Areas Within Workbook
    By swordswinger710 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-09-2012, 01:22 PM
  5. [SOLVED] Select certain visible/non-hidden areas
    By 0-0 Wai Wai ^-^ in forum Excel General
    Replies: 3
    Last Post: 09-08-2005, 04:05 PM
  6. setting print areas, and not printing 'hidden' cells
    By Tom in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-11-2005, 03:05 PM
  7. [SOLVED] Protecting Hidden Areas
    By Ian in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-25-2005, 11:06 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