| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
stop a cell from repeating its value continually across the page
i have an excell sheet that has data in cells
surprise surpise thats usually what you do with a spreadsheet yes. only problem is that the data repets itself to infinity for example ; value123value123value123value123value123value123va lue123value123 where i want value123 how do i stop this from happening? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
stop a cell from repeating its value continually across the page
value123value123value123value123value123value123va lue123value123
Is that all in one cell? Select the cell in question Take a look at this setting: Goto the menu FormatCellsAlignment tab Under Text alignmentHorizontal make sure it *doesn't* have Fill selected. Select General then OK out. -- Biff Microsoft Excel MVP "shay" wrote in message ... i have an excell sheet that has data in cells surprise surpise thats usually what you do with a spreadsheet yes. only problem is that the data repets itself to infinity for example ; value123value123value123value123value123value123va lue123value123 where i want value123 how do i stop this from happening? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to stop background from repeating | Excel Discussion (Misc queries) | |||
| can i stop repeating values? | Excel Discussion (Misc queries) | |||
| How do I stop data from repeating? | Excel Discussion (Misc queries) | |||
| how to stop repeating a number in worksheet(e.g. cell A1 is 6655 . | Excel Discussion (Misc queries) | |||
| Header - stop repeating on every page! | Excel Discussion (Misc queries) | |||
Linear Mode
