• Formulas
  • Excel Tips & Tricks
  • Excel Charting
  • Tutorials
  • VBA
  • Book Store
  • More
    • Blog
    • Download Area
    • Excel Video Tutorials
You are here: Home / Excel Tips& Tricks / The New Excel 2007 Interface Explained.

The New Excel 2007 Interface Explained.

October 17, 2011 by Barbara

If you are a casual user, data junkie or number cruncher, from Excel 2007 onwards Microsoft has changed the face of their application. If you or your organisation has just upgraded or is looking to (as in my main employer at the moment) then how you use Excel has or will in the near future change forever. Change is good though right?. …RIGHT!

By changing the way we interact with Excel 2007 onwards Microsoft I believe has unleased way more power of Excel to the users. You will have to learn how to navigate the new ribbons, simply make then your friend and learn to love it, so let’s cut the Ribbon and open a new chapter of Excelling.

To help you get to grips with this new Graphical User Interface (GUI) the main component are parts are explained below. You can then download a copy of my FREE Excel Ribbon User Guide at the end of this post to really tie this down and get to grips with the new way of interacting with Excel. You will soon be flying with this new way of working.

The Office Button

Any recent files you have opened will be displayed when you click on the office button, along with a few basic commands and the extensive menu that sits in the Excel Options. In here you find menus to change calculations, some display commands and all of the options previously found in the prior versions of Excel.

Pin it! Share on Facebook

The Quick Access Toolbar(QAT)

Once this is set up- everything you have decided you need to hand, will be. No clicking on menus and sub menus- this is the beauty of the QAT, set it up yourself and away you go! You have the option of stoing up to 1000 commands on your QAT. All you need to do is go to the small arrow to the right of it and select ” More Commands”. You will see the window below:

In the top left text box you san select to see Popular Commands or All Commands, jut select the command/s you want and hit Add. Once the command/s have been added to your QAT. Use the up anddown arrows to move the position of each of your commands then hit ok. If you want start again with the defualt settings for the toolbar then hit Reset.

Depending on the type of things you use Excel for your QAT might look very different to someone elses. As I use a lot of Visual Basic, Macros and data analysis and as such my QAT reflects that.

The Scrollbar

This remains pretty much unchanged from previous versions of Excel. Once great feature however is the double arrow just below the formula bar, this expands the active cell and allows you to display way more of the active cell contents. This I find great for looking at long formulas. Also just below the double arrow is a mini sign which hone clicked splits your screen in two.

The View Toolbar

A great addition is the View Toolbar at the bottom of the screen giving you a choice to display your screen either normally , with Page Layout and Page Break Preview, as well as a slider that lets you easily zoom in and out of your document.

The Excel Ribbons

At first the Ribbon idea maybe off putting to many users, but to be honest most people I have talked to on this subject have found it way more intuitive and easier than the old Excel Menus and Submenus, once you get used it it. The Ribbon is made up of numerous components, basically it consists of Tabs with Command Buttons arranged in Groups.

Pin it! Share on Facebook

Tabs-the tabs bring together the commands needed to carry out Excel’s core tasks. Contextual tabs display any additional commands and tools but only when you are working with a particular object in a worksheet- for example a graph.

Groups-the groups organize any related command buttons into subtasks normally associated with the Tabs larger core tasks.

Command Buttons-in each group command buttons used to perform an action or open a gallery form which you can select a particular thumbnail.

Dialog Box Launcher-in the lower right corner of some groups you will find the launcher where you can find more options related to that group.

Want to know more and get ripping with the Excel Ribbon just click this {filelink=3} for a free Ebook Guide. It includes a guide to all of the different Tabs and what each one does and few extra tips to get you on your way to ripping it with that Ribbon.

Filed Under: Excel Tips& Tricks Tagged With: Excel

Comments

  1. Oheneba Frank Gyasi says

    May 27, 2016 at 7:06 am

    Very useful info keep it up

Tags

Blog Cells Excel Excel Charting Excel Formulas excel tip Excel Tip Category Excel Tips Excel Tips& Tricks excel tutorials Excel Videos Excel Video Tutorials formatting Formula formula friday Formulas macro Macro Mondays Macros Pivot Tables Power BI Power Query Tutorials vb VBA Worksheets

Recommended Excel Resources

Free Excel Dashboard Webinar

Copyright © 2019 · Enterprise Pro Theme on Genesis Framework · WordPress · Log in


Share

Tweet

Additional Info

Need Answers To Excel Questions Like These?

*How Do I Create A Timestamp In Excel?
*I Want To Change The Width Of The bars On My Excel Chart
*How Can I Find Out The Length Of My Text in Excel? Click the link below to receive more Excel tips' and my Free Ebook

Sign Up For My FREE Excel Tips Newsletter and receive your own E-book of my Top 50 Excel Tips.

New To Excel? This Is A Great Place To Start!!

excel-formulas-ad-5 Excel Basics
Scrollbars
Colour of Sheet Tabs
Conditional Formatting
Calculations Introduction

Advanced Excel

Power BI Webinar Excel Expert Course Excel Dashboard Course
Data Validation Lists
Create A Timestamp
Create Table Of Contents

Excel Charting

Self Expanding Charts
One Click Charts
Create Quick Dynamic Charts
Easy Combination Charts

Video Tutorials-If You Like To Learn By Watching

Subscribe to YouTube to get notified of of new Excel videos.


Self Expanding Chart
Delete Obsolete Items From A Pivot Table-Excel 2007
What Are Pivot Tables- Create Your First One
Enable The DeveloperTab In Excel

Some Fun Stuff

Pivot Table Song

Site Links

  • Formulas
  • Excel Tips & Tricks
  • Excel Charting
  • Tutorials
  • VBA
  • Book Store
  • Top Menu
© copyright 2019 howtoexcelatexcel.com
  • Privacy Policy