Donate SIGN UP

Excel

Avatar Image
turboped | 12:23 Mon 23rd Apr 2007 | How it Works
5 Answers
I need to make small chart in excel have no other boxes around it, if you no what I mean, just the info i've input and all else is grey. I know if I scroll across and down and hide columns and rows it will acheive the desired result but there must be an easier way. Please can anyone help. Thanks in advance (cos i know how clever you can be)......Turbs
Gravatar

Answers

1 to 5 of 5rss feed

Best Answer

No best answer has yet been selected by turboped. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.
Two possible ways
If you have no cells filled in anywhere else just ask it to print- but make sure in print setup you have gridlines deselected. You might want to put a box- borders round the bit you are printing.
Alternatively if you have data elsewhere you dont want to print then you can select the print area. Highlight the part you want to print- select file/print area/ set print area
Question Author
Sorry no, it's not for printing it's just to tidy up the spreadsheet for viewing. I have not been very clear, not sure how to explain better. I have data in a1 - g14, I need to present it when the sheet is opened on a PC so that is all the information there and everything else is grey.
Change the zoom for that sheet so that only the portion you want to show is visible
Select the cells you want plain then goto...
Format, Cells, Patterns, and set the Colour to White or Grey or whatever colour you like ;-)
Question Author
At last - many thanks ju5t1n.

1 to 5 of 5rss feed

Do you know the answer?

Excel

Answer Question >>