This is a fun and quick poll.
I want to know what is the maximum number of cells you can see when you open Excel. Do this:
- Open Excel, Maximize the window if it is not.
- Just tell me the bottom right cell that you can see completely.
- Go have a good weekend 🙂
PS: Make sure you set the zoom to 100%.
I will go first. I have 2 monitors.
On the large 24″ monitor, I see cell AC40 and on the 16″ laptop monitor I see S26.
What about you?
Just post the cell address in comments.
Check out previous polls.
PS: I am planning to use the poll data to make a visualization on how many cells you can see. So please respond.
4 Responses to “Currency format Pivot fields with one click [Friday VBA]”
As in your example, I often find myselve having to format numbers as kU, MU,%, or increase/decrease decimals. In the PowerPivot utilities add-in, I have included several such formatting macros and made them available from the pivot table contextual menus. Thanks for you post. It reminds me that formatting as currency is *currently* missing.
The add-in is free and the vba code open.
https://www.sqlbi.com/tools/power-pivot-utilities/
I almost never format my pivot tables. I only format my final chart/table or whatever.
And when I do format them, I go the long distance. Keeps my clicking ability in shape. 🙂
I'm with GraH
I rarely if ever format PT's
Just hover your pointer on field header, it turns into down arrow then click. Entire pivot field gets selected then click on currency($) symbol from home ribbon or Press Ctrl + $(Ctrl + Shift + 4).