I have a file I use at work to track the people I deal with daily. Right now it’s a word document and is alright, but one thing I have to do is tally up how many calls of each type I get and being a lazy person think it would be easier if I used Excel for the tracking document because it could do the totals for me.
The problem is when I try to re-create this in Excel it takes up more than one page. I can’t post the word document online but I can put an imageof one page. How can I recreate this in Excel and keep it down to one page
It was spilling over the right margin but I think I got that licked as long as my supervisor doesn’t care that the bottom section of the page looks different. Now I have to find out how to add using letters
What I mean is find out how many letter n’s (cap and lowercase combined) there is in column B. If I can’t figure this out I may be able to “cheat” and just use 1 in each column as a marker so I can use a sum feature.
I can’t reduce the font size. It needs to be close to 20. When I was working othe sheet it was at 10 and fit but when when I made it 20 it is spilling over.
I can’t switch to Landscape which may work because it has to match the pages that others generate
I don’t understand. The font sizes are the same in Word and Excel. If it was 10 in Word it should probably 10 in Excel. What bad thing happens because of changing the font size back to 10?
Remember that if you used “shrink to fit” the printed font would look a lot smaller. But if you reduce the fonts size and DON’T shrink to fit, the size 10 font should look the same size in the Excel as the Word.
20 is a very large font size. Was everything in the document set to 20? Title, column headings, text in the various cells, etc.?
Another possibility is margins within the cells. I know that can be adjusted in Word tables, but I’m not sure about Excel. I can’t get to it right now from home.
Boyo Jim yes everything was set to 20. I did “sanatize” the word file and excel I made but I don’t have any public place to post them to for comaprison
So, where are you at now. Usually, when I’ve done a conversion like the, the problematic issue is the right margin, but you think you have that beat?
If that correct, then all that’s left is the length to deal with. Don’t forget there is also a top and bottom margin, the is a “center vertically” and “center horizontally” that might help or hurt. There are also headers and footer – make sure there is not text OR ‘returns’ in them. And the only other thing I can think of is row height.
Actually, I can tell just by looking at the Word screenshot that not all the text is the same font size. The column heading text is signicantly smaller than the title, for instance.
I’m looking at your actual files now, and yes, the excel spills to the right and down. I wil try starting with the Word and converting it and see what I can come up with.
Ok, I’m gonna call it a night but I do see some more additional problems, and I’ve been able to fit the spreadsheet within the left and right margins. Haven’t figured out top to bottom yes, and I will send you back a revised version of the spreadsheet tonight.
There is an extra column to the right that is part of the print area on the spreadsheet that shouldn’t be.
The column widths are different between the spreadsheet and the Word doc.
Look at the bottom of your Word pages. There is a second table at the bottom of each page, with a different number of columns and different column widths. I think it’s gonna be pretty messy to match this. I’m not really sure about the best approach. I’ll sleep on it.
