How do I find the AutoFormat Dialogue Box in Excel 2007?

G

Guest

I am currently taking an Excel 2003 class and I have Office 2007 on my home
computer. My college does not have 2007 yet. In my textbook I need to apply
certain Formats from the AutoFormat Dialogue Box. I can not find this
Dialoge Box on 2007. Can anyone help me?
 
J

Jim Rech

Cell formatting has been completely redone in Excel 2007. The equivalent
there is Format as Table on the Home tab.

--
Jim
|I am currently taking an Excel 2003 class and I have Office 2007 on my home
| computer. My college does not have 2007 yet. In my textbook I need to
apply
| certain Formats from the AutoFormat Dialogue Box. I can not find this
| Dialoge Box on 2007. Can anyone help me?
 
G

Guest

Thank you for replying Mr. Rech.
Another part to my question should have been in AutoFormat Dialog Box in
2003 there were names for each color and design. Such as "Classic 2",
"Colorful 1" etc.....,. Is there any way for me to know what the names are
of each format in the "Format as Table" tab in 2007?
 
J

Jim Rech

When I hover the mouse pointer over a style its name, such as "Table Style
Light 1" appears as a tool tip. That's the only name I see.

--
Jim
| Thank you for replying Mr. Rech.
| Another part to my question should have been in AutoFormat Dialog Box in
| 2003 there were names for each color and design. Such as "Classic 2",
| "Colorful 1" etc.....,. Is there any way for me to know what the names
are
| of each format in the "Format as Table" tab in 2007?
|
| "Jim Rech" wrote:
|
| > Cell formatting has been completely redone in Excel 2007. The
equivalent
| > there is Format as Table on the Home tab.
| >
| > --
| > Jim
| > | > |I am currently taking an Excel 2003 class and I have Office 2007 on my
home
| > | computer. My college does not have 2007 yet. In my textbook I need
to
| > apply
| > | certain Formats from the AutoFormat Dialogue Box. I can not find this
| > | Dialoge Box on 2007. Can anyone help me?
| >
| >
| >
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autoformat 2
Excel 2007 conversion in Excel 2003 3
page layout dialogue box 3
Where is the Data Import Excel button in Excel 2007 6
use copy paste function in the find & replace box 2
how can I shade alternate rows in Excel 2007? 3
changing default search location in Excel 2007 Find. 3
Search for text (across multiple worksheets) in Excel 2007? 1

Top