Jiangws's Blog

 
 
 
  • About

    夢を叶える為
 
Insert More Than One Row in Excel June 10th, 2019
  1. To select the selected cell’s entire row, press Shift + Spacebar
    To select more rows, press Shift, and the Up arrow or Down arrow.
    To insert the selected number of rows, press Ctrl + + (plus sign)
  2. Name Range: Input
Posted in Excel for Busy People || Comments Off on Insert More Than One Row in Excel
Visualizing Merge Join Types in Power BI June 3rd, 2019
Posted in Excel for Busy People || Comments Off on Visualizing Merge Join Types in Power BI
Screenshot Insertion – Excel 2016 New function May 31st, 2019

Excel makes it ultra-easy to take a screenshot of any other open program on your desktop and insert it into a worksheet. Just go to Insert tab, select Screenshot, and you’ll get a dropdown showing a thumbnail of all the …

Posted in Excel for Busy People || Comments Off on Screenshot Insertion – Excel 2016 New function
How to remove all formula references but keep values in cells in Excel? May 31st, 2019
  1. Select the cells you need to remove all references, then press Ctrl + C keys, keep these cells selected, right click and select Values under Paste Options section.
  2. Then you can see all formula references of selected cells are
Posted in EveryDay English, Excel for Busy People || Comments Off on How to remove all formula references but keep values in cells in Excel?
How to delete all pictures or other objects in Excel easily? May 10th, 2019

Delete all pictures in active worksheet with Go To command

My Clever W’s Solution:

Select one object -Ctrl + A -Delete!

excel-tab-banner-2014-12-02
Amazing! Using Efficient Tabs in Excel Like Chrome, Firefox and Safari!
Save 50% of your time,
Posted in Excel for Busy People || Comments Off on How to delete all pictures or other objects in Excel easily?
Link a password protected excel spreadsheet to an access database December 9th, 2016

If the Excel workbook is protected by a password, you cannot open it for data access, even by supplying the correct password with your connection settings, unless the workbook file is already open in the Microsoft Excel application.

so, you …

Posted in Excel for Busy People || Comments Off on Link a password protected excel spreadsheet to an access database
如何提高Office 2013在Windows8或者8.1下的启动速度? October 25th, 2013

如何提高Office 2013在Windows8或者8.1下的启动速度?我试了很多办法,比如取消GPU加速拉,注册表的人为修改什么的,都没有用。
经过几个小时的试验,终于找到一个办法:就是:
对Office文件(Excel,Word等文件)在打开(Open With)里直接指定执行文件:
“C:\Program Files\Microsoft Office 15\root\office15\EXCEL.EXE”

原来打开隐含用的是Excel(Desktop)),我估计是因为Windows 8.1里先看Windows Store里有没有程序可用,然后再去找Desktop里的程序,所以比较慢。…

Posted in Excel for Busy People || Comments Off on 如何提高Office 2013在Windows8或者8.1下的启动速度?
Fill data automatically in worksheet cells November 9th, 2012

Instead of entering data manually on a worksheet, you can use the Auto Fill feature to fill cells with data that follows a pattern or that is based on data in other cells. This article does not explain how to …

Posted in Excel for Busy People || Comments Off on Fill data automatically in worksheet cells
1. Working with Data November 7th, 2012

Excel For BusyPeople

Posted in Excel for Busy People || Comments Off on 1. Working with Data