Copy visible cells only in 365?
The article says By default, Excel copies hidden or filtered cells in addition to visible cells. but when I copy filtered or hidden not included by default. Is there any setting for this in Excel 365? "If some cells, rows, or columns on a worksheet do not appear, you have the option of copying all cells—or only the visible cells. By default, Excel copies hidden or filtered cells in addition to visible cells. If this is not what you want, follow the steps in this article to copy visible cells only. For example, you can choose to copy only the summary data from an outlined worksheet." https://support.office.com/en-us/article/copy-visible-cells-only-6e3a1f01-2884-4332-b262-8b814412847e
Map Chart in Excel 365 does not identify himachal pradesh state in India
I am trying to build a series of heat maps for India providing some state level insights. When attempting to build a map chart, I realised that the chart doesnot identify Himachal Pradesh. Could someone please help me with this ? I used the following test data. States Number Puducherry 1 Lakshadweep 2 Andaman and Nicobar 3 West Bengal 4 Orissa 5 Bihar 6 Sikkim 7 Chhattisgarh 8 Tamil Nadu 9 Madhya Pradesh 10 Gujarat 11 Goa 12 Nagaland 13 Manipur 14 Arunachal Pradesh 15 Mizoram 16 Tripura 17 Daman and Diu 18 Delhi 19 Haryana 20 Chandigarh 21 Himachal Pradesh 22 Jammu and Kashmir 23 Kerala 24 Karnataka 25 Dadra and Nagar Haveli 26 Maharashtra 27 Assam 28 Andhra Pradesh 29 Meghalaya 30 Punjab 31 Rajasthan 32 Uttar Pradesh 33 Uttarakhand 34 Jharkhand 35 Telangana 36 I have added the file for reference too Thanks in advance :)