Hi, you can edit multiple Excel sheets at the same time using the group sheet capability in Excel. Please refer to my Youtube video link
Author: AnthonyC
Excel hack to replicate a formula down a column accurately and fast.
Hi, please check out my Youtube video for the hack to replicate a formula down a column accurately and fast. 🙂
Using Excel pivot table cache to reduce the file size of Excel workbook
Excel workbook with pivot table is a common way to analyze data. But sometimes the workbook size will get too big especially when you have
Get Excel Data from another Excel workbook using Power Query, a better method compared to using Filter formula.
Getting data from another Excel workbook using Excel formula requires the source data workbook to be open in order to perform a data refresh, but
Using Excel formula to transpose every N rows in Excel
This video uses a simple and power Excel index formula to assist in transposing data with a N rows pattern. Please see the video and
Hide unprotected Excel sheet without letting users know
Hi, in this post video, I will show how to hide an unprotected Excel sheet without letting users to unhide sheet by using the right
Welcome...enjoy coding, Electronics, IOT or data mining? Thank you for visiting my blog. 