Excel Weekly News from Contextures Apr 08, 2014
Clean up a list + more Excel tips
In this week's Excel news, you'll see how to clean up an imported list, and other tips. Thank you for reading the Excel news!
- Debra firstname.lastname@example.org
Sometimes you can import data into Excel, and eveything goes smoothly. Other times, you might need to do some work, to clean up the list. In this example, I pasted a two column table into a worksheet, but it all ended up in a single column.
Click here to see how I fixed the data, and read the comments, to see other solutions: Change Single Column List to 2 Column Table
If you have data for several departments or regions in a pivot table, you might want to send out individual results to each manager. If you lock down the pivot table, can you prevent people from seeing other regions' data?
Unfortunately, there's no easy way to do this, and you can read the details here: Protect Pivot Table Source Data
If you create a combo box with multiple columns, you can add headers, so the list is easier to understand. Also, make sure to adjust the column widths, so everything lines up nicely.
Click here to see the details: Headers on Combo Box List
Here are a few of the Excel articles that I read recently, that you might find useful:
Here are a few of the Excel articles that I read last week, that you might find useful:
If you have lottry tickets, Excel can let you know if you have a winning ticket. It just takes a bit of conditional formatting, and the COUNTIF function. You could use this technique to highlight other things too. For example, create a list of obsolete products, and highlight those on an Excel worksheet with product order requests.
On the weekend, we had fun playing a game of Snakes and Ladders. Instead of the old-fashioned flat board, we used a fancy 3D version, with slanted ladders. Then, at the end of the game, a herd of alligators stormed the board, and turned it into Snakes and Alligators. Watch your fingers -- those teeth look sharp!
Save time with our "Done For You" Excel products.
Note: I am an affiliate for some of the products mentioned in this newsletter, and earn a commission on the sales.
Contextures Inc., Copyright ©2018
All rights reserved.