General Question

JLeslie's avatar

Help with an Excel question, I want to center the page on screen?

Asked by JLeslie (56675points) 2 weeks ago from iPhone

I want the page to look like a word document on screen. Or, in other words just as it will look when I print.

I have already centered the information on page and I hid the grid lines and ruler. It looks perfect.

I tried putting it in page layout view, but the page is on the left corner with blank pages where I can “add data” to the right and below. I want to get rid of those extra pages, and just have my single page with the information on it centered on the computer.

Once I set it up correctly, will it open like that for people I send it to?

Bonus question: how do I lock the formulas, but allow others to add data to the rest of the sheet. I’d prefer not to have a password on the lock.

Thanks.

Observing members: 0 Composing members: 0

10 Answers

Dutchess_III's avatar

Well, first, in the view tab, uncheck all of the grid lines, formula bars, ruler and headings. Is that more like what you’re looking for?

Protecting is kind of clunky. First highlight the cells you want to remain open for editing. Then right click to “format cells.” Then go to the “protection tab.” Uncheck the box that says “locked.” Then you have to go protect the entire worksheet (or book.) Only the cells that you highlighted and removed the check mark from can be edited.

If you don’t want a password just don’t put one in.

It should open up like that for people you send it to. You can practice on me if you want.

Dutchess_III's avatar

Oh crap. I’m sorry. I didn’t read your details carefully enough. You already hid every thing.

Dutchess_III's avatar

Argh. I’ve done it in the past. It looked like one page, like Word. I just can’t remember how!

Call_Me_Jay's avatar

It differs a little between Excel versions, but assuming it’s Windows and fairly recent…

1)
Delete columns to the left and above your data. Don’t try to center it with empty cells. The steps below will center it

2)
Set or clear a print area on a worksheet
Instead of wondering exactly which rows and columns will print

3)
Fit to one page
In this case your are going to tell it 1 page wide and 1 page tall.

4)
Set page margins The dialog box includes checkboxes for Center on page Horizontally and Vertically

That should do it if I got all the steps right. Page Layout view will show your page as it would be on paper.

Dutchess_III's avatar

But she is wanting it to show on her computer screen so that it looks like a Word document. I know how to do it, but it’s been a while…and I just got sidetracked by grandkids.

Call_Me_Jay's avatar

After the other steps I laid out, Page Layout view will make it look like a printed page.

Assuming you want to work on it. To see exactly what will print, use Print Preview.

Dutchess_III's avatar

I think what she is looking for is this, but what she’s getting is this, with prompts to “add data.” If we scroll in we get this.

Call_Me_Jay's avatar

“what she’s getting is this”

I think you skipped “Set or clear a print area on a worksheet”. And/or ” tell it 1 page wide and 1 page tall.”

Or, if you want it to print on 2 pages, it is good.

“Click to add data” is always going to be there in a working Excel window. If you need exactly like on paper, then there’s Print Preview or save as PDF.

Response moderated (Spam)
Dutchess_III's avatar

I guess this is about as close as I’ve gotten. I created this for Judi, to help with her property management business. As you fill out the master, the information autofills to the other tab.
That picture is scrolled far out. When I’m working with it, it’s scrolled closer in and fills up more of the screen, but it never looks like a Word Doc.

Answer this question

Login

or

Join

to answer.

This question is in the General Section. Responses must be helpful and on-topic.

Your answer will be saved while you login or join.

Have a question? Ask Fluther!

What do you know more about?
or
Knowledge Networking @ Fluther