Protecting the formatting/font in your worksheets on your computer and others

[starrehaas@gmail.com]

Hello Chandoo!


Love the website! I feel like I have a beginner question. I am an accountant and I work in spreadsheets that are shared by 3 other members on different computers. I have Excel 2010 but we have one computer with Excel 2007. I will set the font on Ariel 10 and when I close out it will be on that; as well as letting me insert lines as I please. I have found that when I go back in after my other coworkers have used the spreadsheet, the font will be different and I will not be able to insert lines in the worksheet. The error message says there are "nonblank" cells in the worksheet. When this happens, I have to start the worksheet over from scratch.


Do you know why I can't insert lines and is there anyway to lock the formatting so it stays the same throughout all of us using the spreadsheet?


THANK YOU!

 

[SirJB7]

Hi, !

Perhaps you'd want to read the green sticky posts at this forums main page so as to know the guidelines that will lead to know how this community operates (introducing yourself, posting files, netiquette rules, and so on).

Regards!

-----

Hi, !


First of all welcome to Chandoo's website Excel forums. Thank you for your joining us and glad to have you here.


As a starting point I'd recommend you to read the green sticky topics at this forums main page. There you'll find general guidelines about how this site and community operates (introducing yourself, posting files, netiquette rules, and so on).


Among them you're prompted to perform searches within this site before posting, because maybe your question had been answered yet.


Feel free to play with different keywords so as to be led thru a wide variety of articles and posts, and if you don't find anything that solves your problem or guides you towards a solution, you'll always be welcome back here. Tell us what you've done, consider uploading a sample file as recommended, and somebody surely will read your post and help you.


And about questions in general...


If you haven't performed yet the search herein, try going to the topmost right zone of this page (Custom Search), type the keywords used in Tags field when creating the topic or other proper words and press Search button. You'd retrieve many links from this website, like the following one(s) -if any posted below-, maybe you find useful information and even the solution. If not please advise so as people who read it could get back to you as soon as possible.


And about this question in particular...


It's strange that a font error arised with Arial 10, usually it might happen when using an not widely available font which is replaced by another one automatically. But not with Arial, I guess.


Regards!


PS: BTW, may I suggest you to change your nick name? It's too long and it overlaps the comment area making it unreadable (Click on your name, Edit). Thank you.

If you want to keep your email address you can put it in the website field of your profile, then when clicking on you nick on any comment the user will be led to your email.

 

[NARAYANK991]

Hi Haas ,


Are these links of any help ?


1. http://support.microsoft.com/kb/305568


2. http://www.pcreview.co.uk/forums/excel-cannot-shift-nonblank-cells-t1063252.html


3. http://www.ozgrid.com/forum/showthread.php?t=53735


4. http://www.computeractive.co.uk/ca/pc-help/2042535/can-t-insert-rows-columns-microsoft-excel


Narayan