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.
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.
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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks