Excel questions

I am a little unclear as to what exactly is going on here, but if you "Insert" a new line (or column), it moves everything else over accordingly- you shouldn't have to manually change anything.

 

This sounds fixable but

1) we'll need to see a copy of the file. Just take the confidential stuff out and replace it with non-confidential stuff... (leave the structure the same)

2) You (or your boss) may have to change your use model a bit. (ie, color coding ever other line manually)

 

Is it set up as a list or as a List? Excel has a List Manager, which is a rudimentary database subroutine. Is that what you have?

The file looks pretty complicated for that, way over my head in terms of experience using List Manager.

But, when you add an item, how do you do it? If you Insert Cells, doesn't that cause everything, including color, to shift down? Then the number on the left would be off...

Could you set up the first column to be
A:1 1
A:2 =(A1+1)
A:3 =(a2+1)
etc. ??

The rows that aren't numbered might mess that up however.

 

How do I turn the List Manager in Excel off?

Hi!

I am a new user of MAC due to work.

I accidentally turned the List Manger on in Excel and can't figure out how to turn it off. Please help!

Thanks!

P.S. I hate MAC! Everything is backwards here!

 

@tgmyers: It would help to know what version of Excel you are using on your Mac, whether it is Office 2004 or 2008. According to the last post in this forum for Microsoft Office issues, you can disable it by right-clicking on a cell and choosing "Remove List Manager".

P.S. I would also recommend in the future not resurrecting an 8 month old thread which just happens to have Excel in the title but very little to do with your present issue.

P.P.S. I think you would enjoy using your Mac more if you didn't feel like you were pushed into it by your work. It will take time to get used to it, the more relaxed you are about it and less stressed out, the easier it will go. Hopefully, at some point you will get acclimated to using the Mac OS and it will become second nature like using Windows seems to have been for you before.

 

JediMeister,

Thank you for your reply. I am using Excel 2004. Unfortunately I cannot right-click because I have a stupid MAC mouse too!

I wrote in this thread because I thought the opposite - that I would be noted to not open a new topic when a thread already exists... I guess the rules are different here...I will open a new topic then as my problem has still not been resolved.

I hope so too. If it wasn't for having things to be done fast at work sometimes I would certainly enjoy learning this sucker...

 

Three things:

• The right mouse button replicates the [control] key. To "Right-Click," press the [control] key while clicking.
• There is something about newbies and necro-posting.
• Many switchers come into the Mac community with preconceived notions. However, they also come in having spent years learning very bad computing habits along with remedies to the numerous and sundry Windows maladies. You really are in a new land. You must learn new ways. You cannot unlearn old bad habits and learn good new habits overnight. Give yourself time.