A Few Excel 2007 Tips
Posted by sindhura.sunkara on May 1st, 2008Microsoft Excel 2007 has been confusing for some of us who have been using the Excel older version. Recently, we had an opportunity for Excel 2007 training and there are a few amazing things to share.
The Microsoft Office button located in the upper left hand corner of the program window replaces the file menu found in previous versions of Microsoft office (which we all know was copied from Apple).
The quick access toolbar provides easy access to the commands you use frequently. The Save, Undo, Redo/Repeat and Quick Print buttons appear on the Quick Access Toolbar by default, but you can add and remove commands to meet your needs. To add a command to the “Quick Access Toolbar,†click on the “Customize Quick Access Toolbar†button and select “Customize†from the menu. Select the command you want to add, click the Add button, and click Ok. To remove a command from this toolbar, right click on the command you want to remove, and select “Remove from Quick Access Toolbar†from the contextual menu.
Those using excel 2007 may send out some of their files in .XLSX format. This formatted file can only be viewed with 2007 Excel version, which can be frustrating sometimes. But we can save an .XLSX file into an XLS format and then forward the file. You can also you can set the file to be saved automatically in an older version by going through the Microsoft office button, selecting excel options and then selecting the format in which you would like to save.
For users who don’t want to download Excel 2007 version, they have .XLSX conversion which can convert the file in the format you would like. If you would like to download the new excel 2007 version you can download it from here:
http://office.microsoft.com/en-us/help/HA101672621033.aspx
