Excel 2007 allows you to easily add or change chart titles related to spreadsheets you‘ll be creating or sharing. Excel also lets you create links within your chart titles that reference back to specific cells within a worksheet. Pretty neat huh! In this short illustrated tutorial we’re going to show you how to quickly change a chart title (assuming you already know the basics of creating charts using Excel 2007’s chart wizard). Ready? Okay! To change a chart title do the following:

Instead of adding or deleting worksheets in a workbook every time you start a new workbook in Excel 2007, change the default setting in Excel in order to start each workbook with the amount of worksheets you normally use.

• Step 1: Mouse-click Excel 2007's Office Button from within the Excel 2007 Window.
•  Step 2: Go to Excel Options Popular tab, and in  new workbook enter the default amount of worksheets you want Excel to begin with from now on.

Copyright 2008 The Q-bicle. All rights reserved.

www.theqbicle.com

Sometimes the hardest part about what you're working on is knowing when to save it, which is why Excel 2007 by default is programmed to save your work every ten minutes. Want to shorten the time it takes Excel to auto-save your work? Want to lengthen the time it takes instead? If you're like most people the choice can go either way. But just in case you make too many trips to the coffee machine, here's how:

• Step 1: Mouse-click the Office Button.
• Step 2: Go to Excel Options.
• Step 3: Go to Save.
• Step 4: Excel's Options dialog box will appear. Under the Save tab type in a new number to shorten or lengthen the time it takes Excel to auto save your work inside the Save AutoRecover Information box.
• Step 5: Mouse-click Ok.

Unless you're an options trader you need to rethink your perception of Excel 2007, and take advantage of a powerful feature conveniently ignored. Excel 2007 comes loaded with new features--everything except how to survive a nuclear attack.

This means you can save, print, and export in PDF format without the use of any third party document to PDF software or service. Yippee! Now you'll no longer be tied to the fence and can distribute workbooks and reports in PDF to anyone who does not have Excel 2007 but may need to view these workbooks (as long as their computer has a copy of Adobe Acrobat or other PDF reader).

To export Excel documents as PDF files you can either click this Excel 2007 PDF plug-in link, visit the Microsoft web site and download the PDF or XPS plug-in for Excel 2007 by entering Office 2007 PDF or XPS plug-in at the Microsoft site search box or achieve the same result directly within Excel 2007's Help window, by opening the Excel Help window and entering PDF and XPS in the search box, and from there accessing the Enable Support for Other File Formats link.

Once you've successfully downloaded and installed the plug-in you can use the Alt+FFP shortcut to publish a workbook as PDF or do it the traditional way by accessing the Excel 2007's Office Button then mouse over Save As and choosing the PDF or XPS publish option.

If you regularly work with spreadsheets and use these when you meet with your boss or client, I'm sure you know how frequent you have to work around problems and whenever you encounter some you get through these the best way you know how. Through meticulous control you can get around some, for other potential spreadsheet threats you can exploit some of Excel 2007's features. Excel 2007's Open command button features a menu which will allow you to open workbooks in different ways, so take advantage of each to the fullest:

• Open and Repair will repair a corrupted workbook and if this fails use the Extract data option which will pull whatever data it can salvage from a corrupted workbook and swap it over to a new file you can subsequently rename and save.
• Open Read-Only will allow you to view the selected workbook but will not allow you to make changes to the workbook.
• Open as Copy will create a copy of the selected workbook as a precaution  so any mistakes in changes you may make will not affect the original workbook.

Copyright 2007 The Q-bicle. All rights reserved.

www.theqbicle.com

Ever print an Excel worksheet or report whose cells were grotesquely cut off at all the wrong intervals from the rest of the worksheet analysis? Didn't you wish you could merge cell information better so the final print wouldn't have much of the meat lost? Having pondered some level of compromise, take advantage of Excel's page break preview to locate and fix undesirable page breaks in a spreadsheet you are going to print.

Here's how to prevent Excel from separating the most relevant information on a spreadsheet across different printed pages, and force Excel to print the most pertinent data in the same page. All you have to do is move the page break in order to keep certain clusters of information in tact and avoid Excel 2007 from printing such information on a separate page.

• Step 1: Mouse-click View, then click Page Break Preview.
• Step 2: Mouse-over the page break you wish to move (the page break in preview mode will be represented by dark lines and your mouse pointer will transform into double-headed arrows), then drag and drop the page break to a new location.
• Step 3: Now you're ready to print your spreadsheet.

To return to your normal window, mouse-click View then click Normal.

Trying to piece together a better Excel 2007 spreadsheet? Adding a few hyperlinks to your Excel workbooks will aid your data in spreading beyond its cells. These enhancements you add to your workbooks may perhaps be jaded by all those in adjacent offices--it always works. Here's how to add graphic or text links in your Excel 2007 worksheets in order to jump to other workbooks, documents, or web pages:

• Step 1:Locate a cell you wish to place a link in and click it.
• Step 2: Under the Insert tab on your menu bar click Hyperlink.
• Step 3: An Insert Hyperlink dialog box will appear. In here, enter the text you wish to appear as the link.
• Step 4:Select where you want the active link to jump to when it is clicked (a folder, a file, web page etc).
• Step 5: Click Ok.

Note: To add hyperlinks to pictures and shapes, simply click on the image or shape, then under the Insert tab on the menu bar click Hyperlink and follow the same steps. To remove a hyperlink, just right-click the cell, image, or shape which contains the link, a context menu will appear. Click remove link, and you're done!

Here's a tip on keeping sensitive spreadsheets as they were meant to be--sensitive. If you are among those who are passionate about keeping your entries private, here's the secret recipe for hiding columns and rows in Excel 2007.

• Step1: choose the range of columns and rows you wish to hide.
• Step2: In the Home tab, use the Hide Rows/Hide Columns options in the Cells Group/Format.

Now the entries you have in those columns and rows will be hidden!

 

Email a link of our website to a friend.

Think of all the great stuff their missing out on!

 

Copyright 2007 The Q-bicle. All rights reserved.

The Q-bicle neither warrants expressly, written or otherwise, neither is liable for any representations in content, delays or errors in content, nor actions taken due to content