• http://www.linkedin.com/in/sanket Sanket Patel

     Hi over here you have explained about the cell formatting in Excel but what about the Linux user?? I am currently working on Linux so i need to know this type of features in Linux also.

  • http://twitter.com/AnnieCushing Annie Cushing

    These posts are targeting marketers, and every marketer should have a copy of Excel. Your best bet may be to install a copy of Windows in a virtual machine, like VirtualBox, and install Excel in that. If that’s out of your price range, I recommend becoming very familiar with Google Docs. It’s not as elegant as Excel but is a decent backup for the marketer on a shoestring budget. (But at the first opportunity you really need a copy of Excel. Seriously.)

  • http://www.linkedin.com/in/sanket Sanket Patel

     Thanks Annie for rep, i though it was talking about particular excel sheet.

  • http://twitter.com/AnnieCushing Annie Cushing

    I just included an Excel doc that I created with examples of what I demonstrated in the post (link in second paragraph). But these techniques work in any Excel doc.

  • http://www.jchweb.co.uk/ Jack Hutchinson

    Brilliant article – glad I’m not the only person who cringes at badly formatted spreadsheets! @Sanket Patel - if you’re using Linux try using Open Office. Most the the features in Excel can be found in Open Office, they’re just not as user friendly.

  • Daniel Eddinger

    How can I make my spreadsheet stop automatically aligning text to the left and number values to the right when I apply a conidtional format? e.g. I am highlighting an entire row in where teh number 2 appears in a specified column and before teh rule is applied I haev everything set to center align, but after the rule is applied, it changes the alignment in every row where the conditional format is true…..

  • Daniel Eddinger

    sorry for the typos…I was typing quickly :)