Excel Q&A
Ask your geeky hard core Excel questions here!
Questions/Discussions
Sort by Date ▼ / Top Rated
Register for free or log in at the top right of this page to join the discussion
Ask your geeky hard core Excel questions here!
2) For Excel 2016 In the Pivot Tables Section, when I get to step 3 out of 3 to set up the table, excel doesn't give me the option of clicking layout (it's greyed out). It only gives me the option to his cancel, back or finish. I'm forced to click "finish" but when I try to follow Hamilton's instructions on how to make the correct layout, the table ends up looking funky. It does not format properly and the correct results do not show. Do you have any recommendations on how to remedy this?
3) I am getting the hang of anchoring but haven't gotten it down pat yet. And we use it a lot. Is there an anchoring cheat sheet you can provide for how many times to hit the "home" key for locking in columns, rows, or both columns and rows? And definitions for the different locking types? Read More