Forum home » Delegate support and help forum » Microsoft Excel Training and help » Linking Cells

Linking Cells

ResolvedVersion 2007

Mon 5 Dec 2011, 10:06 Delegate Sharon said...

Sharon has attended:
Excel Intermediate course
Excel Advanced course
Excel Advanced - Formulas & Functions course

Linking Cells

Hi

I have a spreadsheet which has several cells linking to another spreadsheet. the linking all works ok but if there is no data in the initial cell the linked cell returns a 0. How can i get this to just display a blank cell?

thanks for your help.

Sharon

Tue 6 Dec 2011, 18:46 Trainer Paul said...

RE: Linking Cells

Hi,

>Excel Options
>Advanced
>Display options for this worksheet
>de-select the box "show a zero in cells that have a 0 value"

Thanks
Paul

Tue 13 Dec 2011: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

New Normal Worksheet

Do you want all your worksheets to confirm to a certain look? Then change the Defaults!!!
1. Press Shift+F11 to create a new worksheet
2. Press Ctrl+A to select (higlight) all cells, Press Ctrl+1, make any formatting changes then click OK.
3. Press F12 (Function 12 key) click in the Save As Type, drop down, then select Template (*.xlt)
4. Click in the Save in drop-down, then find the folder; c:_program files_microsoft office_office_start. (For the underscores shown use backslash)
Name your templete sheet.xlt, then press Enter.
Sheet.xlt is used when you insert a new worksheet (Shift+F11)

Note: These changes are permanent changes on your PC.

View all Excel hints and tips

Linking Cells

Linking Cells

RE: Linking Cells

Excel articles

Excel tip:

New Normal Worksheet