Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
KJSacramento
 
Posts: n/a
Default ADD A RETURN BUTTON WHEN GOING TO FORMULA REFERENCE LINKS

In the audit formula auditing section it would be nice to have a small arrow
or back button when going to links to get you back to your previous cell. It
appears I can only currently do this by going to the new GO TO box and
remembering which cell I was in last.

Also it would be nice to be able to print out a list of all the precedent
and dependent cells in a page.

One more issue is that the 'SHOW ALL PRECEDENTS AND DEPENDENTS ON A PAGE'
procedure is a little confusing. I enter = and the SELECT ALL but have to
hit ENTER to get the formula to stay in the cell for the rest of the steps
(ENTER is not in the instruction but it doesn't work otherwise). When I hit
ENTER I get the circular reference warning. At this point I believe most
people would quit. I allowed the formula to stay in the cell despite the
warning in order to proceed with the rest of your instructions which then
worked. I know the staffs I've trained before would just be confused and not
use the feature.
--
KJSacramento

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...excel.newusers
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using a formula to create named range reference [email protected] Excel Worksheet Functions 4 June 29th 05 08:03 PM
Reference to One Cell stays the same in Different Formula ISMEGORDO Excel Discussion (Misc queries) 10 June 16th 05 11:13 PM
Find and Replace Formula Links Werner Rohrmoser Excel Worksheet Functions 0 June 9th 05 12:13 PM
HOW DO I COPY FORMULA WITHOUT CHANGING CELL REFERENCE anantth Excel Discussion (Misc queries) 4 February 6th 05 12:25 PM
cell reference in formula Michael Dwyer Excel Worksheet Functions 5 December 15th 04 10:53 AM


All times are GMT +1. The time now is 04:20 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"