Archive for the ‘Excel 2007’ Category

« Older Entries
Newer Entries »

Update Links in your Excel Worksheets

Monday, January 23rd, 2012

Many, many times foks have linked information in their MS Excel worksheets and that information is updated every time you open your workbook.

There may though, come a time when you have a need to update your links manually – do you know how??

Follow the steps below:

  1. Display the Edit Links dialog box. In versions 2007-2010, click the Office button and Prepare | Edit Links to Files.
  2. In earlier versions, click Edit | Links.
  3. Select the link you would like to update.
  4. Click Update Now or Update Values (depending on your version).
  5. Click OK.

Tags: , , , , ,
Posted in Excel 2000, Excel 2002, Excel 2003, Excel 2007, Excel 2010, Microsoft Office Excel | No Comments »

Control the Display of your Formula Bar in MS Excel

Friday, January 13th, 2012

For those of you who do not know, your Formula Bar in MS Excel is located at the top of your screen, bust underneath your Ribbon or the Formatting toolbar, depending upon which version of Excel you have a license for.

The Toolbar is comprised of two parts:

  • On the left-hand side is the Name Box;
  • On the right-hand side is the contents of your currently selected cell.

Now sometimes you may need more real estate to view one of your worksheets and sometimes you just don’t need to see the information provided in your Formula Bar and the good news is that you can turn it off if you do not need it!

Follow the steps below to learn how:

Versions 2007 – 2010:

  1. Click the Office button | Excel Options to display the Options dialog box.
  2. Click Advanced on the left-hand side.
  3. Scroll down until you see the Display options.
  4. Click on the Show Formula Bar check box.  If it is currently selected, then your Formula Bar is displayed. If you deselect it then your Formual Bar will not be displayed.
  5. Click on OK.

Earlier Versions:

  1. Click on Tools | Options to display the Options dialog box.
  2. Be certain the View tab has been selected.
  3. Click on the Formula Bar check box. If it is selected then your Formula Bar is selected. If you deselect it, your Formul Bar will not display.
  4. Click OK.

Note:   You can also view your Formula Bar option from the View tab of your Ribbon or from the View menu. This operates as a toggle: Click on it one time and the Formula Bar disappears – click on it again and it will reappear.

Tags: , , , , , , , , ,
Posted in Excel 2000, Excel 2002, Excel 2003, Excel 2007, Excel 2010, Microsoft Office, Microsoft Office Excel | No Comments »

Ampersands in Excel Headers and Footers

Wednesday, January 4th, 2012

There are many times when you would like to have headers and footers that print on every worksheet in your Excel Workbook. Have you ever noticed that there are some characters that wil not print in your header and footer?  I know I have and I tried and tried to make it work but it would not! 

There was an occasion when I had a client who wanted their company name and logo in the header on every worksheet of their workbook.  Just for heck of it, let’s say the name of the firm was Bratt & Bratt. Well guess what?  The Amerpsand would not print!

I finally got to the bottom of it and now I will share it with you!

The why of it is that when you use an Ampersand in Excel, it is a signal to Excel that the next character is a special one and represents code that controls some aspect of what is printed.

To override the effect that the Ampersand has, you can simply use two Ampersands.  It should look like this: Bratt && Bratt.

When you do this, the first Ampersand is “eaten” by Excel and the second one will actually print for you.

It’s always easier when you know how isn’t it??

Posted in Excel 2000, Excel 2002, Excel 2003, Excel 2007, Excel 2010, Excel 97, Microsoft Office, Microsoft Office Excel | No Comments »

« Older Entries
Newer Entries »