Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Need help with Excel?

I want to know how I can cut off all the other cells, and just have my document show up only as the space that is occupied. I'm pretty new to Excel. I also want to know if there is a non complicated way to put a next button on a document as if it were a book?

Is that possible?

My information is in cells A21 to T21, if that helps.

3 Answers

Relevance
  • 7 years ago
    Favorite Answer

    Click on the left corner of the spreadsheet between the column and row to select the entire spreadsheet

    Select home and fill Colour, select black

    This then blacks out all cells

    Select the range you want to display

    Select Home, Fill Colour and select white

    As Greg asked, please explain what the Next Button is to achieve then we can give you an answer

    Alternatively, select Page Layout, Background, select a picture from your picture file, click insert. This fills the screen with continious pictures. Then paste your data range on top of the pictures.

  • Greg G
    Lv 7
    7 years ago

    The only way to "cut off" the cells is to hide them. You can never really get rid of them.

    So any row or column you don't want to see, select them and right click and then click on Hide.

    As for the Next button.. exactly what do you want to do? Click it and go to the next sheet in the workbook?

  • 7 years ago

    Perhaps you are used to Word. Why not insert your excel data as an Object in a word document. Then you can format you page as you wish. You can also insert Excel objects into PowerPoint.

Still have questions? Get your answers by asking now.