Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
importing Word document into Excel 2002 worksheet.
My employer sends out report forms which we are to complete. Because he was
bullet points, etc. we have been told to create the docs in Word, then import them into the workshhet. The problem I have is that although the entire contents of the doc appear in the formula, when I enter the doc into the merged cells, the last part of the doc is cut off. I have tried autoformatting the cells, but can't get it to work. What is the best procedure for doing this? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
importing Word document into Excel 2002 worksheet.
There are limits to how much text can be shown in a cell.............merged
cells are just one bigger cell with the same limitations. 32767 characters per cell will be visible in the formula bar but only 1024 will be visible in the cell. You can add Alt + ENTERs every 100 characters to get more to show. There may be no reason to create the docs in Word and insert to Excel You can add bullets and linefeeds to cells in Excel. Alt + 0149(on the numpad)will enter a bullet. Note: Alt + Enter will give you a line feed in the cell. i.e. Alt + 0149 type some text then Alt + Enter. Alt + 0149 then more text. For numbering...........enter 1. <space text then Alt + Enter then 2. etc. Format the cell to wrap text and autofit the row. Gord Dibben MS Excel MVP On Sun, 10 Feb 2008 07:44:01 -0800, Hoosiermomma wrote: My employer sends out report forms which we are to complete. Because he was bullet points, etc. we have been told to create the docs in Word, then import them into the workshhet. The problem I have is that although the entire contents of the doc appear in the formula, when I enter the doc into the merged cells, the last part of the doc is cut off. I have tried autoformatting the cells, but can't get it to work. What is the best procedure for doing this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing Excel Worksheet into word... help needed! | Excel Discussion (Misc queries) | |||
Importing a Word Document into Excel | New Users to Excel | |||
Problem importing excel worksheet in Word and or Power point | Excel Discussion (Misc queries) | |||
How do I enter like a Word document in an Excel worksheet | Excel Worksheet Functions | |||
IMPORTING WORD DOCUMENT INTO EXCEL | Excel Discussion (Misc queries) |