How can be made this spreadsheet more design appealing

**marianpa** · 01-10-2008, 08:42 PM

Hello!

Can I please have some suggestions on how to make this spreadsheet more design appealing for a presentation?

Thank you anticipated for your time and effort!

**Gus80** · 01-11-2008, 12:34 AM

Maybe something like this??

**marianpa** · 01-11-2008, 11:09 PM

Originally Posted by Gus80

Maybe something like this??

Hey G,

Thank you for your time and effort.
Do you have any idea how I can automate new input process, thus when I introduce new members number for Organization G, H, I, the spread sheet to calculate based on the formula above?

**royUK** · 01-12-2008, 03:23 AM

Both designs ignore all the rules for using data in Excel. The data should be in a table format with a header row, no empty rows or columns. If set up correctly you can then use the Data Form for input & all of excel's Database Functions, including pivotTables.

You can have a dashboard sheet displaying summaries in a user friendly design on a separate sheet.

I have removed all the merged cells, these willcause problems, using centre acroos selection or wrap text instead.

I have amended the formulas, adding absolute references where needed.

Fnally rearranged the data so that it is in a database format. From this you can select any cell in the data & from the Data menu click form to get a data input form.