#1   Report Post  
C Tate
 
Posts: n/a
Default Formatting sheets

I am wondering if anybody can give me any tips about formatting Excel
spreadsheets? Perhaps there is a good web site? I'm often not sure how best
to go about it, especially if I have a combination of figures and text.
Microsoft seems to produce some really clever templates. For instance, all
the gridlines will be turned off and the background formatted a certain
color. I'd like to learn more about doing this on my own spreadsheets.


  #2   Report Post  
tjtjjtjt
 
Posts: n/a
Default

You might try a Google Search for Excel Formatting to get some ideas.

What I would do:
Make several copies of a sheet I have that is typical of the kinds of
spreadsheets I expect to create.
Experiment with the Formatting Toolbar and the Formatting Menu to see what
looks best.
Also, until you are comfortable with your formatting choices, wait until you
are done typing the data and performing calculations until you try to format.
That way, you can always revert back to a saved version of the data without
any formatting that doesn't seem to be working.

tj


"C Tate" wrote:

I am wondering if anybody can give me any tips about formatting Excel
spreadsheets? Perhaps there is a good web site? I'm often not sure how best
to go about it, especially if I have a combination of figures and text.
Microsoft seems to produce some really clever templates. For instance, all
the gridlines will be turned off and the background formatted a certain
color. I'd like to learn more about doing this on my own spreadsheets.



  #3   Report Post  
JulieD
 
Posts: n/a
Default

you could also check out the format / autoformat options ... to get some
ideas ... and then change the bits you don't like.

"tjtjjtjt" wrote in message
...
You might try a Google Search for Excel Formatting to get some ideas.

What I would do:
Make several copies of a sheet I have that is typical of the kinds of
spreadsheets I expect to create.
Experiment with the Formatting Toolbar and the Formatting Menu to see what
looks best.
Also, until you are comfortable with your formatting choices, wait until
you
are done typing the data and performing calculations until you try to
format.
That way, you can always revert back to a saved version of the data
without
any formatting that doesn't seem to be working.

tj


"C Tate" wrote:

I am wondering if anybody can give me any tips about formatting Excel
spreadsheets? Perhaps there is a good web site? I'm often not sure how
best
to go about it, especially if I have a combination of figures and text.
Microsoft seems to produce some really clever templates. For instance,
all
the gridlines will be turned off and the background formatted a certain
color. I'd like to learn more about doing this on my own spreadsheets.





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Two sheets David Charts and Charting in Excel 8 May 9th 07 09:29 PM
Chart formatting Christianovitch Charts and Charting in Excel 1 January 19th 05 11:55 PM
How do I plot data by drilling down through sheets? MooseTrax Charts and Charting in Excel 2 January 14th 05 02:16 PM
Conditional formatting in Charts? Todd Charts and Charting in Excel 1 January 11th 05 07:32 PM
Cells losing formatting BdgBill Excel Discussion (Misc queries) 1 November 26th 04 09:03 AM


All times are GMT +1. The time now is 08:30 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"