How to "Beautify" or make Presentable a spreadsheet

Hi,

Using this template, named "Commercial Invoice", as an example
(http://office.microsoft.com/en-us/te...T101172551033),
look at the lower 1/4th of the form, left side, just below the "sub-total"
section, there is a section named "Total Number of Packages". Below that
there is a part, a box, with no grid lines for the space of two rows, but
only on the left; the right side of the form has an area with row lines - and
the two sides share the same linear space. Also, within the left box is a
large "6" that takes up two rows without changing the height of the row (as
far as I can tell).

Question: How were those two presentation/formatting items accomplished?
If there is some resource online that can teach me this, you are welcome to
simply point me to it (if the knowledge is buried within that resource,
please let me know that) instead of using up your time to make a
mini-tutorial just for me. :-)

Thanks.

V

Simply format to merged cells with the text size increased.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Voodoo" wrote in message
...
Hi,

Using this template, named "Commercial Invoice", as an example
(http://office.microsoft.com/en-us/te...T101172551033),
look at the lower 1/4th of the form, left side, just below the "sub-total"
section, there is a section named "Total Number of Packages". Below that
there is a part, a box, with no grid lines for the space of two rows, but
only on the left; the right side of the form has an area with row lines -
and
the two sides share the same linear space. Also, within the left box is a
large "6" that takes up two rows without changing the height of the row
(as
far as I can tell).

Question: How were those two presentation/formatting items accomplished?
If there is some resource online that can teach me this, you are welcome
to
simply point me to it (if the knowledge is buried within that resource,
please let me know that) instead of using up your time to make a
mini-tutorial just for me. :-)

Thanks.

V

Don,

Thank you for your answer. That was what I was looking for.

Another Q: Is there a "Tips & Tricks" for Excel some where? I'd like to
learn some of these not-so-obvious methods for working with spreadsheets.

V

"Don Guillett" wrote:

Simply format to merged cells with the text size increased.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Voodoo" wrote in message
...
Hi,

Using this template, named "Commercial Invoice", as an example
(http://office.microsoft.com/en-us/te...T101172551033),
look at the lower 1/4th of the form, left side, just below the "sub-total"
section, there is a section named "Total Number of Packages". Below that
there is a part, a box, with no grid lines for the space of two rows, but
only on the left; the right side of the form has an area with row lines -
and
the two sides share the same linear space. Also, within the left box is a
large "6" that takes up two rows without changing the height of the row
(as
far as I can tell).

Question: How were those two presentation/formatting items accomplished?
If there is some resource online that can teach me this, you are welcome
to
simply point me to it (if the knowledge is buried within that resource,
please let me know that) instead of using up your time to make a
mini-tutorial just for me. :-)

Thanks.

V

There are many Excel Tips and Tricks sites on the 'net.

Use your favorite search engine and look for "excel tips and tricks"

Best of all............hang around these news groups.


Gord Dibben MS Excel MVP


On Wed, 2 Sep 2009 16:49:01 -0700, Voodoo
wrote:

Don,

Thank you for your answer. That was what I was looking for.

Another Q: Is there a "Tips & Tricks" for Excel some where? I'd like to
learn some of these not-so-obvious methods for working with spreadsheets.

V

"Don Guillett" wrote:

Simply format to merged cells with the text size increased.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Voodoo" wrote in message
...
Hi,

Using this template, named "Commercial Invoice", as an example
(http://office.microsoft.com/en-us/te...T101172551033),
look at the lower 1/4th of the form, left side, just below the "sub-total"
section, there is a section named "Total Number of Packages". Below that
there is a part, a box, with no grid lines for the space of two rows, but
only on the left; the right side of the form has an area with row lines -
and
the two sides share the same linear space. Also, within the left box is a
large "6" that takes up two rows without changing the height of the row
(as
far as I can tell).

Question: How were those two presentation/formatting items accomplished?
If there is some resource online that can teach me this, you are welcome
to
simply point me to it (if the knowledge is buried within that resource,
please let me know that) instead of using up your time to make a
mini-tutorial just for me. :-)

Thanks.

V

Gord,

Thanks. I will, and have, done a similar search; I was hoping to hear what
others liked in web resources of a similar vein. I should have been more
wordy and explanatory. :-) I will peruse these boards for gems and nuggets
of Excel how-tos.

Have a great day.

V

"Gord Dibben" wrote:

There are many Excel Tips and Tricks sites on the 'net.

Use your favorite search engine and look for "excel tips and tricks"

Best of all............hang around these news groups.


Gord Dibben MS Excel MVP


On Wed, 2 Sep 2009 16:49:01 -0700, Voodoo
wrote:

Don,

Thank you for your answer. That was what I was looking for.

Another Q: Is there a "Tips & Tricks" for Excel some where? I'd like to
learn some of these not-so-obvious methods for working with spreadsheets.

V

"Don Guillett" wrote:

Simply format to merged cells with the text size increased.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Voodoo" wrote in message
...
Hi,

Using this template, named "Commercial Invoice", as an example
(http://office.microsoft.com/en-us/te...T101172551033),
look at the lower 1/4th of the form, left side, just below the "sub-total"
section, there is a section named "Total Number of Packages". Below that
there is a part, a box, with no grid lines for the space of two rows, but
only on the left; the right side of the form has an area with row lines -
and
the two sides share the same linear space. Also, within the left box is a
large "6" that takes up two rows without changing the height of the row
(as
far as I can tell).

Question: How were those two presentation/formatting items accomplished?
If there is some resource online that can teach me this, you are welcome
to
simply point me to it (if the knowledge is buried within that resource,
please let me know that) instead of using up your time to make a
mini-tutorial just for me. :-)

Thanks.

V