New to Office 2007

  • Thread starter Thread starter Keith(Southend)
  • Start date Start date
K

Keith(Southend)

I am used to using Office 2000 and have a spreadsheet that I don't know
where to find a couple of thing, i wonder if someone could point me in
the right direction.

1. I have some macros / visual basic where I normally just drag the
modules into the newly created spreadsheet. Where can I find these on 2007?

2. I want to make the workbook smaller so I can see more cells, sort of
zoom out as it where, what button does this?

Many thanks
 
Keith(Southend) said:
I am used to using Office 2000 and have a spreadsheet that I don't know
where to find a couple of thing, i wonder if someone could point me in
the right direction.

1. I have some macros / visual basic where I normally just drag the
modules into the newly created spreadsheet. Where can I find these on 2007?

2. I want to make the workbook smaller so I can see more cells, sort of
zoom out as it where, what button does this?

Many thanks
Click to expand...

Ah, no panic, I found them in the help. Mmm, that's different ;-)
 
Keith(Southend) said:
1. I have some macros / visual basic where I normally just drag the
modules into the newly created spreadsheet. Where can I find these on 2007?
Click to expand...

You should still be able to press [Alt]+[F11] to display the Visual
Basic Editor (VBE). It hasn't changed much.
2. I want to make the workbook smaller so I can see more cells, sort of
zoom out as it where, what button does this?
Click to expand...

There's a slider control in the status bar on the bottom of the Excel
2007 window. Or look at View tab in the ribbon. There's a Zoom icon
about midway left-to-right.
 
I like to add this to Harlan's answer

If you like to push on a button then click on the
Office Button >Excel Options...Popular
Check "Show developer tab on the ribbon"

But Alt F11 is much easier

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


Harlan Grove said:
Keith(Southend) said:
1. I have some macros / visual basic where I normally just drag the
modules into the newly created spreadsheet. Where can I find these on 2007?
Click to expand...

You should still be able to press [Alt]+[F11] to display the Visual
Basic Editor (VBE). It hasn't changed much.
2. I want to make the workbook smaller so I can see more cells, sort of
zoom out as it where, what button does this?
Click to expand...

There's a slider control in the status bar on the bottom of the Excel
2007 window. Or look at View tab in the ribbon. There's a Zoom icon
about midway left-to-right.
Click to expand...
 
ShaneDevenshire said:
Hi,

Micosoft has two files to help you reorient in 2007 one is a command
mapping spreadsheet where you can see the 2003 command and its 2007
equivalent. Second is an interactive program where you choose on the 2003
interface and you see the command on the 2007 interface.

Both are free download, both are not 100% accurate

http://office.microsoft.com/en-us/templates/TC102128621033.aspx

http://www.microsoft.com/downloads/...BD-2758-47B3-9F90-93788112B985&displaylang=en
Click to expand...

Thanks for all your replies.
 
Back
Top