![]() |
#11
|
|||
|
|||
![]()
The real benefit of the Alternative & Pivot table is that if anything goes wrong on the pivot table you can delete and start again as the data is on the alternative sheet and in a decent format.
It would be a bit of a chore to change from the across view you start with to the alternative view. Not impossible but manual work. The outline is easy to add, just select the column you want to be able to hide then click on Data > Group (on the right under Outline) |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Mail merge field mistakenly interpret text format as date format | alan6690 | Mail Merge | 0 | 09-02-2020 01:54 AM |
Create Field That Displays Date+30, Office 2007 | Papote | Word | 6 | 10-09-2016 02:47 PM |
![]() |
DBenz | Excel | 3 | 12-21-2014 05:00 AM |
Letter date changes when merging with Excel - not the format, the actual date! | Smallweed | Mail Merge | 1 | 02-07-2014 06:00 PM |
date format | gsrikanth | Excel | 1 | 12-28-2011 05:06 AM |