![](https://img-blog.csdnimg.cn/20201014180756913.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
Excel
CodingIsFun
function myProfile(){
let major= ['English', 'Computer Science and Technology'];
let career_goal = 'front-end development';
let motto = 'Pressing on is my only option';
}
展开
-
Microsoft Excel 2019 Pivot Table Data Crunching by Bill Jelen and Michael Alexander
About the companion contentThe download files for this book include all of the data sets used to produce the book, so you can practice the concepts in the book. You can download this book’s companion content from the following page:MicrosoftPressStore.co原创 2020-12-29 13:26:27 · 718 阅读 · 0 评论 -
Excel技巧分享1-利用VBA定位工作表
如果你的Excel 工作簿内有成百上千个工作表, 要查找其中的某一个工作表会很麻烦。使用下面的VBA 代码进行查询会极大的缩短查询时间。Sub GoToSheet()Application.ScreenUpdating = False SheetName = Application.InputBox("输入要查询的工作表的名称:") Sheets(SheetName).Se...原创 2018-10-31 14:45:41 · 3493 阅读 · 0 评论 -
Excel问题及解决方法汇总1-图表数据源丢失问题
今天在通过复制一份包含Pivotchart, 图表,以及链接两者的中间公式的过程中遇到一个问题,在对复制出的Worksheet操作时,Excel会给出以下提示:在网上搜索到一篇介绍如何解决该问题的经验贴,链接点此处。 显示排除DataTab >>Connections>>Edit Links 里的几个链接的外部表格没有问题。然后筛查,删除了Name Ma...原创 2018-12-01 09:49:14 · 4525 阅读 · 0 评论 -
使用VBA复制若干个工作表,并另存到新的工作簿
代码如下:Sub MoveSheets()'在下面Array中列出所有需要复制的工作表的名称Worksheets(Array("工作表1", "工作表11", "工作表22", "工作表32")).CopySet wbNew = ActiveWorkbookWith wbNew ActiveWorkbook.SaveAs Filename:="D:\folder_f...原创 2019-01-18 11:37:15 · 30762 阅读 · 4 评论 -
Convert Formula To Text String With Find And Replace Feature
Supposing you have a range of formulas in Column C, and you need to show the column with original formulas but not their calculated results as following screenshots shown: To solve this jo...转载 2019-03-26 18:23:59 · 176 阅读 · 0 评论 -
Excel Tip: Turn Characters into Superscript
原创 2019-04-10 15:28:38 · 192 阅读 · 0 评论