+ Reply to Thread
Results 1 to 3 of 3

How to make right side of spreadhseet blank

  1. #1
    Forum Contributor
    Join Date
    09-30-2015
    Location
    LA my baby
    MS-Off Ver
    2013
    Posts
    727

    How to make right side of spreadhseet blank

    Hello. I formatted a dashboard up to column T. How can I make the rest of the sheet to the right sort of dissapear. Image attached. Thanks.
    Attached Images Attached Images

  2. #2
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,688

    Re: How to make right side of spreadhseet blank

    Remove the grid lines in the Page layout Tab
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

  3. #3
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,446

    Re: How to make right side of spreadhseet blank

    Here's how:

    ROWS:

    Select a cell in a row beneath the work area of your worksheet.
    While holding down the CTRL + SHIFT keys press the down arrow on your keyboard. This will select a range of cells from the cell you selected down to the last row of the worksheet (i.e. row 16,556).
    Select Format, Row, Hide.

    COLUMNS:

    Next, select a cell in a column to the right of the work area of your worksheet.
    While holding down the CTRL + SHIFT keys press the right arrow on your keyboard. This will select a range of cells from the cell you selected over to the last column on the far-right side of your worksheet (i.e. Column IV).
    Select Format, Column, Hide.

    http://www.theexceladdict.com/_t/t031014.htm

+ 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. Updating Master spreadhseet with values from Monthly Spreadhseet
    By Roland84 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-18-2016, 02:27 PM
  2. Avoid looking up all rows in a column to make spreadhseet faster
    By rash799 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-24-2015, 05:56 PM
  3. How to make side by side floating bars?
    By S K ROY in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 11-14-2011, 05:53 AM
  4. [SOLVED] Can I make a graph with side-by-side pie charts?
    By EAS in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-18-2005, 10:05 PM
  5. [SOLVED] How do I make a stacked column chart with side-by-side comparison.
    By Tim in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-08-2005, 11:05 PM
  6. Replies: 2
    Last Post: 03-17-2005, 01:06 PM
  7. Make 1 long Column into side by side
    By rgdavis in forum Excel General
    Replies: 0
    Last Post: 01-27-2005, 02:09 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