Why do you need to keep it to one page? And what are you doing with the information?
The point is, is “How do I duplicate this Word doc in Excel?” really the question you should be asking? If you approached the issue as “How do I improve my methods of entering and tracking data?”, would you end up with a different solution?
I need to keep it to one page because that’s the form my office uses. My handwriting is terrible so I’ve been given approval to use electronic means to keep my tally sheets as long as the output looks reasonably close to the official sheets.
I understand that at some point the original sheet was made in Word but I am unable to get access to that original file if it still exists
You can’t force a table to overlap into the footer. You can cause tables to bleed out into the left and right margins but not header or footer; Word just floats the rows that don’t fit onto the next page. You can adjust the margins and header and footer size to minimize/eliminate the header and footer, though.
If you’re just totalling a column of numbers, you can do that in a Word table.
No, I’m pretty sure you can’t.
It is possible to merge cells in those bottom rows, so you end up with 7 columns of larger cells rather 12 comumns like in the rows above. But, you won’t be able to do much with the columns widths, beccause whatever you change there will also change the columns above. I don’t see any easy solution.
You could actually construct a text and graphics object and drop it in there as a kind of footer, but that’s rather clunky,
I agree with Hunter Hawk. What is the problem that you are trying to solve by doing this conversion?
He’s talking about an Excel sheet, though it was originally made in Word.
Well, you seem to have it in Word… otherwise, what is the document you sent me? Why won’t it work?
That is one that I have made in word. I’m gotten “counseled” lately because I have not tallied up some of the numbers at the end of the day. If I had this in Excel I could make it tally for me and not have to worry.
At the end of the week they get filed away for a year . We have to save them in case of an audit then they get shredded at the end of the year.
So is your office standard “There shall be 30 rows per page”? What happens if a workers does enough stuff that a 31st row is needed? Or if it’s a slow day and only 17 rows are needed?
If the business goal is to track information, ISTM like something like a database would be more appropriate. If all the employees are doing is manually writing stuff down, that information is static and you can’t do anything with it (like generating reports or what-have-you) unless it’s transcribed through some sort of data-entry process anyway.
Yes if we go over 30 contacts then we start a second page and so on.
The papers are used for random audits of productivity or if a supervisor wants to see how much work was done by employee X on day Y they can pull the papers.
Other than that there is no tracking of the data.
Ok, your row heights in the Word doc are significantly smaller than the rows in the Excel sheet. If you make the row heights and column widths the same, the excel sheet will fit onto one page.
Leave one blank row underneath row 30. On the next row, put in title for each of your sums, and maybe skip a coumn between each title so the text doesn’t run together. In the next row down, put in your sum or count formulas under the appropriate label. You can format a box around each total to make it look nice. IMO, that is a good enough approximation of what your boss wants to be workable.
I thank you for your help