How to Show Hidden Rows or Columns in Excel

My Excel Tips Blog

• Your Excel Spreadsheet Smells

  Do your spreadsheets smell? This week, a tweet from Felienne Hermans caught my eye. "Our @icse2012 paper on spreadsheet smells already has a citation before publication" Spreadsheet smells? I've seen some stinky spreadsheets, but have never read a conference paper on spreadsheet smells. It sounded intriguing, so I followed the link to Felienne's paper – Detecting and Visualizing Inter-worksheet Smells in Spreadsheets. Code Smells The starting point for the paper is the code smell metaphor introduced in Martin Fowler's book, Refactoring: Improving the Design of Existing Code. I don't have that book, so I visited Wikipedia, to see what it knew about code smells. Fortunately, Wikipedia had a helpful summary of common code smells, and I've listed a few of them below. Can you see how these code smells relate to Excel, whether you're building worksheets, or creating Excel VBA code? Duplicated code: identical or very similar code exists Continue reading Your Excel Spreadsheet SmellsRSS Footer: Thank you for subscribing to the RSS feed for Contextures Blog . You can read the full article here: Your Excel Spreadsheet Smells Please visit the Contextures page on Facebook - 23 hours ago

• Excel Pivot Table Selection Quick Tip

  To format a pivot table, you can select a specific section, such as one of the fields, or a grand total. When you point to a field heading, a black arrow will appear, if the Enable Selection setting is turned on. In the screen shot below, you can see the black arrow at the top of the Product field. Click in that spot, and all the Product item labels are selected. Click in that spot again, and the Product heading is selected, instead of the item labels. Pivot Table Field Setting Quick Tip Instead of a single click on a heading cell, you can point to an outer field heading and double-click when the black arrow appears. In the screen shot below, the black arrow is on the Bran product heading cell. Note: This trick won't work on an inner field, like Region, which has no Continue reading Excel Pivot Table Selection Quick TipRSS Footer: Thank you for subscribing to the RSS feed for Contextures Blog . You can read the full article here: Excel Pivot Table Selection Quick Tip Please visit the Contextures page on Facebook - 2 days ago

• Show Data From Hidden Rows in Excel Chart

  You can add a chart in Excel, based on worksheet data, like this sales chart example. But, if you filter the data, and rows are hidden, that data also disappears from the chart. You might like that feature, and not mind that the chart changes. In the example shown below, only the West region's data is visible on the sheet and in the chart. However, there are some situations when you want the chart to show the data, even if the data is hidden. In the next example, columns A:C are hidden, so that they don't distract from the chart. Oops! Now there's nothing in the chart. That's not the effect that you were going for.      Change a Chart Setting to Show Hidden Data If you want your chart to show all the data, even if some of the source data is hidden, you can change Continue reading Show Data From Hidden Rows in Excel ChartRSS Footer: Thank you for subscribing to the RSS feed for Contextures Blog . You can read the full article here: Show Data From Hidden Rows in Excel Chart Please visit the Contextures page on Facebook - 7 days ago