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 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 romper20 7 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 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 Momina Sheikh 3 weeks ago
Hey everyone in the community! I am new to HubPages. I had been a writer and poet but that was a long time ago because I fell in the trap of Chartered Accountancy. Well! can you guys help me why some of my articles are being rejected as I have started writing after a long break? I literally worked...
by mkcbishop 7 years ago
I need help with all of this, anyone want to help a mom in need?I am trying to make a little extra money, if only just for the holidays. We are in a rough spot, and I don't know where to go from here, a part time job would make me enough money for a babysitter, and a full time job would take...
by Let Me Help You 7 years ago
My hubpage is based on hubbers' questions. Just ask a question and ill answer it in my next hub in detail with images, and I also mention the profile of the asker, so it will also help you get followers. RegardsNayab S.
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.|