+ Reply to Thread
Results 1 to 6 of 6

View sheets during typing formula without referencing them

  1. 04-07-2017, 07:28 AM #1
    jamie10
    jamie10 is offline
    Registered User
    Join Date
    06-19-2013
    Location
    Manchester, England
    MS-Off Ver
    Office 365
    Posts
    24

    View sheets during typing formula without referencing them

    Hi,

    Is there anyway to view worksheets in a workbook during typing a formula without Excel automatically adding that sheet's reference to the formula?

    Sometimes I start writing a formula and click to see other worksheets during the process. Excel assumes I will make reference to the sheet I click on but sometimes I don't, and I've continued typing. This has led to the wrong sheet reference being used. I find myself having to delete sheet references a lot during typing a formula as well because it is unnecessary to have them in some cases...
    Reply With QuoteRegister To Reply
  2. 04-07-2017, 10:17 AM #2
    Aardigspook
    Aardigspook is offline
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily UK, sometimes NL
    MS-Off Ver
    Work: Office 365 / Home: Office 2010
    Posts
    2,405

    Re: View sheets during typing formula without referencing them

    Welcome to the forum.

    If you don't want to navigate in the sheets you want to look at then you can use Ctrl-PgDn/Ctrl-PgUp to view other sheets whilst typing a formula without Excel adding the sheet references to your formula. What I mean by not navigating is that you'll only be able to see wherever you were previously viewing on the other sheet - if you try to move around at all, you'll get sheet references. You can continue typing into your formula, but clicking anywhere or using the arrow keys will add to the formula automatically.

    So maybe not 100% what you want, but better than nothing...
    Regards,
    Aardigspook

    I recently started a new job so am a bit busy and may not reply quickly. Sorry - it's not personal - I will reply eventually.
    If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark this Thread as Solved'.
    If you use commas as your decimal separator (1,23 instead of 1.23) then please replace commas with semi-colons in your formulae.
    You don't need to give me rep if I helped, but a thank-you is nice.
    Reply With QuoteRegister To Reply
  3. 04-07-2017, 10:28 AM #3
    jamie10
    jamie10 is offline
    Registered User
    Join Date
    06-19-2013
    Location
    Manchester, England
    MS-Off Ver
    Office 365
    Posts
    24

    Re: View sheets during typing formula without referencing them

    Hey, thanks for your reply, good to know about this as an option. Doesn't quite get around the issue (might just have to live with it and work around it) but it's good to know!
    Reply With QuoteRegister To Reply
  4. 04-08-2017, 06:16 AM #4
    Aardigspook
    Aardigspook is offline
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily UK, sometimes NL
    MS-Off Ver
    Work: Office 365 / Home: Office 2010
    Posts
    2,405

    Re: View sheets during typing formula without referencing them

    You're welcome - glad to be of some help.

    If that takes care of your original question, please take a moment to mark this thread as Solved so others know there's an answer here (instructions in my sig). Thanks.
    Reply With QuoteRegister To Reply
  5. 04-08-2017, 06:46 AM #5
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,063

    Re: View sheets during typing formula without referencing them

    Google the camera tool in Excel and see the attached file....
    Attached Files Attached Files
    Last edited by Glenn Kennedy; 04-08-2017 at 06:47 AM. Reason: Apologies - I forgot. Excel 2010 and onwards...
    Glenn



    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
    Reply With QuoteRegister To Reply
  6. 04-08-2017, 11:48 AM #6
    Aardigspook
    Aardigspook is offline
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily UK, sometimes NL
    MS-Off Ver
    Work: Office 365 / Home: Office 2010
    Posts
    2,405

    Re: View sheets during typing formula without referencing them

    @Glenn

    I think the camera might have been available in 2007 too - according to this page it was even available in 2003.

    @Jamie10

    I didn't suggest the camera as it could potentially mean having camera 'shots' of each sheet on every other sheet if you were doing a lot of cross-referencing. Maybe a wrong assumption, so sorry for not mentioning it - it can be very useful, as Glenn's attachment shows.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. What's wrong with this ADDRESS formula? (referencing other sheets)
    By tygrrboi in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 05-12-2014, 11:14 PM
  2. [SOLVED] Issue with Complex formula only when now referencing different sheets. receiving #VALUE!
    By Shrad013 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-27-2013, 03:30 PM
  3. Complex Lookup or IF Formula referencing multiple cells and sheets
    By CKD777 in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 10-24-2011, 04:43 AM
  4. view typing on a worksheet - using Mac
    By gkp in forum Excel General
    Replies: 3
    Last Post: 03-10-2010, 03:45 PM
  5. [SOLVED] formula referencing same cells but different sheets
    By jmosso in forum Excel General
    Replies: 2
    Last Post: 02-21-2008, 02:40 PM
  6. formula problem referencing another sheets
    By jfhawk06 in forum Excel General
    Replies: 1
    Last Post: 03-25-2005, 06:09 PM
  7. [SOLVED] Referencing Sheets in a Formula
    By Christopher Anderson in forum Excel General
    Replies: 1
    Last Post: 01-31-2005, 01:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1