+ Reply to Thread
Results 1 to 4 of 4

hide cells?

  1. #1
    Registered User
    Join Date
    10-05-2010
    Location
    Felixstowe, UK
    MS-Off Ver
    Excel 2007
    Posts
    4

    Question hide cells?

    Is it possible to hide the cells and only have the numbers and words on show? And is it possible to have my company logo as the background?

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,090

    Re: hide cells?

    You can hide the formulae (Format | Format cells | Protection tab | check Hidden. You would need to protect the sheet(s) for this to be effective.

    And, yes, you can use the company logo as a background. However, it will be tiled to fill the whole of the sheet ... which may or may not be what you envisage. How many tiles will depend on the size of of the logo. However, the background will not print ... again, this may or may not be what you want.

    If you want it printing, you could insert it in a header or footer.

    Regards
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,578

    Re: hide cells?

    You could also insert the logo into a specific cell or cells.(insert picture from file)
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  4. #4
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: hide cells?

    Tools->Options->View - un-check Gridlines

    In 2007, click the Office Button then Excel Options at the bottom, Advanced. Then scroll down to find the View gridlines option
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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