98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Linking Cells
Linking Cells
Resolved · Medium Priority · Version 2007
Mon 5 Dec 2011, 10:06Delegate 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:46Trainer 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 information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:New to Excel 2010 - Sparklines!Excel 2010 includes a new feature called Sparklines which are tiny charts that fit into a single cell and plot data in cells from the worksheet. There are a host of formatting and styles that can be applied to them and they are really quite interesting. |
