![]() |
Cells & Lines
Hi, It's been a while since last I used Excel and the problem is that I forgot how to make lines :confused: . What I mean is I remember that when I click on the bottom, top, right or left of a cell then comes a line so you can create columns, boxes or whatever! It's been already two days trying to make these lines but I really can't. So my question, is there any help? Thanks in advance, foxy291 ;) -- foxy291 ------------------------------------------------------------------------ foxy291's Profile: http://www.excelforum.com/member.php...o&userid=25893 View this thread: http://www.excelforum.com/showthread...hreadid=392774 |
Hi!
Are you using the FormatCellsBorder tool? It's really easy! Biff "foxy291" wrote in message ... Hi, It's been a while since last I used Excel and the problem is that I forgot how to make lines :confused: . What I mean is I remember that when I click on the bottom, top, right or left of a cell then comes a line so you can create columns, boxes or whatever! It's been already two days trying to make these lines but I really can't. So my question, is there any help? Thanks in advance, foxy291 ;) -- foxy291 ------------------------------------------------------------------------ foxy291's Profile: http://www.excelforum.com/member.php...o&userid=25893 View this thread: http://www.excelforum.com/showthread...hreadid=392774 |
Select the cell or range of cells, rightmouse and Format Cell, select the Border tag Select a line, colour, and place it in the selected cell / range. foxy291 Wrote: Hi, It's been a while since last I used Excel and the problem is that I forgot how to make lines :confused: . What I mean is I remember that when I click on the bottom, top, right or left of a cell then comes a line so you can create columns, boxes or whatever! It's been already two days trying to make these lines but I really can't. So my question, is there any help? Thanks in advance, foxy291 ;) -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=392774 |
Select the requested cells so they are the Active cells. Press CTRL+1 then select boarders. Then enjoy your boarders :) -- fluci ------------------------------------------------------------------------ fluci's Profile: http://www.excelforum.com/member.php...o&userid=25896 View this thread: http://www.excelforum.com/showthread...hreadid=392774 |
Hi Guys, I really can't do it! :cool: Normally I don't want to make a line around the whole cell, in that case I know how to do it. I want to make only a single line where I click. For example I have four rows with six cells and I want to make only a vertical line on the right of cell A of each row to create a column. Thanks in advance. -- foxy291 ------------------------------------------------------------------------ foxy291's Profile: http://www.excelforum.com/member.php...o&userid=25893 View this thread: http://www.excelforum.com/showthread...hreadid=392774 |
All times are GMT +1. The time now is 12:47 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com