5 Things I Hate About ACL

I have 5 things I really hate about ACL. 

No, these aren’t critical issues, but I deal with them constantly, and they waste my time. All of them deal with the user interface.

Convert Report Headings into List

Occasionally you might need to convert the headings from an Microsoft Excel spreadsheet (which are horizontal) into a list (which is vertical) so you can email it to someone or include the list in documentation.

You don’t need to retype the list or even cut and paste each heading, cell by cell. My method takes a few steps, but I think it’s a lot faster and certainly more accurate. It also works with other applications than Excel. (You can also use the same method to copy a horizontal row of cell values into a vertical row (convert a row into a column), but more on that later.)

Update: Actually, I found a MUCH easier way to do it–convert rows into columns and vice versa. See these simple instructions at http://www.howtogeek.com/howto/12366/convert-a-row-to-a-column-in-excel-the-easy-way/

Advertisement

Blogging: Use the MORE tag

If you have a WordPress blog (or any blog) and don’t use the MORE tag in all your posts, you’re missing more than you think.

Every once in a while I feel like blogging about blogging…

The MORE tag ensures that only a few lines or paragraphs of a post appear on your home page (how much depends on where YOU put the tag). To read the rest of the post, the reader clicks “Continue reading” or whatever phrase your particular theme uses (my theme uses “Keep reading” by default but I changed it, as you can see here on my home page).