- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
you have to turn on the border. Highlight cells that you want to add the lines to, Right click on the highlighted cells, and select "Format Cells" Then choose the boarder tab. To only do horizontal lines, simply click on the top and bottom lines. This will turn the borders on, and then they will print.
I'm not sure what Version you're using, so I'll assume after Excel 2010.
At the top of the page, under the Home tab and directly under the Font window, there is an icon which looks like a window frame (dotted all around except on the bottom edge).
In your spreadsheet you have to select the area you want to work on. You can select a single cell to add lines to or the whole spreadsheet. Click on the icon I described above and a menu box will pop down. There many choices which allow you to select lines on all sides of your work. I prefer the one at the bottom which says 'More Borders'. With that window you select the edges you want lines on, the thickness/type of the line, or put an outline.
I think that's enough for now and I hope that gets you started.
Does the bottom border show up in Print Preview? Some printers will not print the full page, to include the border if it is too close to the papers edge. If you adjust the border to be further away from the pages edge, it should print. Instead of applying a page border, you may have to draw a border using a rectangle shape and apply the desired line style. You can also try to adjust the border margin to measure from "edge of page" instead of measure from "text". This setting is on the options button located on the page border tab under the Borders and Shading window. This may allow you to adjust the margin enough to be able to print the border.
Does the bottom border show up in Print Preview? Some printers will not print the full page, to include the border if it is too close to the papers edge. If you adjust the border to be further away from the pages edge, it should print. Instead of applying a page border, you may have to draw a border using a rectangle shape and apply the desired line style.
How did you put the border? Don't use "|". Use table, or text box. By the way, if you want to have several "|" in line vertically, do with "tab". Block the area, click in the ruler to make tab stop. Make sure you have chosen the left tab (see the sign in the corner top left). Let me know if it is not clear enough
Dear subhasish, you would like to check in your page border settings. Go to formatting and then border, you must've selected border by default on settings. Change it to none. It must be applied to whole document too.
Just change the default settings and you'd be able to print without it :)