Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Excel 2016 formatting problem

Excel 2016 formatting problem

Excel 2016 formatting problem

I am experiencing a really tricky problem and I am hoping I can explain it in a way that makes sense. We have recently been upgraded to Office 2016 at work. I am creating a workbook that is going to be shared with many different people. I have spent days formatting the workbook so that it is neat and tidy and properly formatted etc. I sent it out to the stakeholders for review and one has come back totally ripping it to pieces saying that there are loads of tabs where he cant see the full questions etc. Ive gone into it today on my screen and its perfect. Did a screenshare with a different colleague and some tabs are fine for her and others are cutting off the text. It appears that every different machine displays the workbook differently. On my computer it looks perfect but clearly thats not the case for everyone. I am not sure if this is a solveable problem with code (or any other method of formatting) or if it is unavoidable. Any suggestions are more than welcome because i dont know where to begin to resolve it

RE: Excel 2016 formatting problem

We usually are not very crazy about images of how your Excel looks like, but in this case it would be helpful to see what you have. One image: how does it look like when it looks OK, and another one with the 'wrong' look.

---- Andy

"Hmm...they have the internet on computers now"--Homer Simpson

RE: Excel 2016 formatting problem

I have sorted it

I have protected the worksheets whilst allowing the user to change the size of the rows. That way they can alter them as needed without destroying the formulas

RE: Excel 2016 formatting problem

This can often be down to differing printer drivers ...

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close