+ Reply to Thread
Results 1 to 6 of 6

Over-lay on Spreadsheets

  1. #1
    Registered User
    Join Date
    04-15-2005
    Posts
    3

    Over-lay on Spreadsheets

    Is there somthing in Excel that gives a cleaner look to a spreadsheet?
    I have a file that jumps around within itself and performs calculations and so on.
    Trouble is it looks messy and I'd like to give it a cleaner/professional look.
    Cheers all
    Deana

  2. #2
    Registered User
    Join Date
    02-09-2004
    Posts
    52
    Deana, you can either goto FORMAT>SHEET>BACKGROUND

    You can choose a background image from there, or alternatively. Quite a good way to clean it up is taking a bit of time to set the fill colour on the cells to white and put various borders around the parts that you want to make stand out. you can get it looking very neat like that.

    hope that helps.

  3. #3
    Registered User
    Join Date
    04-15-2005
    Posts
    3

    Replay

    When I say "jumps around" I mean that you would add information then click
    a button that will take you to another sheet and so on. So it works just as I want it to but is not very polished. I have been told that you can have a Macro do a lot of work for you. How true that is I don't know.
    Thanks again.
    XDeanaX

  4. #4
    Registered User
    Join Date
    02-09-2004
    Posts
    52

    hyperlinks?

    you can move around in any sheet by using hyperlinks. very easy to use too. Just Select the cell where you initially want to click to go somewhere else, right-click and select hyperlink.

    On the box that comes up, select "Place in exsisting document" on the left then type in the cell refrence i.e. A1 etc where you want to end up when you click the cell.

    you can also link to other documents & sheets like this.

    is that what you meant?

  5. #5
    Registered User
    Join Date
    04-15-2005
    Posts
    3

    Re:

    I can do all the moving around and all my cells work no problem.
    I just want to make it look cleaner, a more professional look lets say.

  6. #6
    Registered User
    Join Date
    02-09-2004
    Posts
    52
    A good way then Deana is to just white out most of the spreadsheet that you will see when you move around by just filling the cells white and then using borders around the cells or collections of cells to make areas stand out, or use different coloured backgrounds for it..

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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