Thanks Thanks:  0
Likes Likes:  0
Results 1 to 7 of 7

Thread: General design layout and graphics

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Location
    England, UK.
    Posts
    526
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Can anyone suggest a good website where you can see different spreadsheet designs? I am not the world's greatest artist and want to make my spreadsheets look the business as well as do the business.
    Cheers.

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    London, UK
    Posts
    167
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default


    I have used excel commercially for a number of years, and find that the best solution is to trust your own styling.

    The best way to maximise your potential in this area is to play with the properties & formats dialogs for everything. That is, all components of any chart you create, and when you right-click a selection of cells and choose "format cells" you should get to know every detail of the options available and play with them until you become hooked.

    Lots of use of subtle colours (use shades rather than colours), and dotted & thin borders, frozen panes, hide gridlines, etc etc...

    Keep the worksheet tidy and hide anything not required by the end user (eg. extra sheets not in use)...

    Hope this helps and is not patronising, i find that the more you play the more intuitive your own talent becomes.

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Location
    England, UK.
    Posts
    526
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hey, that's great advice and I don't find you patronising at all!

    The trouble is that some people in the office are starting to copy my layouts, so am trying to find a more unique style for myself ... :8

    [ This Message was edited by: RET79 on 2002-03-29 16:18 ]

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I tend to have a frozen panes heading of around 4 or 5 rows..... description, filename and path and column headings, all in reverse text (ie black cell background, white font), with the company logo top right
    repeat them on printing, use gridlines and supress "0"s. I also apply the reverse text to totals, rather than havign accounting lines. Instantly recogniseable. Nice and crisp in my, totally unbiased, opinion !


  5. #5
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi

    Try this link:

    http://spreadsheetstyle.com/index.htm

    Loads of great information on what makes a good spreadsheet.



  6. #6
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

  7. #7
    Board Regular
    Join Date
    Mar 2002
    Location
    Fort McMurray, AB
    Posts
    218
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Regards, Duane
    Office2010 in Win7

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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