Microsoft Excel

Excel 2007 / Excel 2010 – Print area greyed out

I had a user today that needed Microsoft 2007 Excel help. She was unable to print an Excel spreadsheet correctly. After some questioning and watching the user flow through her process, I noticed something interesting. She was unable to print the data in the sheet tabs at the bottom of her spreadsheet. I went to…

Excel SUM ONLY Visible Cell, Row or Column – Stop Excel from calculating SUM of hidden cell, row or column

Had a user today call saying the Excel spreadsheet they created was calculating the SUM of invisible/hidden rows/columns. The problem was..they didn’t want Excel calculating the SUM of hidden rows and columns. A quick Google told me the SUBTOTAL function calculates the the sum of visible data and ignores invisible data. ALSO, from what I…