| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 91837 | 2008-07-20 10:03:00 | Excel/Word Question. | Poppa John (284) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 690528 | 2008-07-20 10:03:00 | Hi All. Using Excel I wish to make a Character List of five columns wide across a sheet of A4 paper. I want to put this in another folder,in a Word Document, with other stuff. When I get to the bottom of the page I want it to continue, in the same way as a word doc. does when you reach it's bottom. On the Excel page the line numbers run to infinity (?). In Word I would like them to do the same but by the page. As :- 1 to 40 41 to 80 80 to 120 Sort of. Is this possible? Thanks PJ. :help: |
Poppa John (284) | ||
| 690529 | 2008-07-20 11:09:00 | Tried copy and paste from Excel but found that Excel page breaks don't seem to carry over with the paste. However, I seem to get the right result when I Select All and change the font size until page 1 just fits at 40 items - the rest of the pages follow suit. However also - what is pasted into Word becomes a Table and so you could (Select All) adjust the row height to 'exactly xx' to achieve the same. Am I on the right track? |
coldot (6847) | ||
| 690530 | 2008-07-20 19:03:00 | Excel line numbers do not go to infinity. They used to go to about 66,000 from memory. Newer versions might have more I don't know. Search Word Help for Adding Line Numbers. You can add them to an entire page or a section. |
Bantu (52) | ||
| 690531 | 2008-07-21 00:25:00 | 65536, I am pretty sure. (I would hate to press the "Page Down" key for the whole day to find out) Cheers :) |
Renmoo (66) | ||
| 690532 | 2008-07-21 00:35:00 | Ah, almost Jamuz. "In Excel, every workbook has 256 columns and 65,526 rows. Versions prior to Excel 97 have only 16,384. These values are fixed and cannot be changed. Despite what must amount to thousands of requests, Microsoft refuses to increase the size of a worksheet" www.j-walk.com |
beeswax34 (63) | ||
| 690533 | 2008-07-21 00:51:00 | BTW you can press Ctrl+Right or Ctrl+Down to find out how large a spreadsheet is :) Excel 97-2003 have 65536 rows and 256 columns Excel 2007 has 1,048,576 rows and 16384 columns! :eek: www.imagef1.net.nz (Excel 2007) |
jwil1 (65) | ||
| 690534 | 2008-07-21 01:03:00 | Thanks people, but you are not really helping me with this problem. PJ | Poppa John (284) | ||
| 690535 | 2008-07-21 01:04:00 | instead of copying and pasteing an excel doc into a word doc i would just create a table in word with the required number of columns and rows. is there any reason why this does not suit? | smokey (13809) | ||
| 690536 | 2008-07-21 01:29:00 | [QUOTE=smokey;696021]instead of copying and pasteing an excel doc into a word doc i would just create a table in word with the required number of columns and rows. is there any reason why this does not suit?[/QU In Excel, the rows & columns are ready made. In Word they are not. Did try to do it in word but it was laborious. PJ |
Poppa John (284) | ||
| 690537 | 2008-07-21 02:16:00 | A little bit more. I have mastered the row width & it stays as I want it. Now for the column height. I have made the first column height to what I want. How do I, now, extend this down the page? PJ | Poppa John (284) | ||
| 1 2 | |||||