I have a report that has percentage of row totals that just displays as 100% for the grand total column. I want to hide that percentage of row column does anyone have or know a macro that can do that? it will be a very big help. I've attached the excel file below to see the pivot tables.
Use Custom Format
;;;
If you arehappy with the results, please add to the contributor's
reputation by clicking the reputation icon (star icon).
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
To undo, select Thread Tools-> Mark thread as Unsolved.
http://www.excelaris.co.uk
Hello Robert !
Currently I am using excel 2003.
I have copy pasted a list of entries from a xls sheet into another excel sheet. so the problem which I am encountering right now is , the listed entries show bit blurred background and are not sharp enough. So I just wanna ask is there any way that I can them up???
Your help would be greatly appreciated.
thanks in advance !
Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks