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 romper20 6 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 regards,http://romper20.hubpages.com/
by Kristen Howe 9 days ago
Last weekend I sent in my Benefits of a Gym Membership hub to Calorie Bee. And today it was declined for the same old reasons in the rejection email. Any ideas on how to improve it would be great, since I've thought it would be a good fit for other readers to read it on the niche. Here's the link:...
by Lucas Todesco 3 weeks ago
Hello!I am a new writer and would like some help on how to get through this Boot Camp.Any suggestions about my writing will help.You can view it here: https://hubpages.com/autos/how-to-idiot … ur-drivingThank you in advance!
by shawndaanderson 3 years ago
okay so i just got a ticket and i need to make money to pay it off. need help. advice pleasei need the money fast. so can someone please hellp me bkuz i dont have a jobb . because i do modeling . but i dont have anything coming up soon. so i need to no how to get money now.
by crazykid82 8 years ago
sorry i need help , how do you take picture that is on your yahoo page and put them on your...facebi try save picture as but the next time i try to save other picture in the folder it won't let me
by Paddy 3 weeks ago
Can I please get some advise on my two current articles that I am writing?They are the following:https://hubpages.com/money/3-Passive-In … Money-Fasthttps://hubpages.com/travel/7-Tips-for- … e-CruisersThey have got knocked back with the generic 'needs improvement' flag and I'm not...
Copyright © 2018 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.
|HubPages Device ID||This is used to identify particular browsers or devices when the access the service, and is used for security reasons.|
|Login||This is necessary to sign in to the HubPages Service.|
|HubPages Traffic Pixel||This is used to collect data on traffic to articles and other pages on our site. Unless you are signed in to a HubPages account, all personally identifiable information is anonymized.|
|Remarketing Pixels||We may use remarketing pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to advertise the HubPages Service to people that have visited our sites.|
|Conversion Tracking Pixels||We may use conversion tracking pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to identify when an advertisement has successfully resulted in the desired action, such as signing up for the HubPages Service or publishing an article on the HubPages Service.|