Sandbox forum: Excel worksheet question

Views: 121, Replies: 4 » Jump to the end
Name: Anna Z.
Monroe, WI
Charter ATP Member Greenhouse Cat Lover Raises cows Region: Wisconsin
Image
AnnaZ
Apr 4, 2016 10:22 PM CST
I want my Excel worksheet to show the cell lines when I print it off............where do I go in all that "information" headings to find that and keep it? It is too hard to read my information without the lines.

Also, there HAS to be a way that I can change the font size and keep it without having to go back and reset it for every cell. There is something I'm missing here............LOL...........and it probably is so simple it will make me cry.
Name: Julie
Kenmore, NY (Zone 6a)
Region: New York Enjoys or suffers cold winters Container Gardener Houseplants Daylilies
Image
smiley
Apr 5, 2016 4:05 AM CST
Don't cry Anna! Both of those things are really easy, but need to know what version of excel you have.
Name: Anna Z.
Monroe, WI
Charter ATP Member Greenhouse Cat Lover Raises cows Region: Wisconsin
Image
AnnaZ
Apr 5, 2016 5:44 AM CST
Excel 2007.

I know they probably are, but I am SO stoopid. Rolling on the floor laughing
Name: Anna Z.
Monroe, WI
Charter ATP Member Greenhouse Cat Lover Raises cows Region: Wisconsin
Image
AnnaZ
Apr 5, 2016 7:14 AM CST
Ok, I hacked around and got it to print the lines, BUT..............I want to have the cell lines even if they are empty on the page. See, I want to pass it around at a meeting for people to put name, address, phone and cell phone numbers, and email addresses. Then I will transfer the info when I redo it. If the lines were there to write in.............you know what I mean, I think. Green Grin!
Name: Julie
Kenmore, NY (Zone 6a)
Region: New York Enjoys or suffers cold winters Container Gardener Houseplants Daylilies
Image
smiley
Apr 5, 2016 8:48 AM CST
I think the only way to do that would be to hilight all the extra area you want to print with the boxes, and go to the home tab (ribbon) and pick the "all border" option.

Thumb of 2016-04-05/smiley/770123

To get all the fonts the same, hilight the box in the top left corner, to the left of the "A" and above the "1". That will hilight the whole sheet, and you can pick your font from there. Everything should change if you do it that way.

Also, if you only want certain cells the same font, hold down the CTRL key and click on each cell you want the same. Then you can pick your font, etc...

I'm a novice when it comes to formulas (maybe a novice-intermediate, lol) but know a lot about formatting. I do tons of spreadsheets at work and I'm pretty anal about how they look. Smiling

[Last edited by smiley - Apr 7, 2016 4:11 AM (+)]
Give a thumbs up | Quote | Post #1106663 (5)

« Garden.org Homepage
« Back to the top
« Forums List
« Sandbox forum
You must first create a username and login before you can reply to this thread.

Today's site banner is by dirtdorphins and is called "Dianthus 'Nyewood Cream'"