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.
Trending News
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
- 7 years agoFavorite 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 GLv 77 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?
- fathermartin121Lv 67 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.