I use the old Office 2K version of MS Excel, and it's giving me fits.
I need to create a sign-in sheet for an event, and I canNOT make the damned thing print out a page that I set up with columns and rows, neatly lined for folks to write upon.
Surely, there MUST be a way to force it to print out the entire blank form, instead of the single row dead off in the middle of an otherwise blank page??!!
I need it to print out all of the lines for each row, and the column dividing lines, but without anything filled in to any of the cells.
HELP! Is this even doable?
@ DzyMsLizzy, I will bet you the farm that Marisa will know what you need to help you.
Hi, I would recommend adding borders to your cells on the excel sheet...but hey - looks like it already worked for you!!!
I think I may understand what you are saying. You see the boxes on the screen but they don't show up when you print? If this is the case, you will need to go to each cell and left click it to add borders which create the boxes?
Yes, to print out empty cells, you need to give them borders. Highlight the entire area you want to print. Look up to the toolbar for the border button (it probably looks like a square divided into four). Click on the drop-down arrow and the border options will come up. Look for the one as described above - a sort of window pane effect.
Another trick is to go to the very last cell that you want to print and place a period in it... like this
There use to be a way to set the Print Range. You highlight the cells you want printed and then when you go to print it only prints that range.
The other way is to select all the cells you need printed and the on the printer options screen select the option to Print Selection instead of printing a page.
I tried that first; print selection gave me a blank page with only the headers and footers, and a single set of cells in the exact geographic center of the page!
HOWever, I did try the 'borders' option, and that did work! YAY! So, I now have my sign-in sheets. Thank you so very much, Bev!!
The easier way to make a form for people to fill out is to use a table in Word.
I tried to do that, also, and could not make it work worth hang.
The trick with tables in Word is to change your settings so that it shows all the non-printing marks. Then you can see exactly what's happening.
If you still need help with this, just message me what kind of sheet you need (the particulars of what you are needing). I believe I can make you one pretty quick
Then you can just save it and write over it if you need to make a different one.
by romper205 years ago
I just updated my profile page which before was a bit scattered around and confusing to some. Let me know what you think and if i should fix any of the content or structure of my introduction.Kind...
by VivBounty8 months ago
Can someone please help me? I've seen some really sub quality hubs out here. I write well and yet my hubs are being unpublished and continuously picked on for sub quality. I'm offended. You're making it not fun to be a...
by Shadesbreath6 years ago
So I started a page on Facebook and I thought I would be able to send out a thrilling announcement with the url to the people in my fan/follower base (I went to a lot of trouble figuring out how to get the neat and tidy...
by naresha5 years ago
Hi Members.... I am new to this Hubpages.com. After creating new account, I posted new article and it show that "This Hub is not published, only you can see it." - Need Help in this...
by samboiam7 years ago
How do I take a picture of a web page?
by sandra rinck7 years ago
I grind my teeth, my front teeth and bite my cheeks and lips. I cannot stop. How do I get help? I chew bubble gum, Trident cause it is approved by the ADA, but as soon as I spit it out, there I am...
Copyright © 2017 HubPages Inc. and respective owners.
Other product and company names shown may be trademarks of their respective owners.
HubPages® is a registered Service Mark of HubPages, Inc.
HubPages and Hubbers (authors) may earn revenue on this page based on affiliate relationships and advertisements with partners including Amazon, Google, and others.