20210131 2225
source
[1] "www.xelplus.com/excel-hidden-information/"
intro가 맘에 드네..
| In most cases when you start to work at a new company you take over the existing Excel workbooks of your predecessor and continue to update and expand on the workbook. Normally these Excel files are quite large and contain many tabs and it’s not always clear if there is hidden information such as comments, personal information, hidden rows etc in the file. Some hidden information can be deliberate whereas some might be unintentional. To find all this out manually can be time consuming. That’s where you can use the Inspect document feature. |
* from [1]
'[PA] 업무자동화 > [XL]Excel & VBA' 카테고리의 다른 글
| XL Pivot AttributeRelationship doesnt exist (0) | 2021.02.05 |
|---|---|
| XL cant find project or library (0) | 2021.02.05 |
| XL pivot, parallel labels(나란히 보기), measure(측정값), concatenateX, % bp (0) | 2021.02.01 |
| XL 연결된 셀로 이동, 수식 분석 Trace (0) | 2021.01.14 |
| XL 북붙, 지우기, 시트 추가 (0) | 2020.12.25 |
