+ Reply to Thread
Results 1 to 2 of 2

Can someone tell me how this worksheet is changing the unused cells? And how to recreate?

  1. #1
    Registered User
    Join Date
    03-09-2015
    Location
    US
    MS-Off Ver
    2010
    Posts
    26

    Can someone tell me how this worksheet is changing the unused cells? And how to recreate?

    The attached file I received from outside my company. I input dummy data. Cells with data are in white and if I add something to any of the greyed cells, the white area expands to right/bottom most limits of the data. I checked conditional formatting and VBA. Didn't see anything. I can't find the answer searching. All of the suggestions are to hide the unused cells or color them manually to grey them out.

    How was this created?
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    01-09-2016
    Location
    Perth Western Australia
    MS-Off Ver
    Office 365
    Posts
    257

    Re: Can someone tell me how this worksheet is changing the unused cells? And how to recre

    Hi

    It appears the spreadsheet is in Page Break view. Change to "Normal". Changes can be made on the "View" tab on the ribbon.

    Cheers

+ 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. Replies: 1
    Last Post: 07-23-2016, 11:50 PM
  2. [SOLVED] Way to filter out Unused space and Copy/paste onto another worksheet
    By bdouglas1011 in forum Excel General
    Replies: 6
    Last Post: 09-29-2014, 11:41 AM
  3. [SOLVED] Delete unused rows or limit worksheet to only filled in cells?
    By youngtusk87 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-30-2012, 01:03 AM
  4. MACRO to select next unused worksheet
    By NEboom99 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-05-2012, 02:49 PM
  5. Excel 2007 : Hiding unused portion of a worksheet?
    By Efuddy in forum Excel General
    Replies: 3
    Last Post: 07-29-2010, 01:05 PM
  6. How to Delete Unused Area in Worksheet
    By memjewels in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-30-2008, 03:37 PM
  7. Replies: 0
    Last Post: 09-22-2005, 12:05 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1