Last week, I shared a couple of workarounds for pasting data into a filtered list. Today, see how to paste with shortcut in filtered Excel list.
Continue reading “Paste With Shortcut in Filtered Excel List”
Excel Roundup 20140428
If you’re a parent, have you had that all-important conversation with your children? Or, do you hope that your spouse will have that talk with them, because you’re not sure of the best way to approach it?
Don’t worry, Zach Rosenberg shows how to broach this sensitive topic, in his blog post, “An Open Letter to My Son About Microsoft Excel”.
Continue reading “Excel Roundup 20140428”
Problem Pasting in Excel Filtered List
It looks like a simple task – filter a list, so you an see the items you’re interested in. Then, copy data from one column, and paste it into another. But you can have a serious problem pasting in Excel filtered list.
Hide Table Details With No Macros
Last week, I was preparing reports for a client, and needed to find a quick and easy way to show or hide details in a long list. After a bit of thought, and experimenting, I found a way to do this – without macros.
You could use this technique on a table or pivot table, to make it easier to explore the data. You could also use this technique on an Excel dashboard, where real estate is in high demand!
Continue reading “Hide Table Details With No Macros”
Excel Roundup 20140421
Last week, Microsoft’s Excel team announced several welcome improvements to Excel online. The new feature that I like best is that you can now edit files that contain VBA, without the code being removed or corrupted. Of course, it would be even better to use VBA online, but we’re making progress!
Other new features include:
- Hiding and unhiding rows and columns with a right-click
- Easier access to Excel Online – just go to https://office.com and click the type of document you want to create
- Add, remove and edit comments
- Navigate quickly with the Go To shortcut (Ctrl + G)
Adding Form Controls on a Worksheet
Do you spend your days, and maybe your nights, talking about Excel with your friends? It’s amazing how quickly the time passes, while you chat about all the awesome features and tricks that you know. You know, exciting things like adding form controls on a worksheet.
Make a Better Pizza Pie Chart
While flipping through a magazine on the weekend, I saw this pizza pie chart. Yes, the pizza looks delicious, but the toppings are split down the middle. That makes the vote appear to be 50-50, not 58-42. Fun idea, but bad pizza pie chart!
Excel Roundup 20140414
Mike Alexander is having a contest on his Bacon Bits blog – create an Excel meme, and you have a chance to win a couple of Mike’s books. The deadline is April 16th, and the rules are on Mike’s blog.
If you aren’t sure what a meme is, Wikipedia describes it as an idea or picture that is shared on the internet. Mike posted a couple of examples on his blog, and here is my contribution. I’m sure you’ve met someone like this guy!
I made this in Excel, using the Insert Online Pictures command, and the text in WordArt. What can you come up with?
Center Headings Without Merging Cells
You know that merged cells are evil, and should be avoided at any cost. Those merged cells can make it almost impossible to do simple tasks on a worksheet, such as sorting or filtering. Merged cells can even make it difficult to select a range of cells – and that’s annoying, as you probably know! Here’s how you can center headings without merging cells.
Change Characters to Superscript
Do you ever use the Subscript or Superscript fonts formats in Excel? Maybe you’re reporting on chemical usage, and you need to enter CO2 as one of the row headings. Here’s how to change characters to Superscript – you could use similar steps to change characters to Subscript.