Ask Experts Questions for FREE Help !
Ask
    munny's Avatar
    munny Posts: 1, Reputation: 1
    New Member
     
    #1

    Jan 8, 2005, 03:29 PM
    Excel gridlines
    How do I get gridlines to print when I am creating a prototype, so some cells have no data in them. I wish to fill them in later by pen. I know how to get the gridlines to print with data in the cells, but they will not print without any data in the cells. Thanks, dg
    darrel1953's Avatar
    darrel1953 Posts: 86, Reputation: 12
    Junior Member
     
    #2

    Jan 26, 2005, 03:45 AM
    Excel gridlines/borders
    This is a format issue. There is an icon for borders on the toolbar but if it doesn't show, use the format menu on the main toolbar. You can choose more toolbars in the view drop down menu. 1st you have to highlight whatever portion of the datasheet you want to show the gridlines on and then in the format dropdown menu you just choose format/cells/borders/and choose the thickness of the line and where you want it, inside and outside or whatever. Be careful when you print to make sure you are not printing every page that you can in a datasheet. You can highlight what you want to print and choose selection on your print options or you can print preview and see how many pages are going to be printed by looking at the lower left hand side of the screen. Hope this helps.

Not your question? Ask your question View similar questions

 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Excel Format [ 7 Answers ]

I need someone help. Everyday I need to format data like the following 1003, 1876, 1952, 2011, 2048, 2057, 2073, 2094, 2111, 2128 This gets pasted into one cell in a spreadsheet. I would like to be able to format it so it goes into the sheet 1003 1876 1952 etc into separate cells. Is this...

Excel [ 2 Answers ]

:rolleyes: I try to use excel to print an invoice, how can I put an invoice number that will auto upadate the next time I use the file?

Excel help [ 1 Answers ]

I am using excel to record some data and I have it setup to do some math based on the info that I put into certain cells. Now what I am wondering is am I able to setup the sheet so that it will prompt me for the 4 pieces of data that I want to enter and then place those in the proper cells and then...

Insert only Partial Gridlines on Sheet [ 2 Answers ]

Does anyone know how to insert partial gridlines in EXCEL. I have a part on the sheet that has a few rows of numbers so I want to insert gridlines in just that area.

Gridlines for MS Excel Worksheet [ 1 Answers ]

Hi: I have installed MS Excel 2000 and MS Excel 2003 on my two emachines computers with Windows XP. Both versions of Excel are perfect on one computer, but they are not on the other one. On my second computer, Excel worksheets of both versions never have gridlines. The sheets or tables look...


View more questions Search