how can I isolate the data in a worksheet from the rest of the pa

D

delray

After I have created an excel worksheet, how can I make the worksheet look
more professional by putting a border around the data and hiding all the
other lines in the worksheet?
 
C

carmen

After I have created an excel worksheet, how can I make the worksheet look
more professional by putting a border around the data and hiding all the
other lines in the worksheet?  
Click to expand...

If you select the entire worksheet and format the cells to have a
White Bickground Pattern, it will get rid of all the lines on the
sheet. Then, select your data cells. Format cells again to remove
the white fill on just those cells. While you are in the format cells
dialog window, hit the Borders tab. You can select borders of various
widths, colors and patterns to add around the data.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help? with extracting unsorted data from a worksheet, no blank lin 4
data from excel worksheet update with another excel worksheet 8
Modify a value in a dependent worksheet and then update back to thesource worksheet. 3
Copy data from one worksheet to another 4
identifying data from a separate worksheet 1
how to automatically update a second worksheet when data inserted 2
How can I set a "page end" point on a large worksheet? 3
How to use multiple command button to copy user form data to multiple worksheet 0

Top