PDA

View Full Version : Excel problem



baudinet
03-06-2003, 04:03 PM
Can someone please advise how I QUICKLY fill in a cell
in Excel with the same letter or number etc, to create
an identical item across a number of cells.
ie 2222222222222
or babababababab
or --------------------

godfather
03-06-2003, 04:19 PM
Type the characters in the cell at the beginning of the row or column.
Select the small black square on the corner of the selected cell with the desired string in it.
The cursor will turn into a small + when you have it aligned.
Drag the cell by that corner over the desired range of cells, keeping the left mouse button held down
Release when you get to the end point of the range

B.M.
03-06-2003, 04:43 PM
Just as gf has described, but if you want to have bfbfbfbf alternately across the page you have to highlight the first two cells and drag them both.

baudinet
07-06-2003, 02:28 AM
Thanks to you both, but try it with
=======
and a gap appears.
How do I get it to be continuous ??

godfather
07-06-2003, 05:22 AM
either enlose the ============ in quotes, so its "=============" or do not use the = symbol, as excel expects it to be followed by a formula.
Make sure that after you have typed the first cell, you press "enter"
Only have that cell selected.
Then drag as discussed above.

godfather
07-06-2003, 05:30 AM
Further, the first cell should have ="========" (the first = not enclosed by the quotes)

However you may be seeing the difference in each cell between the displayed width and the number of = in the cell, and that may leave a space at the end of each cell.

If you are trying to make a continuous line of characters as a visual break, then first select the blank cells and then go FORMAT - CELLS - ALIGNMENT - TICK "MERGE CELLS"
That will make the strip into one long cell into which you can type a continuous string.

Or, try just typing a long line into the first cell anyway, it should splill over into empty cells to the right.

Or, use Drawing Tools to insert a line

Many ways.

Thomas
07-06-2003, 08:58 AM
While you are at it GF what is the meaning of life?;)

baudinet
10-06-2003, 02:11 AM
Ok - got it. Many thanks. Brian

robo
10-06-2003, 09:04 AM
I watched this with interest, and thought the original question was how to fill a cell with a given character or characters.
In the old days you could type in \= and it would fill a cell with the = symbol no matter how wide it was. Was handy for headings and layout. It doesn't work at all nowadays.

In Excel, you can do this:

=REPT("w",CELL("width",C10))

The REPT means repeat, and the CELL function returns information, in this case "width" (but there are heaps of other ones). I did this in cell C10. Sadly, due to proportionally spaced fonts, the w is too wide and overflows the cell and an i is too narrow and barely fills half the cell.
If you're bored, check out the CELL command, it looks quite interesting.
robo.

baudinet
22-06-2003, 09:33 AM
Thanks robo.
You are quite right, it was easier in the "old days" !!!!!
I'll try your suggestion.
Cheers