+ Reply to Thread
Results 1 to 7 of 7

Why all these other pages with "Click to add data"?

  1. #1
    Registered User
    Join Date
    11-06-2012
    Location
    Cincinnati, Ohio, USA
    MS-Off Ver
    Excel 2010
    Posts
    21

    Question Why all these other pages with "Click to add data"?

    This I am sure is a stupid question, but why are all these extra pages showing up on my screen and how do I show only the pages that I am working on and have content in? My pages go from column A to column G and have 44 rows . To the right of the page I am working on are other pages with "Click to add data" and are grayed out but still visible. How do I not show these other grayed out pages, the ones that have "Click to add data" in them?

  2. #2
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Why all these other pages with "Click to add data"?

    You are in Page Layout view.

    Click View > Normal
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

  3. #3
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Re: Why all these other pages with "Click to add data"?

    You are in "Page layout" view..
    Click on the "View" tab then choose "Normal"
    Click *Add Reputation to thank those who helped you. Ask if anything is not clear

  4. #4
    Registered User
    Join Date
    11-06-2012
    Location
    Cincinnati, Ohio, USA
    MS-Off Ver
    Excel 2010
    Posts
    21

    Question Re: Why all these other pages with "Click to add data"?

    Isn't there a way to be in page layout and only see the layout you are working on. I really thought I was able to do that before.

  5. #5
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Why all these other pages with "Click to add data"?

    You could hide the columns to the right / rows below your 'page' ?

  6. #6
    Registered User
    Join Date
    11-06-2012
    Location
    Cincinnati, Ohio, USA
    MS-Off Ver
    Excel 2010
    Posts
    21

    Re: Why all these other pages with "Click to add data"?

    Okay, maybe that is how I had it set up before. How do you do that?

  7. #7
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Why all these other pages with "Click to add data"?

    Select range H1. Press Ctrl-Shift-Right Arrow. On the Home ribbon, Click Format > Hide & Unhide > Hide Columns.

    Select Range A45. press Ctrl-Shift-Down Arrow. On the Home ribbon, Click Format > Hide & Unhide > Hide Rows.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Column X-Ref list - Sheet1 Col A "pages", Col B:FL "Req" to Sheet2 ColA "req", ColB "page"
    By excel-card-pulled in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-07-2017, 09:30 AM
  2. Toggle BackColor of labels in Userform through "click" and "double-click"
    By ahmerjaved in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-20-2013, 02:08 PM
  3. VBA - IE - click on "Open" in an internet explorer "file download" window
    By victoire in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-22-2013, 07:08 AM
  4. Difference between manual "click" of activeX checkbox and coded "click"
    By clemsoncooz in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-23-2012, 10:51 AM
  5. [SOLVED] Disable "Right Click" ... or any ability to "cut", "insert", etc.
    By jonvanwyk in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-23-2011, 09:26 AM
  6. Replies: 2
    Last Post: 02-24-2009, 03:52 PM
  7. Replies: 8
    Last Post: 01-04-2006, 12:10 PM

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1