Excel Weekly News from Contextures July 9, 2013
Create a table with style + more Excel tips
In this week's Excel news, you'll see how to select a specific style when creating a table, show and hide details in a pivot table, and other tips. Thank you for reading the Excel news!
- Debra email@example.com
While updating my data validation with combo box page last week, I zoomed the worksheet, and Excel crashed. Apparently, I had created the perfect storm of worksheet settings -- a combo box, with its source list on a different sheet, and zoom level other than 100%.
I finally found a way to prevent the crashes, and you can learn how to avoid this situation too.
Click here to see the details, and a video that shows how the combo box works when it's not crashing: Excel Crashing After Combo Box Click
To focus on specific information in a pivot table, you can filter out some of the data. That affects the totals and subtotals, as well as the layout.
If you just want to hide some of the information, without changing the totals, you can collapse one or more of the items, or an entire field.
Click here to see the details, and to watch the video: Show and Hide Pivot Table Details
When you create a named Excel table with the Table command on the Ribbon's Insert tab, the table retains any formatting that it currently has, and the default Table Style is applied.
If you use the Format as Table command instead, you can insert a table with a specific style, and you can even remove the existing font, fill and border formatting automatically.
Click here to see the details and video, and to download the sample file: Create an Excel Table With a Specific Style
Here are a few more Excel articles that I read this week, that you might find useful:
In this video you'll see how to show subsequent questions in a survey, depending on the answer in the first question. This technique uses conditional formatting to hide the cell contents. Sorry, the video is a little blurry -- I guess my recording equipment was on the fritz that day!
For details on how this is set up, please visit my Contextures blog: Create Secret Hidden Questions in Excel
The daylilies are blooming in our back yard, and they certainly add some beautiful colour to the garden. The best thing about them is that they thrive on neglect -- I just ignore them, and they come back, year after year.
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.