I am working on a pricelist for use by my team and want to have a
professional appearance. Is there anything within Excel that will allow me to
change the look of the sheet?
I am working on a pricelist for use by my team and want to have a
professional appearance. Is there anything within Excel that will allow me to
change the look of the sheet?
You can change the appearance of a sheet by formatting cells.
What specifically do you want to change?
I have 4 cells for data entry including 2 dropdowns, and a larger number of
cells showing the result. I want to make clear which cells require operator
input, and which are purely for display. Display cells are protected. All I
want is a good-looking form that is clear and easy to use.
Thanks,
guy
"Nicko" wrote:
>
> You can change the appearance of a sheet by formatting cells.
> What specifically do you want to change?
>
>
> --
> Nicko
> ------------------------------------------------------------------------
> Nicko's Profile: http://www.excelforum.com/member.php...o&userid=29477
> View this thread: http://www.excelforum.com/showthread...hreadid=491776
>
>
Guy,
I take it then that you have protected the sheet so that only the input cells can be changed?
Have you tried formatting the cells with borders or colours and clear text notes/arrows (arrows are accessed from the drawing menu and can then be embedded)
Nick
Thanks, all that is fine. Looking for something a bit more flashy; 3-D
effects, chamfers, shadows etc. Anything in this area would be great.
Guy
"Nicko" wrote:
>
> Guy,
> I take it then that you have protected the sheet so that only the input
> cells can be changed?
> Have you tried formatting the cells with borders or colours and clear
> text notes/arrows (arrows are accessed from the drawing menu and can
> then be embedded)
>
> Nick
>
>
> --
> Nicko
> ------------------------------------------------------------------------
> Nicko's Profile: http://www.excelforum.com/member.php...o&userid=29477
> View this thread: http://www.excelforum.com/showthread...hreadid=491776
>
>
pritchag-
I dont know of any skins or preset schemes, but you can use the drawing
toolbar to add shadows and 3-D effects to selected cells. you can make
certain things stand out like that. Good Luck.
"pritchag" wrote:
> Thanks, all that is fine. Looking for something a bit more flashy; 3-D
> effects, chamfers, shadows etc. Anything in this area would be great.
>
> Guy
>
> "Nicko" wrote:
>
> >
> > Guy,
> > I take it then that you have protected the sheet so that only the input
> > cells can be changed?
> > Have you tried formatting the cells with borders or colours and clear
> > text notes/arrows (arrows are accessed from the drawing menu and can
> > then be embedded)
> >
> > Nick
> >
> >
> > --
> > Nicko
> > ------------------------------------------------------------------------
> > Nicko's Profile: http://www.excelforum.com/member.php...o&userid=29477
> > View this thread: http://www.excelforum.com/showthread...hreadid=491776
> >
> >
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks