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
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
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.