Search forums. Log in. Install the app. If you forgot your password, you can reset your password. JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding. You are using an out of date browser. It may not display this or other websites correctly. You should upgrade or use an alternative browser. Borders not showing. Thread starter teebruin Start date Jul 1, Joined Mar 28, Messages This is probably something stupid, but I can't figure out what the problem is.
I have a column that I've formatted with a border. You see the border is selected, and the color is set to Black. But on the spreadsheet, you do not see the border, and the border does not print.
Since it's a right hand border, I've also formatted the left hand border for the column to the right. If you're trying to do this from within Excel rather than programmatically , follow these steps: From the "Orb" menu on the ribbon, click the "Excel Options" button near the bottom of the menu.
In the list of choices at the left, select "Advanced". Scroll down until you see the heading "Display options for this worksheet". Select the checkbox labeled "Show guidelines". Tags: Excel I created this spreadsheet with Excel Version No change. Thank you. Attached Files ToDoFix. Re: Border lines are not showing for some cells Hello all you newcomers and welcome to ExcelForum, In the future please don't ask a question in an old post.
It is better to start your own thread. If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread. Old threads are often only monitored by the original participants.
New threads not only open you up to all possible participants again, they typically get faster response, too. See the file associated with post 13 in the following thread.
The file puts borders around ranges of cells using VBA. Click on any cell in the Excel Spreadsheet may not be needed. CTRL-R to get project explorer if it isn't already showing. Re: Border lines are not showing for some cells Wow.
It requires a macro to get the borders back. I'm surprised. I will heed your instructions about new posts. Thank you for the help. Re: Border lines are not showing for some cells I had the same problem with borders not showing. To apply a new or different border style, click the arrow next to Borders , and then click a border style.
Tip: To apply a custom border style or a diagonal border, click More Borders. In the Format Cells dialog box, on the Border tab, under Line and Color , click the line style and color that you want. Under Presets and Border , click one or more buttons to indicate the border placement.
Two diagonal border buttons are available under Border. To remove cell borders, click the arrow next to Borders , and then click No Border. The Borders button displays the most recently used border style. You can click the Borders button not the arrow to apply that style. If you apply a border to a selected cell, the border is also applied to adjacent cells that share a bordered cell boundary. For example, if you apply a box border to enclose the range B1:C5, the cells D1:D5 acquire a left border.
If you apply two different types of borders to a shared cell boundary, the most recently applied border is displayed. A selected range of cells is formatted as a single block of cells. If you apply a right border to the range of cells B1:C5, the border is displayed only on the right edge of the cells C1:C5. If you want to print the same border on cells that are separated by a page break, but the border appears on only one page, you can apply an inside border.
This way, you can print a border at the bottom of the last row of one page and use the same border at the top of the first row on the next page. Do the following:.
Click the arrow next to Borders , and then click More Borders. Under Presets , click the Inside button. Under Border , in the preview diagram, remove the vertical border by clicking it.
0コメント