The Basics Calculations Special Features
Format Cells Statistical Functions The Fill Handle
Worksheets Quick Functions Charts (Graphs)
Edit Cells The IF Function Sort Data
Rows and Columns VLOOKUP Function Filter Data
Find and Replace Formulas First Aid
Home
Word Training
Updates
About
Guestbook
Links

Where the heck are the buttons?

"Save", "Undo", "Redo" - Quick access toolbar
"New", "Open", "Print", "save as..." - The Office button
Where is the zoom?
Where is the "Freeze Panes" option?
Where are the "Format Cells" and "Page layout" dialog boxes?
Where is the "Change Worksheet Direction" button?

To anyone who is accustomed to older Excel versions… (XP, 2003 etc.)

Yes, when I first started working with Excel 2007, I was in shock too.

I tried to start and work as usual… but very soon I got stuck on the very basic issues: where is the “save” button? Where is the “undo”? Where is the “open” button? I found myself every other minute looking for a button or a feature from the former Excel versions.
And when I’m looking for them, I start to doubt – do they still exist, or were they replaced by something new and “sophisticated”?

Apparently – there is no need to worry – everything is still there, you just need to know where to look for it. When you get used to it (some quickly and some will have to take the time…) – you get back working efficiently.

In the above video clips I present the new locations of the buttons and features we are all accustomed to from the older Excel versions.