Views: 206, Replies: 4 » Jump to the end
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.
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.|
Apr 5, 2016 5:44 AM CST
I know they probably are, but I am SO stoopid.
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.|
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.|
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.