Styleforum › Forums › General › General Chat › The Excel Questions Thread
New Posts  All Forums:Forum Nav:

The Excel Questions Thread - Page 36

post #526 of 527
Quote:
Originally Posted by Reggs View Post

How much do all of you do to make your spreadsheets pretty?

I always color headings, center text, use different font in headings, make sure my cell boarders look good, and formatt as table>convert to range to get every other row colored. I also think numbers look best in Calibri. Delete unused tabs, color all used ones based on their purpose.

I think I'm the only one who does this. When I get spreadsheets from other people they are always so ugly.

Most of what I show to other people is pasted into a powerpoint. That I always make sure to dress up and make it look nice. The rest of the spreadsheet I don't have time to make look nice, and chances are nobody is ever going to see it anyways.
post #527 of 527
So I have sort of a weird problem. There is a file that I use to produce a report. The file was originally created in Excel 2003. I have converted it to work in Excel 2010. There are two tabs in the workbook that each contain a number of free from drawn images. During the process of assembling the report I run a Macro that does a SaveAs on the workbook to a new name, deletes most of the worksheets that aren't essential to the report, and then copy -> Paste Special -> Values everything on all of the remaining sheets. After the Macro is complete, all of the images are visible on the two worksheets in question. If I close the workbook and then re-open it, the images on one of the tabs are visible, but are invisible on the other tab. The images are still there and if you click and drag one of the invisible images to another part of the workbook it will become visible again. If the image is then dragged back to its original location, it is invisible again.

Thoughts?
New Posts  All Forums:Forum Nav:
  Return Home
  Back to Forum: General Chat
Styleforum › Forums › General › General Chat › The Excel Questions Thread